piler not running

[Dascencio]

Hi gays... when i start piler with "sh init.d/rc.piler start" show "starting piler..." but not start piler.

piler -v ./configure --localstatedir=/var --with-database=mysql --enable-starttls --enable-tcpwrappers

help me. regards.

[Janos SUTO]

Hello, show me the following:

ps uaxw|grep piler
netstat -antl
tail -20 /var/log/mail*og

[Dascencio]

hi...

ps uaxw|grep piler root 1182 0.0 0.0 9612 864 pts/1 S+ 17:14 0:00 grep piler

netstat -antl

Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:111 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:10000 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:4949 0.0.0.0: LISTEN
tcp 0 0 192.168.0.6:53 0.0.0.0: LISTEN
tcp 0 0 127.0.0.1:53 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:25 0.0.0.0: LISTEN
tcp 0 0 127.0.0.1:953 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:9306 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:50686 0.0.0.0: LISTEN
tcp 0 0 0.0.0.0:9312 0.0.0.0: LISTEN
tcp 0 0 127.0.0.1:3306 0.0.0.0: LISTEN
tcp 0 0 192.168.0.6:22 192.168.0.55:57243 ESTABLISHED tcp 0 0 192.168.0.6:22 192.168.0.55:60117 ESTABLISHED tcp 0 0 127.0.0.1:52147 127.0.0.1:80 TIME_WAIT
tcp 0 0 127.0.0.1:44631 127.0.0.1:4949 TIME_WAIT
tcp6 0 0 :::80 ::: LISTEN
tcp6 0 0 :::21 ::: LISTEN
tcp6 0 0 :::53 ::: LISTEN
tcp6 0 0 :::22 ::: LISTEN
tcp6 0 0 :::25 ::: LISTEN
tcp6 0 0 ::1:953 ::: LISTEN
tcp6 0 0 192.168.0.6:21 192.168.0.57:60888 ESTABLISHED tcp6 0 0 192.168.0.6:80 192.168.0.57:62202 TIME_WAIT

tail -20 /var/log/mail*og

Dec 26 17:15:01 desarrollo postfix/qmgr[29249]: 4505F41277: from=piler@localhost, size=591, nrcpt=1 (queue active) Dec 26 17:15:01 desarrollo postfix/pickup[27443]: 5989B4127F: uid=1007 from=<piler> Dec 26 17:15:01 desarrollo postfix/cleanup[1207]: 5989B4127F: message-id=[e-mail] Dec 26 17:15:01 desarrollo postfix/local[1211]: 2949841282: to=piler@localhost, orig_to=<piler>, relay=local, delay=0.3, delays=0.17/0/0/0.12, dsn=2.0.0, status=sent (delivered to command: procmail -a "$EXTENSION") Dec 26 17:15:01 desarrollo postfix/qmgr[29249]: 2949841282: removed Dec 26 17:15:01 desarrollo postfix/qmgr[29249]: 5989B4127F: from=piler@localhost, size=652, nrcpt=1 (queue active) Dec 26 17:15:01 desarrollo postfix/local[1211]: 5989B4127F: to=piler@localhost, orig_to=<piler>, relay=local, delay=0.36, delays=0.32/0/0/0.03, dsn=2.0.0, status=sent (delivered to command: procmail -a "$EXTENSION") Dec 26 17:15:01 desarrollo postfix/qmgr[29249]: 5989B4127F: removed Dec 26 17:15:09 desarrollo postfix/local[1277]: 4505F41277: to=piler@localhost, orig_to=<piler>, relay=local, delay=8.3, delays=0.25/0/0/8, dsn=2.0.0, status=sent (delivered to command: procmail -a "$EXTENSION") Dec 26 17:15:09 desarrollo postfix/qmgr[29249]: 4505F41277: removed

[Janos SUTO]

You have postfix running, and it occupies port 25. Please stop postfix, then try starting piler. If you absolutely need postfix for some reason, then make it listen on 127.0.0.1, and edit piler.conf, and set listen_addr=1.2.3.4 (ie. set the IP-address of your piler host).

[Dascencio]

thank you very much, piler is running, but I have some doubts. I must change the port piler or postfix to have these running as I check messages stored in account piler?

to review the logs / var / log / mail.log shows this:

Dec 26 15:38:26 desarrollo piler[22705]: : mysql_stmt_prepare() error: Table 'piler.archiving_rule' doesn't exist => sql: SELECT domain, from, to, subject, _size, size, attachment_type, _attachment_size, attachment_size, spam, days FROM archiving_rule Dec 26 15:38:26 desarrollo piler[22705]: : mysql_stmt_prepare() error: Table 'piler.retention_rule' doesn't exist => sql: SELECT domain, from, to, subject, _size, size, attachment_type, _attachment_size, attachment_size, spam, days FROM retention_rule Dec 26 15:38:26 desarrollo piler[22705]: : mysql_stmt_prepare() error: Table 'piler.domain' doesn't exist => sql: SELECT domain FROM domain Dec 26 15:38:26 desarrollo piler[22705]: reloaded config: /usr/local/etc/piler.conf Dec 26 15:38:26 desarrollo piler[22705]: ERR: cannot bind to port Dec 26 15:38:26 desarrollo piler[22705]: piler has been terminated Dec 26 15:38:43 desarrollo piler[22719]: : mysql_stmt_prepare() error: Table 'piler.archiving_rule' doesn't exist => sql: SELECT domain, from, to, subject, _size, size, attachment_type, _attachment_size, attachment_size, spam, days FROM archiving_rule Dec 26 15:38:43 desarrollo piler[22719]: : mysql_stmt_prepare() error: Table 'piler.retention_rule' doesn't exist => sql: SELECT domain, from, to, subject, _size, size, attachment_type, _attachment_size, attachment_size, spam, days FROM retention_rule Dec 26 15:38:43 desarrollo piler[22719]: : mysql_stmt_prepare() error: Table 'piler.domain' doesn't exist => sql: SELECT domain FROM domain Dec 26 15:38:43 desarrollo piler[22719]: reloaded config: /usr/local/etc/piler.conf Dec 26 15:38:43 desarrollo piler[22719]: ERR: cannot bind to port Dec 26 15:38:43 desarrollo piler[22719]: piler has been terminated

[Janos SUTO]

You have some installation issues. For piler to work you need a database, and some tables, however you don't have them. have you run "make postinstall" after "make install"? If you have teamviewer access perhaps we can resolve this issue faster.

[Dascencio]

Hi jsuto... I have solved the problem of the tables. Now I have another problem, I can not access via web. By clicking the submit button displays error 404 Not Found ... In settings such documentroot apache not login.php ... I do some symbolic link? thanks again ...

[Dascencio]

this is the error ---> The requested URL /login.php was not found on this server. use apache.... regards.

[Janos SUTO]

Make sure you have a .htaccess file in Documentroot, and also make sure that apache uses the rewrite rules in .htaccess.

[Dascencio]

OK. But this. Htaccess should contain some kind of configuration ... A redirection or something ....

[Janos SUTO]

It should have 15-20 RewriteRule entries.

[Janos SUTO]

Any update on the issue?

[Dascencio]

Hello jsuto. Do not know how that configuration of htaccess. Could you better explain that? please.

[Janos SUTO]

Hello, ascencio. Is a teamviewer session possible to the archive host?

[Dascencio]

Hi Jsuto, yes is possible.

[Janos SUTO]

OK, I'll be online from ~9:00 AM CET +0100 on skype (janos.suto), then let's try to fix the issue.

[Janos SUTO]

I assume your issue is fixed by now. Otherwise please write to me.