Piler not starting:

[Former user]

Hi JSuto ,

Could you please assist , I am running into the following after installing Piler on Ubuntu 12.10 , I am missing something somewhere but cant seem to solve the problem.

Regards

Feb 14 13:43:12 piler piler[832]: piler has been terminated Feb 14 13:56:11 piler piler[1365]: cannot connect to mysql server Feb 14 13:56:11 piler piler[1365]: piler 0.1.24-master-branch, build 836 starting Feb 14 14:05:01 piler logger: INDEXER INFO: indexing delta1 started Feb 14 14:05:01 piler logger: INDEXER INFO: indexing delta1 finished Feb 14 14:05:06 piler logger: INDEXER INFO: merging delta to dailydelta started Feb 14 14:05:06 piler logger: INDEXER INFO: merging delta to dailydelta finished Feb 14 14:05:06 piler sendmail[1692]: s1EA56KV001692: from=piler, size=479, class=0, nrcpts=1, msgid=[e-mail], relay=piler@localhost Feb 14 14:05:06 piler piler[1371]: connection from 127.0.0.1 Feb 14 14:05:06 piler piler[1371]: Cannot connect to mysql server Feb 14 14:05:06 piler piler[1371]: cannot make prepared statement Feb 14 14:05:06 piler sendmail[1692]: s1EA56KV001692: to=piler, ctladdr=piler (1000/1000), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30479, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: 421 %s service not available Feb 14 14:06:36 piler sm-msp-queue[633]: s1EA56KV001692: to=piler, ctladdr=piler (1000/1000), delay=00:01:30, xdelay=00:00:00, mailer=relay, pri=120479, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: Connection refused by [127.0.0.1] Feb 14 14:06:39 piler sm-mta[593]: gethostbyaddr(127.0.0.2) failed: 1 Feb 14 14:06:39 piler sm-mta[764]: starting daemon (8.14.4): SMTP+queueing@00:10:00 Feb 14 14:12:18 piler sm-mta[593]: gethostbyaddr(127.0.0.2) failed: 1 Feb 14 14:12:18 piler sm-mta[595]: starting daemon (8.14.4): SMTP+queueing@00:10:00 Feb 14 14:12:20 piler sm-mta[690]: s1EACKpY000690: from=[e-mail], size=749, class=0, nrcpts=1, msgid=[e-mail], proto=ESMTP, daemon=MTA-v4, relay=localhost.localdomain [127.0.0.1] Feb 14 14:12:20 piler sm-msp-queue[686]: s1EA56KV001692: to=piler, ctladdr=piler (1000/1000), delay=00:07:14, xdelay=00:00:00, mailer=relay, pri=210479, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (s1EACKpY000690 Message accepted for delivery) Feb 14 14:12:21 piler sm-mta[705]: s1EACKpY000690: to=[e-mail], ctladdr=[e-mail] (1000/1000), delay=00:00:01, xdelay=00:00:01, mailer=local, pri=30967, dsn=2.0.0, stat=Sent root@piler:~/piler-0.1.24# service sendmail stop * Stopping Mail Transport Agent (MTA) sendmail [ OK ] root@piler:~/piler-0.1.24# service mysql restart mysql stop/waiting mysql start/running, process 881 root@piler:~/piler-0.1.24# clear root@piler:~/piler-0.1.24# sh init.d/rc.piler start starting piler . . . cant connect to mysql server root@piler:~/piler-0.1.24# sh init.d/rc.searchd start starting searchd . . . Sphinx 2.1.5-id64-release (rel21-r4508) Copyright (c) 2001-2014, Andrew Aksyonoff Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'... listening on 127.0.0.1:9312 listening on 127.0.0.1:9306 precaching index 'main1' WARNING: index 'main1': preload: failed to open /var/piler/sphinx/main1.sph: No such file or directory; NOT SERVING precaching index 'main2' WARNING: index 'main2': preload: failed to open /var/piler/sphinx/main2.sph: No such file or directory; NOT SERVING precaching index 'main3' WARNING: index 'main3': preload: failed to open /var/piler/sphinx/main3.sph: No such file or directory; NOT SERVING precaching index 'main4' WARNING: index 'main4': preload: failed to open /var/piler/sphinx/main4.sph: No such file or directory; NOT SERVING precaching index 'dailydelta1' WARNING: index 'dailydelta1': preload: failed to open /var/piler/sphinx/dailydelta1.sph: No such file or directory; NOT SERVING precaching index 'delta1' precaching index 'tag1' rotating index 'tag1': success precaching index 'note1' rotating index 'note1': success precached 8 indexes in 0.002 sec

[Janos SUTO]

Hello, is a remote session (eg. teamviewer) possible? Btw. is this machine in production or you are evaluating it?

[Adrian Reyneke]

Hi there ,

Thank you for getting back to me on this , this is currently a evaluation machine for our office , we are intrested in using this in some of our client enviroments but i am having a hard time setting it up. I can arrange for teamviewer access if you specify a time date that is convenient for you.

Regards

[Janos SUTO]

Hello, in what timezone are you?

[Adrian Reyneke]

+2 - Pretoria , South Africa

[Janos SUTO]

OK, how about starting a teamviewer session now? Find me on skype (janos.suto), and we can discuss the details.

[Janos SUTO]

No news is good news.