manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: How to initialize an external PostgreSQL DB
Date Thu, 04 Jan 2018 16:29:30 GMT
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 <i93othman@gmail.com> 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 <daddywri@gmail.com> 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 <i93othman@gmail.com>
>> 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 <daddywri@gmail.com> 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 <i93othman@gmail.com>
>>>> 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 <daddywri@gmail.com> 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 <i93othman@gmail.com>
>>>>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>

Mime
View raw message