Baruwa2 - error 500

classic Classic list List threaded Threaded
25 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Baruwa2 - error 500

anis
Hi,
I used Jeremy's script posted here ( http://baruwa-users-list.963389.n3.nabble.com/CentOS-6-x64-86-Installer-for-Baruwa-2-0-tp4025621p4025646.html ), everything goes well until I go to the url and put the admin username and password set during scripted install and hit the "login" button, after about 2 or 3 seconds loading it throws me an error 500 (see attachment).
I checked baruwa-error_log file and this is what I get (the log is filled with such errors), the smtp.domain.local is the baruwa machine, the 192.168.1.20 is the machine I connect to baruwa's frontpage.

------------------------------------------------------------------------------
[root@smtp httpd]# tail /var/log/httpd/baruwa-error_log
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]             <pre>Traceback (most recent call last):, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/errormiddleware.py", line 450, in send_report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     rep.report(exc_data), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/reporter.py", line 45, in report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     server = smtplib.SMTP(self.smtp_server), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/usr/lib64/python2.6/smtplib.py", line 241, in __init__, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     raise SMTPConnectError(code, msg), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] SMTPConnectError: (451, 'Temporary local problem - please try later'), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] </pre>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:02 2013] [error] [client 192.168.1.20]             </p>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
------------------------------------------------------------------------------


Any idea?
Thanks for the help.
Anis

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

baruwa2-error500.JPG (30K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
CeleryD setup to listen on smtp.domain.local ? Is that entry in your hosts file ? It is setup to listen and operate on itself correct ? 

192.168.1.20 = smtp.domain.local ?

--
Jeremy McSpadden
Flux Labs | Endless Solutions
Cell : 850-890-2543 | Fax : 850-254-2955

On Jan 17, 2013, at 1:27 PM, "Anis Jendoubi" <[hidden email]> wrote:

Hi,
I used Jeremy's script posted here ( http://baruwa-users-list.963389.n3.nabble.com/CentOS-6-x64-86-Installer-for-Baruwa-2-0-tp4025621p4025646.html ), everything goes well until I go to the url and put the admin username and password set during scripted install and hit the "login" button, after about 2 or 3 seconds loading it throws me an error 500 (see attachment).
I checked baruwa-error_log file and this is what I get (the log is filled with such errors), the smtp.domain.local is the baruwa machine, the 192.168.1.20 is the machine I connect to baruwa's frontpage.

------------------------------------------------------------------------------
[root@smtp httpd]# tail /var/log/httpd/baruwa-error_log
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]             <pre>Traceback (most recent call last):, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/errormiddleware.py", line 450, in send_report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     rep.report(exc_data), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/reporter.py", line 45, in report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     server = smtplib.SMTP(self.smtp_server), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/usr/lib64/python2.6/smtplib.py", line 241, in __init__, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     raise SMTPConnectError(code, msg), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] SMTPConnectError: (451, 'Temporary local problem - please try later'), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] </pre>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:02 2013] [error] [client 192.168.1.20]             </p>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
------------------------------------------------------------------------------


Any idea?
Thanks for the help.
Anis
<baruwa2-error500.JPG>
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
Jeremy thanks for the prompt reply,
Well 192.168.1.20 = ns.domain.local (an internal lab DNS server)
smtp.domain.local = 192.168.1.60
yes CeleryD (aka baruwa ;) ) process is there when I ps -aux it (below is the proof):

-------------------------------------
[root@smtp httpd]# ps -aux | grep celeryd
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
root      1312  0.0  0.0 131084  1420 ?        S    18:32   0:00 runuser -s /bin/bash baruwa -c ulimit -S -c 0 >/dev/null 2>&1 ; /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
baruwa    1313  0.0  0.0 106056  1332 ?        Ss   18:32   0:00 bash -c ulimit -S -c 0 >/dev/null 2>&1 ; /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
baruwa    1314  0.0  4.1 413276 79224 ?        S    18:32   0:05 /home/baruwa/px/bin/python /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
root      3006  0.0  0.0 103236   868 pts/1    S+   20:38   0:00 grep celeryd
-------------------------------------


