You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@manifoldcf.apache.org by Beelz Ryuzaki <i9...@gmail.com> on 2018/01/04 14:55:25 UTC
How to initialize an external PostgreSQL DB
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
Re: How to initialize an external PostgreSQL DB
Posted by Karl Wright <da...@gmail.com>.
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 <i9...@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 <da...@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 <i9...@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 <da...@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 <i9...@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 <da...@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 <i9...@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
>>>>>>>
>>>>>>
>>>>>>
>>>>
>>
Re: How to initialize an external PostgreSQL DB
Posted by Beelz Ryuzaki <i9...@gmail.com>.
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 <da...@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 <i9...@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 <da...@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 <i9...@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 <da...@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 <i9...@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
>>>>>>
>>>>>
>>>>>
>>>
>
Re: How to initialize an external PostgreSQL DB
Posted by Karl Wright <da...@gmail.com>.
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 <i9...@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 <da...@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 <i9...@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 <da...@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 <i9...@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
>>>>>
>>>>
>>>>
>>
Re: How to initialize an external PostgreSQL DB
Posted by Beelz Ryuzaki <i9...@gmail.com>.
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 <da...@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 <i9...@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 <da...@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 <i9...@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
>>>>
>>>
>>>
>
Re: How to initialize an external PostgreSQL DB
Posted by Karl Wright <da...@gmail.com>.
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 <i9...@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 <da...@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 <i9...@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
>>>
>>
>>
Re: How to initialize an external PostgreSQL DB
Posted by Beelz Ryuzaki <i9...@gmail.com>.
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 <da...@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 <i9...@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
>>
>
>
Re: How to initialize an external PostgreSQL DB
Posted by Karl Wright <da...@gmail.com>.
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 <i9...@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
>