Hi Janos, Thanks for all information, yes I fixed it all this morning and it seems to be running great!
I only have a Piler: ERROR in my GUI but mails are coming in just fine. Mail.log doesn't show any error when starting tho. My Smarthost sometimes errors but works also great... this might be in the Piler/Service check ? Is there a way to do failover in some way ? or have 2 boxes running which you can merge or so ? I'm trying to catch up with the docs, but I understood you had someone writing some more at the moment ? Thanks, Matt 2015-04-28 9:37 GMT+02:00 Janos SUTO <[email protected]>: > > I try to provide some answers, nice thread anyway :-) > > The piler mysql user needs some privileges, to create tables, > insert, select, update and delete from them. If you think that > grant all is too much, you are free to tighten its permissions. > > searchd is part of sphinxsearch. I urge you to use the deb package > from http://sphinxsearch.com (or compile it fro source). The > debian/ubuntu shipped version is way too old. > > I can't tell you why you ran into problems with the installer. You can > see what happened, only you have clues to fix it. As a last resort look > into the postinstall script, and try to reproduce it manually what it > does. Btw. I assume you ran 'make postinstall' after everything had > been compiled and installed. The postinstall is more like a post > configuration > tool. > > Be sure to check piler.conf, and set 'mysqlhost', and 'mysqlport', and > set 'mysqlsocket' to empty value. Thus piler attempts to connect to > a remote sql server. (I encourage you to review etc/example.conf in > teh source tree). > > Piler uses a single database (piler). sphinx is not really a database, > rather sphinx provides an sql-like interface, and piler uses it. But > it's not really a (usual) database. > > If you think the docs is incomplete, please suggest how to improve it. > > If you still have questions, just ask. > > Janos > > > On 2015-04-28 01:38, Matt . wrote: >> >> Thanks for this information, I found the needed modules indeed. I'm on >> Ubuntu at the moment. >> >> It's in my opinion very insecure to have the piler user a GRANT ALL, >> it's quite easy to make it "working" in that case but that user can do >> too much in that database which it doesn't need. >> >> Yuu migt want to look into the docs again, where is a make postinstall >> which sets most settings for you an places the files in the right >> places. >> >> I also have to investigate why I don't have a searchd on Ubuntu, I >> might miss a package there. >> >> Thanks >> >> Matt >> >> >> >> 2015-04-28 1:24 GMT+02:00 admin-at-extremeshok-dot-com >> <[email protected]>: >>> >>> No idea what you mean by installer.. and no idea what platform. So >>> assuming >>> centos6 >>> >>> Does the installer = make install ? >>> >>> Which database does Sphinx use, the Piler one ? Yes >>> >>> does the root user create the DB normally during the postinstall ? NO, do >>> this manually and import SQL >>> >>> There is also not known what kind of rights the piler user needs, only >>> Select,Insert, Delete and Update ? mailpiler_database_name.*:ALL" >>> >>> On centos 6, you will need to first preform installs from source of the >>> following: >>> libzip, tre, tnef, catdoc, XLHTML, sphinx >>> >>> Create a piler user and group with the home set to /var/piler >>> >>> download the source, extract and run >>> >>> ./configure --localstatedir=/var --enable-starttls --enable-tcpwrappers >>> --with-database=mysql >>> make clean all >>> make install >>> >>> U will still need to setup the mysql database, user and import the sql. >>> sphinx will need a valid config and initialization. >>> >>> >>> On 28-Apr-15 1:12 AM, Matt . wrote: >>>> >>>> >>>> Same setups here, so I don't know why you suggested to hire someone. >>>> >>>> It might be nice if you can answer my questions. The files is what I >>>> already found out, but what does the installer do ? When importing the >>>> SQL scheme my installer fails that it sees a meta table, even when I >>>> don't import it fails that there are no tables. >>>> >>>> Which database does Sphinx use, the Piler one ? >>>> >>>> Ans why does the installer fail ? does the root user create the DB >>>> normally during the postinstall ? There is also not known what kind of >>>> rights the piler user needs, only Select,Insert, Delete and Update ? >>>> >>>> >>>> Matt >>>> >>>> 2015-04-28 1:07 GMT+02:00 admin-at-extremeshok-dot-com >>>> <[email protected]>: >>>>> >>>>> >>>>> I have over 1000 servers, including galera clusters ;-) >>>>> >>>>> sphinx config: /etc/sphinx/sphinx.conf >>>>> www config : /var/www/config-site.php >>>>> piler config: /usr/local/etc/piler.conf >>>>> >>>>> sql: /usr/local/share/piler/db-mysql.sql >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On 28-Apr-15 12:58 AM, Matt . wrote: >>>>>> >>>>>> >>>>>> Hi, >>>>>> >>>>>> I have ~45DB servers in multiple clusters running with several of >>>>>> software connection in HA setups., so installation will not be the >>>>>> problem if known is which DB's are created by the postinstall and >>>>>> which settings are made. >>>>>> >>>>>> I see in the piler.conf a mysql password but no host or port (port >>>>>> might not be needed). >>>>>> >>>>>> The documentation is a little bit small on this part, so that is why I >>>>>> ask. >>>>>> >>>>>> The same for Sphinx, nothing in the docs is mentioned about it. >>>>>> >>>>>> Thanks for the information. >>>>>> >>>>>> Matt >>>>>> >>>>>> >>>>>> >>>>>> 2015-04-28 0:51 GMT+02:00 admin-at-extremeshok-dot-com >>>>>> <[email protected]>: >>>>>>> >>>>>>> >>>>>>> You will need to follow the installation guide or hire someone to >>>>>>> install >>>>>>> and configure. >>>>>>> >>>>>>> If you are using an remote mysql server you will need to correctly >>>>>>> configure >>>>>>> all components to connect to remote mysql. >>>>>>> >>>>>>> It might be easier for you to first use piler with a localhost mysql >>>>>>> server. >>>>>>> >>>>>>> Once its working then try with a remote mysql server. >>>>>>> >>>>>>> >>>>>>> On 27-Apr-15 11:24 PM, Matt . wrote: >>>>>>>> >>>>>>>> >>>>>>>> Hi Guys, >>>>>>>> >>>>>>>> I ahve installed Piler and did a postinstall but something didn't >>>>>>>> went >>>>>>>> well. >>>>>>>> >>>>>>>> The installer accepted my user and root password for the postinstall >>>>>>>> but my DB which I created on the mysql server stays empty. >>>>>>>> >>>>>>>> I also cannot start piler as it cannot connect to the database >>>>>>>> server, >>>>>>>> same for the webinterface where sphinx looks for localhost >>>>>>>> (127.0.0.1) >>>>>>>> >>>>>>>> What am I missing here, does the piler install creates the DB and >>>>>>>> the >>>>>>>> user for you on the databaseserver ? And what do I need to change >>>>>>>> more >>>>>>>> in my config ? >>>>>>>> >>>>>>>> Thanks! >>>>>>>> >>>>>>>> Matt >>>>>>>> >>> > >