However I found this error with MailScanner services not running:

--------------------------------------------------------------------------
[root@smtp httpd]# /etc/init.d/MailScanner status
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
Checking MailScanner daemons:
         MailScanner:                                      [FAILED]
/etc/init.d/MailScanner: line 335: [: =: unary operator expected
/etc/init.d/MailScanner: line 349: [: =: unary operator expected
-----------------------------------------------------------------------------------------------------------


On 17 January 2013 20:32, Jeremy McSpadden <[hidden email]> wrote:
CeleryD setup to listen on smtp.domain.local ? Is that entry in your hosts file ? It is setup to listen and operate on itself correct ? 

192.168.1.20 = smtp.domain.local ?

--
Jeremy McSpadden
Flux Labs | Endless Solutions
Cell : 850-890-2543 | Fax : 850-254-2955

On Jan 17, 2013, at 1:27 PM, "Anis Jendoubi" <[hidden email]> wrote:

Hi,
I used Jeremy's script posted here ( http://baruwa-users-list.963389.n3.nabble.com/CentOS-6-x64-86-Installer-for-Baruwa-2-0-tp4025621p4025646.html ), everything goes well until I go to the url and put the admin username and password set during scripted install and hit the "login" button, after about 2 or 3 seconds loading it throws me an error 500 (see attachment).
I checked baruwa-error_log file and this is what I get (the log is filled with such errors), the smtp.domain.local is the baruwa machine, the 192.168.1.20 is the machine I connect to baruwa's frontpage.

------------------------------------------------------------------------------
[root@smtp httpd]# tail /var/log/httpd/baruwa-error_log
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]             <pre>Traceback (most recent call last):, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/errormiddleware.py", line 450, in send_report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     rep.report(exc_data), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/reporter.py", line 45, in report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     server = smtplib.SMTP(self.smtp_server), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/usr/lib64/python2.6/smtplib.py", line 241, in __init__, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     raise SMTPConnectError(code, msg), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] SMTPConnectError: (451, 'Temporary local problem - please try later'), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] </pre>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:02 2013] [error] [client 192.168.1.20]             </p>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
------------------------------------------------------------------------------


Any idea?
Thanks for the help.
Anis
<baruwa2-error500.JPG>
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056



_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
Make sure  this portion of the script ran.

sed -i 's:MailScanner Version Number = 4.84.3:MailScanner Version Number = 4.84.5:' /etc/MailScanner/MailScanner.conf
sed -i 's:Virus Scanners = none:Virus Scanners = clamd:' /etc/MailScanner/MailScanner.conf
sed -i 's:EXIM:#EXIM:' /etc/sysconfig/MailScanner
sed -i 's:Custom Functions Dir = /usr/share/MailScanner/MailScanner/CustomFunctions:Custom Functions Dir = /usr/lib/MailScanner/MailScanner/CustomFunctions:' /etc/MailScanner/MailScanner.conf

The script will not work with 2 different systems. It was written for all on the same.

--
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:39 PM, Anis Jendoubi <[hidden email]>
 wrote:

Jeremy thanks for the prompt reply,
Well 192.168.1.20 = ns.domain.local (an internal lab DNS server)
smtp.domain.local = 192.168.1.60
yes CeleryD (aka baruwa ;) ) process is there when I ps -aux it (below is the proof):

-------------------------------------
[root@smtp httpd]# ps -aux | grep celeryd
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
root      1312  0.0  0.0 131084  1420 ?        S    18:32   0:00 runuser -s /bin/bash baruwa -c ulimit -S -c 0 >/dev/null 2>&1 ; /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
baruwa    1313  0.0  0.0 106056  1332 ?        Ss   18:32   0:00 bash -c ulimit -S -c 0 >/dev/null 2>&1 ; /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
baruwa    1314  0.0  4.1 413276 79224 ?        S    18:32   0:05 /home/baruwa/px/bin/python /home/baruwa/px/bin/paster celeryd /etc/baruwa/production.ini -f /var/log/baruwa/celeryd.log --pidfile=/var/run/baruwa/celeryd.pid -l INFO
root      3006  0.0  0.0 103236   868 pts/1    S+   20:38   0:00 grep celeryd
-------------------------------------


