I will try to write an escape for the password entry ..
-- Jeremy McSpadden Flux Labs, Inc | http://www.fluxlabs.net | Endless Solutions Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax : 850-254-2955 From: [email protected] [mailto:[email protected]] On Behalf Of Anis Jendoubi Sent: Friday, January 18, 2013 3:00 PM To: Baruwa users list Subject: Re: [Baruwa] Baruwa2 - error 500 @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]<mailto:[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]<mailto:[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]<mailto:[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<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]<mailto:[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]<mailto:[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.sh and 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]<mailto:[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]<mailto:[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]<mailto:[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<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]<mailto:[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]<mailto:[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
