Hi Jitu, This means that you have not properly configured postgresql, and that your pg_hba.conf does not include any tuple which describes the host "serverHost", the user "postgres", and the database instance "template1". (IIRC, template1 is the default database instance that PostgreSQL sets up on debian Linux).
This forum is not the right place to be asking basic installation/configuration questions about PostgreSQL. I suggest googling the specific error message and reading what people had to say about the solution. Thanks, Karl On Tue, Sep 16, 2014 at 3:16 AM, Jitu <[email protected]> wrote: > Hi Karl, > Today when deploying the war on server. i got below error. what is > the use of template1 db? > > Error getting connection: FATAL: no pg_hba.conf entry for host > "serverHost", user "postgres", database "template1", SSL off > > Thanks, > Jitu > > On Tue, Sep 16, 2014 at 1:51 AM, Karl Wright <[email protected]> wrote: > >> Hi Jitu, >> >> You can read about the parameters here: >> >> >> http://manifoldcf.apache.org/release/trunk/en_US/how-to-build-and-deploy.html#file+properties >> >> Some hints: >> >> (1) org.apache.manifoldcf.database.username is the name of a user that >> will be CREATED to own the MCF database instance. >> (2) org.apache.manifoldcf.database.password is the password that user >> will be given. >> (3) org.apache.manifoldcf.dbsuperusername is the name of the database >> superuser, which is the user that will be used to create the ManifoldCF >> database instance. >> (4) org.apache.manifoldcf.dbsuperuserpassword is the corresponding >> superuser password. >> >> The only some operations require that the superuser name and password be >> correct. Specifically, when database initialization/upgrade is taking >> place. This occurs in the single-process example when ManifoldCF is >> started. In the multiprocess example, this occurs when initialize.bat/.sh >> is run. >> >> Thanks, >> Karl >> >> >> >> On Mon, Sep 15, 2014 at 3:58 PM, Jitu <[email protected]> wrote: >> >>> Hi, >>> >>> i am currently using manifoldcf for crawling from sharepoint server >>> using postgres db. But in my properties.xml file is it mandatory to mention >>> both username and dbsuperusername. if i just use dbsuperusername then >>> agents are not able to access db. if i just mention username then i get >>> another error? Please correct me if i am wrong. >>> >>> >>> <property name="org.apache.manifoldcf.database.username" >>> value="postgresUser"/> >>> <property name="org.apache.manifoldcf.database.password" >>> value="postgresPassword"/> >>> <property name="org.apache.manifoldcf.dbsuperusername" >>> value="postgresUser"/> >>> <property name="org.apache.manifoldcf.dbsuperuserpassword" >>> value="postgresPassword"/> >>> >>> My Question is can we mention username and password only once. if so >>> which properties. >>> >>> Thanks, >>> Jitu >>> >> >> >