However I found this error with MailScanner services not running:

--------------------------------------------------------------------------
[root@smtp httpd]# /etc/init.d/MailScanner status
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
Checking MailScanner daemons:
         MailScanner:                                      [FAILED]
/etc/init.d/MailScanner: line 335: [: =: unary operator expected
/etc/init.d/MailScanner: line 349: [: =: unary operator expected
-----------------------------------------------------------------------------------------------------------


On 17 January 2013 20:32, Jeremy McSpadden <[hidden email]> wrote:
CeleryD setup to listen on smtp.domain.local ? Is that entry in your hosts file ? It is setup to listen and operate on itself correct ? 

192.168.1.20 = smtp.domain.local ?

--
Jeremy McSpadden
Flux Labs | Endless Solutions
Cell : 850-890-2543 | Fax : 850-254-2955

On Jan 17, 2013, at 1:27 PM, "Anis Jendoubi" <[hidden email]> wrote:

Hi,
I used Jeremy's script posted here ( http://baruwa-users-list.963389.n3.nabble.com/CentOS-6-x64-86-Installer-for-Baruwa-2-0-tp4025621p4025646.html ), everything goes well until I go to the url and put the admin username and password set during scripted install and hit the "login" button, after about 2 or 3 seconds loading it throws me an error 500 (see attachment).
I checked baruwa-error_log file and this is what I get (the log is filled with such errors), the smtp.domain.local is the baruwa machine, the 192.168.1.20 is the machine I connect to baruwa's frontpage.

------------------------------------------------------------------------------
[root@smtp httpd]# tail /var/log/httpd/baruwa-error_log
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]             <pre>Traceback (most recent call last):, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/errormiddleware.py", line 450, in send_report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     rep.report(exc_data), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/reporter.py", line 45, in report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     server = smtplib.SMTP(self.smtp_server), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/usr/lib64/python2.6/smtplib.py", line 241, in __init__, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     raise SMTPConnectError(code, msg), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] SMTPConnectError: (451, 'Temporary local problem - please try later'), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] </pre>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:02 2013] [error] [client 192.168.1.20]             </p>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
------------------------------------------------------------------------------


Any idea?
Thanks for the help.
Anis
<baruwa2-error500.JPG>
_______________________________________________
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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
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 <[hidden email]>
 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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

barufan
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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
/home/baruwa/px/bin/paster setup-app /etc/baruwa/production.ini
This is called on line 367.

--
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 7:48 AM, Norman <[hidden email]>
 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


_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

Manish Rane

I even tried again. But no luck for setting up username password.

On 18 Jan 2013 19:51, "Jeremy McSpadden" <[hidden email]> wrote:
/home/baruwa/px/bin/paster setup-app /etc/baruwa/production.ini
This is called on line 367.

--
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 7:48 AM, Norman <[hidden email]>
 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


_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056


_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
In reply to this post by barufan
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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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



_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

Rowland Penny
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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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, 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, and is
believed to be clean.
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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, 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, and is
believed to be clean.
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056


_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
@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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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, 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, 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs
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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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, 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, 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

anis
@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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
 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 <[hidden email]> 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, 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, 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

jeremymcs

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: [hidden email] [mailto:[hidden email]] 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 <[hidden email]> 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 <[hidden email]>

 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 <[hidden email]> 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 <[hidden email]>

 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 <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>

 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 <[hidden email]> 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, 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, 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
Reply | Threaded
Open this post in threaded view
|

Re: Baruwa2 - error 500

Manish Rane
In reply to this post by anis
Wheww...I am running out of ideas here. Have tried all the ways specified in previous posts and none of them worked with me :( . I get below error as soon as I login

ERROR: 500

The system was unable to complete your request, the support team has been notified


Below are the celeryd.log, any clue what's happening here 

2013-01-22 23:40:17,660 Baruwa[891]: consumer: Cannot connect to amqp://baruwa@127.0.0.1:5672/baruwa: [Errno 111] ECONNREFUSED.

Trying again in 2.00 seconds...


2013-01-23 19:56:51,886 Baruwa[999]: [hidden email] ready.

2013-01-23 19:56:51,927 Baruwa[999]: consumer: Connected to amqp://baruwa@127.0.0.1:5672/baruwa.

2013-01-23 19:56:52,039 Baruwa[999]: pidbox: Connected to amqp://baruwa@127.0.0.1:5672/baruwa.

2013-01-23 21:39:39,969 Baruwa[999]: consumer: Connection to broker lost. Trying to re-establish the connection...

Traceback (most recent call last):

  File "/home/baruwa/px/lib/python2.6/site-packages/celery/worker/consumer.py", line 393, in start

    self.consume_messages()

  File "/home/baruwa/px/lib/python2.6/site-packages/celery/worker/consumer.py", line 885, in consume_messages

    self.connection.drain_events(timeout=10.0)

  File "/home/baruwa/px/lib/python2.6/site-packages/kombu/connection.py", line 275, in drain_events

    return self.transport.drain_events(self.connection, **kwargs)

  File "/home/baruwa/px/lib/python2.6/site-packages/kombu/transport/pyamqp.py", line 89, in drain_events

    return connection.drain_events(**kwargs)

  File "/home/baruwa/px/lib/python2.6/site-packages/amqp/connection.py", line 287, in drain_events

    return amqp_method(channel, args)

  File "/home/baruwa/px/lib/python2.6/site-packages/amqp/connection.py", line 492, in _close

    raise ConnectionError(reply_code, reply_text, (class_id, method_id))

ConnectionError: 320: (CONNECTION_FORCED - broker forced connection closure with reason 'shutdown', (0, 0), None)

2013-01-23 21:39:40,044 Baruwa[999]: Traceback (most recent call last):

2013-01-23 21:39:40,044 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/eventlet/hubs/poll.py", line 97, in wait

2013-01-23 21:39:40,062 Baruwa[999]: readers.get(fileno, noop).cb(fileno)

2013-01-23 21:39:40,063 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/celery/worker/consumer.py", line 721, in _green_pidbox_node

2013-01-23 21:39:40,063 Baruwa[999]: pass

2013-01-23 21:39:40,075 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/kombu/messaging.py", line 379, in __exit__

2013-01-23 21:39:40,079 Baruwa[999]: self.cancel()

2013-01-23 21:39:40,079 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/kombu/messaging.py", line 409, in cancel

2013-01-23 21:39:40,079 Baruwa[999]: cancel(tag)

2013-01-23 21:39:40,080 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/amqp/channel.py", line 1610, in basic_cancel

2013-01-23 21:39:40,139 Baruwa[999]: self._send_method((60, 30), args)

2013-01-23 21:39:40,140 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/amqp/abstract_channel.py", line 58, in _send_method

2013-01-23 21:39:40,141 Baruwa[999]: self.channel_id, method_sig, args, content)

2013-01-23 21:39:40,141 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/amqp/method_framing.py", line 218, in write_method

2013-01-23 21:39:40,143 Baruwa[999]: write_frame(1, channel, payload)

2013-01-23 21:39:40,143 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/amqp/transport.py", line 149, in write_frame

2013-01-23 21:39:40,144 Baruwa[999]: frame_type, channel, size, payload, 0xce))

