@Jeremy: I think I found the reason why it the install was failing, I did use a simpler password now (only letters and numbers , a total of 10 chars in my last try) and it succeeded like yesterday in my lab (also used simple password for that specific succeeded install)... found out that when I put special characters in the password (the like RAz$&7+a&uBEjuve ) the install just break (script can't connect with the credentials to the postgresql to create the tables and the MailScanner does not start with a lot of sql queries error that I mentioned in my yesterday's posts). I hope this can clarify things... Cheers, Anis
On 18 January 2013 21:40, Jeremy McSpadden <[email protected]> wrote: > I made minor changes to the master, i am working in the build branch. > adding quite a bit of if/then statements for check points. not complete > yet, might be broken. haven't tested the code yet. > > > https://raw.github.com/fluxlabs/scripting/build/baruwa/cent6/install_baruwa2.sh > > > -- > Jeremy McSpadden > Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions > Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 > > On Jan 18, 2013, at 2:36 PM, Anis Jendoubi <[email protected]> > wrote: > > @Jeremy: installed on a public live production and it seems that the error > 500 are back again, also not prompting for the baruwa user and password :( > , when looked at the script process there was plenty of "baruwa" user > credentials errors when connecting and trying creating the postgresql > tables. > I suspect also that the services passwords (postgresql, rabbit, baruwa) > cannot be complex password (with special characters) but I will confirm > this within the next couple of minutes, will try this third time with > simple passwords (letters and numbers for example) and see if this will be > a success, I will leave the rest as it was in the last 2 failed installs. > > BTW: you wrote in your last post (below) that you've updated the file, > but on github I see the last update to the file was done 5 hours ago... > seems like you didn't push to master ;) > > BRB, > Anis > > On 18 January 2013 20:40, Jeremy McSpadden <[email protected]> wrote: > >> I have updated the script and promoted for entry before that portion is >> executed. >> >> >> -- >> Jeremy McSpadden >> Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions >> Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 >> >> On Jan 18, 2013, at 1:05 PM, Rowland Penny <[email protected]> >> wrote: >> >> On 18/01/13 14:43, Anis Jendoubi wrote: >> >> Norman, >> I did this in a lab on my PC and using vmware workstation, and yes! I >> pulled it from the url you mentioned, however I forgot to mention also that >> I had to disable my Symantec Edpoint AV on my PC (where the vmware >> workstation was installed) as it was blocking downloading something (I do >> not remember anymore) from arroung the middle of running script, maybe that >> helped also.. but I'm not sure, will be trying on a publicly hosted live >> environment and will let you know... but that's all I did. >> >> On 18 January 2013 14:48, Norman <[email protected]> wrote: >> >>> Hi Anis, >>> >>> Where did you pull the updated script for CentOS 6 from? I have just >>> tried curl -O >>> https://raw.github.com/fluxlabs/scripting/master/baruwa/cent6/install_baruwa2.shand >>> the file appears to be the same as the one I downloaded 2 days ago >>> (24505 bytes). The script I've downloaded doesn't ask for Baruwa username >>> and displays the same errors as yours when starting up MailScanner. >>> >>> I have the hostname line in /etc/hosts and both iptables and selinux >>> disabled. >>> >>> Thanks, >>> Norman >>> >>> >>> >>> On 17/01/2013 20:54, Anis Jendoubi wrote: >>> >>> OK... Got it to work, this is what I've done and FYI: >>> I have installed Centos 6.3 64bit, disabled iptables and selinux and put >>> the hostname with its IP hard coded in the file /etc/hosts as the * >>> example* below: >>> >>> ---------------------------- >>> 192.168.1.60 smtp.domain.local smtp >>> --------------------------- >>> >>> and then I ran your script file... and badaboom, I can login without >>> issue.... >>> Oh! BTW: I can confirm that the last pulled script few minutes ago does >>> ask for the baruwa admin username and password as well as to fill all the >>> other details (email, name and surname). >>> >>> Good Job Jeremy for this script... >>> Good Job Andrew for this lovely app! >>> >>> I will be testing this in the next couple of weeks (now busy with >>> other things) and will be posting some helpful feature requests (if there >>> will be any) as well as issues that I can find (hopefully I find nothing ;) >>> ) >>> >>> Time for me to go to bed... >>> Cheers, >>> Anis >>> >>> On 17 January 2013 21:25, Jeremy McSpadden <[email protected]> wrote: >>> >>>> Recommended to be in the file, good Linux practice. Doesn't have to >>>> be in before. >>>> >>>> Manually wait the mail scanner file in sysconfig. Check it for any >>>> character errors. >>>> >>>> -- >>>> Jeremy McSpadden >>>> Flux Labs | Endless Solutions >>>> Cell : 850-890-2543 | Fax : 850-254-2955 >>>> >>>> On Jan 17, 2013, at 2:16 PM, "Anis Jendoubi" <[email protected]> >>>> wrote: >>>> >>>> unfortunatly same error as my last post.... found out that even >>>> though the "hostname" and "hostname -f" were giving the same value, the >>>> /etc/hosts file didn't have a hard coded hostname with its IP, does that >>>> have to be input before running your script? I added the line to the host >>>> file but that didn't help either, MailScanner still giving the same >>>> errors... any idea? >>>> Thanks, >>>> Anis >>>> >>>> On 17 January 2013 21:03, Jeremy McSpadden <[email protected]> wrote: >>>> >>>>> sed -i 's:EXIM:#EXIM:' /etc/sysconfig/MailScanner >>>>> echo EXIM=/usr/sbin/exim >> /etc/sysconfig/MailScanner >>>>> echo EXIMINCF=/etc/exim/exim.conf >> /etc/sysconfig/MailScanner >>>>> echo EXIMSENDCF=/etc/exim/exim_out.conf >> /etc/sysconfig/MailScanner >>>>> >>>>> Chould have fixed the MTA issue. .. running it to many times may >>>>> void out the other . (I'm not that good with sed) >>>>> >>>>> grep MTA /etc/MailScanner/MailScanner.conf == MTA = exim >>>>> grep MTA /etc/sysconfig/MailScanner == MTA=`$CMD -e "print >>>>> MailScanner::Config::QuickPeek('$MSCONF','MTA')"` >>>>> >>>>> -- >>>>> Jeremy McSpadden >>>>> Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions >>>>> Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 >>>>> >>>>> On Jan 17, 2013, at 1:59 PM, Anis Jendoubi <[email protected]> >>>>> wrote: >>>>> >>>>> The portion of the script ran, to be sure I ran the lines again with >>>>> no errors, when trying to start MailScanner it dump the following errors >>>>> (check at the bottom where it says "invalid MTA", I checked also and made >>>>> sure that the command "hostname" and "hostname -f" gave me >>>>> smtp.domain.local >>>>> >>>>> -------------------------------------------------------- >>>>> [root@smtp ~]# service MailScanner start >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='mta', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='mta', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='incomingworkdir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='incomingworkdir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='incomingqueuedir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='incomingqueuedir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='quarantinedir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='quarantinedir', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='runasuser', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> DBD::Pg::st execute failed: ERROR: relation "quickpeek" does not exist >>>>> LINE 1: SELECT value FROM quickpeek WHERE external = $1 AND (hostnam... >>>>> ^ [for Statement "SELECT value FROM >>>>> quickpeek WHERE external = ? AND (hostname = ? OR hostname='default') >>>>> LIMIT >>>>> 1" with ParamValues: 1='runasuser', 2='smtp.domain.local'] at >>>>> /usr/lib/MailScanner/MailScanner/ConfigSQL.pm line 134. >>>>> /etc/init.d/MailScanner: line 84: [: =: unary operator expected >>>>> Starting MailScanner daemons: >>>>> incoming : /etc/init.d/MailScanner: line 103: [: =: unary >>>>> operator expected >>>>> /etc/init.d/MailScanner: line 115: [: =: unary operator expected >>>>> /etc/init.d/MailScanner: line 125: [: =: unary operator expected >>>>> /etc/init.d/MailScanner: line 145: [: =: unary operator expected >>>>> [FAILED] >>>>> Invalid MTA in /etc/sysconfig/MailScanner >>>>> outgoing : /etc/init.d/MailScanner: line 164: [: =: unary >>>>> operator expected >>>>> /etc/init.d/MailScanner: line 174: [: =: unary operator expected >>>>> /etc/init.d/MailScanner: line 184: [: =: unary operator expected >>>>> /etc/init.d/MailScanner: line 189: [: =: unary operator expected >>>>> [FAILED] >>>>> Invalid MTA in /etc/sysconfig/MailScanner >>>>> MailScanner: /etc/init.d/MailScanner: line 232: [: =: >>>>> unary operator expected >>>>> [ OK ] >>>>> -------------------------------------------------------- >>>>> >>>>> >>>>> >>>>> >>>>> On 17 January 2013 20:50, Jeremy McSpadden <[email protected]>wrote: >>>>> >>>>>> sed -i 's:Custom Functions Dir = >>>>>> /usr/share/MailScanner/MailScanner/CustomFunctions:Custom Functions Dir = >>>>>> /usr/lib/MailScanner/MailScanner/CustomFunctions:' >>>>>> /etc/MailScanner/MailScanner.conf >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>>> >>>>> >>>> _______________________________________________ >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> _______________________________________________ >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >> >> -- >> This message has been scanned for viruses and >> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and >> is >> believed to be clean. >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> Hi, >> I think I know why the admin account is not being setup, when this line >> is run: >> /home/baruwa/px/bin/paster setup-app /etc/baruwa/production.ini >> >> You get this: >> 2013-01-18 17:58:49,628 INFO [baruwa.websetup] [MainThread] Populating >> initial sql >> 2013-01-18 17:58:54,367 INFO [baruwa.websetup] [MainThread] Creating the >> default settings node >> 2013-01-18 17:58:54,455 INFO [baruwa.websetup] [MainThread] Default >> settings node created ! >> >> And then you get this: >> Do you want to configure an admin account? (Y/N): >> >> But if you blink, you will miss it, because it does not wait long for an >> answer, it quickly defaults to NO! >> >> Rowland >> >> >> -- >> This message has been scanned for viruses and >> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and >> is >> believed to be clean. >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056

