Well, you are correct in that there is no magic table-creating script. Karl
On Thu, Jan 4, 2018 at 11:14 AM, Beelz Ryuzaki <[email protected]> wrote: > 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 >>>>>>> >>>>>> >>>>>> >>>> >>
