I specified the user name parementer in my global properties. The problem is : I don’t have the rights to create a new database on that server. So my only workaround is to create tables manually or with a script if it exists. I doubt there is a possibility to create tables, am I right?
Thank you, Othman BELHAJ On Thu 4 Jan 2018 at 17:10, Karl Wright <[email protected]> wrote: > Did you specify a postgresql user name parameter in your global properties? > > 'When you execute the initialize script, does it create a new database > with a new user?' Yes it does but you will need to supply the database > superuser and super user password in the global properties in order for > this to work. > > The order is as follows: > (1) start zookeeper > (2) change your global properties and upload them to zookeeper using > setglobalproperties > (3) run the initialize script > (4) start all ManifoldCF services > > If you get an error at the initialize step, it's because you haven't > configured your database connection/authorization parameters correctly. > > Thanks, > > Karl > > > On Thu, Jan 4, 2018 at 11:03 AM, Beelz Ryuzaki <[email protected]> > wrote: > >> Hi Karl, >> >> I used the setglobalproperties script to deploy them however I get the >> following error : FATAL: no PostgreSQL user name specified in startup >> packet. >> >> I have checked that my user exists. When you execute the initialize >> script, does it create a new database with a new user? If so, is there a >> workaround to create tables with an existing user and database ? >> >> Thank you in advance, >> >> Othman BELHAJ >> >> On Thu 4 Jan 2018 at 16:50, Karl Wright <[email protected]> wrote: >> >>> Hi Othman, >>> >>> Once you added the global properties, you need to deploy them into >>> zookeeper using the setglobalproperties script. >>> >>> Thanks, >>> Karl >>> >>> >>> On Thu, Jan 4, 2018 at 10:48 AM, Beelz Ryuzaki <[email protected]> >>> wrote: >>> >>>> Hi Karl, >>>> >>>> I read the “how to build and deploy” page thoroughly, but my problem is >>>> whenever I execute the initialize.sh file. It shows me a connection error : >>>> connection to localhost:5432 refused. Although I added the following lines >>>> in the properties-global.xml file located in the multiprocess-zk-example >>>> directory: >>>> >>>> <property name=“org.apache.manifoldcf.postgresql.hostname” >>>> value=“xxxxx”> >>>> >>>> <property name=“org.apache.manifoldcf.postgresql.port” value=“5433”> >>>> >>>> I’m not actually using the default port of PostgreSQL. >>>> >>>> Did I make a mistake ? Or was my configuration wrong ? >>>> >>>> Othman BELHAJ >>>> >>>> On Thu 4 Jan 2018 at 16:20, Karl Wright <[email protected]> wrote: >>>> >>>>> Hi Othman, >>>>> >>>>> Have you read the "how to build and deploy" page? Here's a reference: >>>>> >>>>> >>>>> https://manifoldcf.apache.org/release/release-2.9/en_US/how-to-build-and-deploy.html >>>>> >>>>> Karl >>>>> >>>>> >>>>> >>>>> On Thu, Jan 4, 2018 at 9:55 AM, Beelz Ryuzaki <[email protected]> >>>>> wrote: >>>>> >>>>>> Hello, >>>>>> >>>>>> I have in my possession two VMs. The first one where I installed the >>>>>> PostgreSQL. And the second one where I want to execute Apache manifoldCF. >>>>>> However, I don’t know what files should I modify in order to connect to >>>>>> this external DB. >>>>>> >>>>>> FYI, I’m using multiprocess-zk file process and I haven’t installed >>>>>> zookeeper yet. Both VMs are Linux based. >>>>>> >>>>>> My questions are : what files should I configure in order to >>>>>> initialize my PostgreSQL database ? Do I need to install zookeeper? >>>>>> >>>>>> Thank you in advance for your response, >>>>>> >>>>>> >>>>>> Othman BELHAJ >>>>>> >>>>> >>>>> >>> >
