Help requested for Piler issue.

[kevinsanghvi]

Hello Janos,

Hope you are doing well.

I have installed Piler 1.3.0 on Ubuntu 17.04, initially with previous release however when new version release 25th June, we remove the piler files manually with regards to previous release (sudo rm -rf).

Could you please let me know whether mysql 5.7 is supported on latest release, otherwise would request a .deb file of earlier version.

Managed to start sphinxsearch service on Port 9313 by modifying sphinx.conf.

Problems:

1) I found piler.conf is blank, so did a copy of piler.conf.dist and renamed to piler.conf. piler -d : outputs shows it can't parse the file.

2) Piler service is not getting started. In logs it is saying "cannot bind to port". I reviewed earlier references and found Postfix service is not loaded, for troublehshooting. Already configured "A" record entries on DNS.

3) Piler can't connect to mysql server, however piler.conf is modified to make entries of mysql.

Please find attached screenshot. Request your help on the same.

Thanks, Kevin

[kevinsanghvi]

Hello Janos,

Could you please guide me.

Thanks, Kevin

[Janos SUTO]

Hello Kevin, I'm fine, thank you, however I'm confused. Is this a fresh install or an upgrade? If it's an upgrade why did you removed the config file?

Something has occupied port 25, probably it's the reason piler can't start. Check listen_addr and listen_port options in piler.conf. Btw. You are supposed to create it using piler.conf.dist. Also run pilerconf to see what configuration piler knows, as well as check permissions and ownership on piler.conf.

[kevinsanghvi]

Hello Janos,

Thanks for your response.

I had installed old version of piler on 25th June and after couple of days, I noticed - new version of piler 1.3.0 is available on website, so I simply removed the associated configuration files (sudo rm -rf) of older version and installed a new one, since it is yet to move in Production. I am not sure if that is right way to do so, since i didn't found package information for piler. Would request you to provide the command to remove piler.

Yes, I had created piler.conf from piler.conf.dist for Piler 1.3.0.

There seems to lot of success now, after following changes:

1) listen_addr is set to 127.0.0.1 and listen_port to 25 from 10.0.1.4 and 80 in piler.conf 2) Mistakenly created piler.key file /usr/local/etc/. Renamed the old one in /usr/local/etc/piler and moved the one which is created through 1.3.0. 3) Provided 777 permissions on piler.conf and piler.key.

Outcome:

Piler, Sphinx search and MySQL service is running.

Current status:

1) Intermittently "Err: cannot bind to port" error is coming in Piler logs (/var/log/mail.log) 2) Unable to open the Website, apache2 is running on port 80. Updated changes in "config.php" file. I understand it's already mentioned in config-site.php, however tried testing the same.

$config['LOCALHOST'] = '127.0.0.1'; $config['PILER_HOST'] = '127.0.0.1'; $config['PILER_PORT'] = 80; $config['SMARTHOST'] = 'aspmx.l.google.com'; $config['SMARTHOST_PORT'] = 25;

Please help.

Thanks, Kevin

[Janos SUTO]

Please find me on skype (janos.suto).

[kevinsanghvi]

Hello Janos,

Thanks for a lot for all your support!

Thanks, Kevin

[Janos SUTO]

Just as usual, there was no bug at all.