2013-01-23 21:39:40,144 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/eventlet/greenio.py", line 287, in sendall

2013-01-23 21:39:40,211 Baruwa[999]: tail = self.send(data, flags)

2013-01-23 21:39:40,214 Baruwa[999]: File "/home/baruwa/px/lib/python2.6/site-packages/eventlet/greenio.py", line 273, in send

2013-01-23 21:39:40,214 Baruwa[999]: total_sent += fd.send(data[total_sent:], flags)

2013-01-23 21:39:40,215 Baruwa[999]: error: [Errno 32] Broken pipe

2013-01-23 21:39:40,215 Baruwa[999]: Removing descriptor: 8

2013-01-23 21:39:40,232 Baruwa[999]: consumer: Cannot connect to amqp://baruwa@127.0.0.1:5672/baruwa: [Errno 111] ECONNREFUSED.

Trying again in 2.00 seconds...


2013-01-23 21:40:21,226 Baruwa[898]: [hidden email] ready.

2013-01-23 21:40:21,243 Baruwa[898]: consumer: Connected to amqp://baruwa@127.0.0.1:5672/baruwa.

2013-01-23 21:40:21,271 Baruwa[898]: pidbox: Connected to amqp://baruwa@127.0.0.1:5672/baruwa.



and  httpd/error.log

