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 >>>> >