Wed Jan 23 21:40:21 2013] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Jan 23 21:40:21 2013] [warn] module proxy_ajp_module is already loaded, skipping
[Wed Jan 23 21:40:21 2013] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 23 21:40:21 2013] [notice] Digest: done
[Wed Jan 23 21:40:21 2013] [warn] mod_wsgi: Compiled for Python/Baruwa warning: numerical links are often malicious: 2.6.2.
[Wed Jan 23 21:40:21 2013] [warn] mod_wsgi: Runtime using Python/Baruwa warning: numerical links are often malicious: 2.6.6.
[Wed Jan 23 21:40:21 2013] [notice] Apache/2.2.23 (Unix) DAV/2 mod_wsgi/3.2 Python/2.6.6 configured -- resuming normal operations
[Wed Jan 23 21:41:47 2013] [error] Exception KeyError: KeyError(140277905868768,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Jan 23 21:41:49 2013] [error] Exception KeyError: KeyError(140277905868768,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Wed Jan 23 21:41:50 2013] [error] Exception KeyError: KeyError(140277905868768,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored



--------------------------------------------------------------------------
Thanks and Regards,
Manish R


On Fri, Jan 18, 2013 at 12:56 AM, Anis Jendoubi <[hidden email]> wrote:
Hi,
I used Jeremy's script posted here ( http://baruwa-users-list.963389.n3.nabble.com/CentOS-6-x64-86-Installer-for-Baruwa-2-0-tp4025621p4025646.html ), everything goes well until I go to the url and put the admin username and password set during scripted install and hit the "login" button, after about 2 or 3 seconds loading it throws me an error 500 (see attachment).
I checked baruwa-error_log file and this is what I get (the log is filled with such errors), the smtp.domain.local is the baruwa machine, the 192.168.1.20 is the machine I connect to baruwa's frontpage.

------------------------------------------------------------------------------
[root@smtp httpd]# tail /var/log/httpd/baruwa-error_log
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]             <pre>Traceback (most recent call last):, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/errormiddleware.py", line 450, in send_report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     rep.report(exc_data), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/home/baruwa/px/lib/python2.6/site-packages/weberror/reporter.py", line 45, in report, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     server = smtplib.SMTP(self.smtp_server), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]   File "/usr/lib64/python2.6/smtplib.py", line 241, in __init__, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20]     raise SMTPConnectError(code, msg), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] SMTPConnectError: (451, 'Temporary local problem - please try later'), referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:01 2013] [error] [client 192.168.1.20] </pre>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
[Thu Jan 17 20:11:02 2013] [error] [client 192.168.1.20]             </p>, referer: http://smtp.domain.local/accounts/login?came_from=http%3A%2F%2Fsmtp.domain.local%2F
------------------------------------------------------------------------------


Any idea?
Thanks for the help.
Anis

_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056



_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
12