[Bucardo-general] Bucardo Error

Thomas, Austin Austin.Thomas at brxtn.com
Thu Aug 26 21:58:42 UTC 2021


None as far as I can tell



Best regards,



Austin Thomas
Senior Software Developer
Mission Solutions – EGS SatOps Prototype and Integration (SPI)

6 N Tejon Street Suite 400
Colorado Springs, CO 80903
Office: 719.380.8488
Direct: 719.733.8100
Cell: 941.518.8488
Austin.Thomas at brxtn.com
[cid:image005.png at 01D79A93.5211FEA0]

From: Computerisms Corporation <bob at computerisms.ca>
Sent: Thursday, August 26, 2021 3:00 PM
To: Thomas, Austin <Austin.Thomas at brxtn.com>; Enrique P. <eps.lab at protonmail.com>
Cc: Michelle Sullivan <michelle at sorbs.net>; bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] Bucardo Error


And what about the postgres logs, any clues in there?
On 2021-08-26 12:06 p.m., Thomas, Austin wrote:
I have the same settings as you do with the exception of host. I didn’t use the –dbhost flag since specifying it will force PostgreSQL to use a network connection (even if ‘localhost’ is provided)
[cid:image002.png at 01D79A93.51FAA610]



Best regards,




Austin Thomas
Senior Software Developer
Mission Solutions – EGS SatOps Prototype and Integration (SPI)

6 N Tejon Street Suite 400
Colorado Springs, CO 80903
Office: 719.380.8488
Direct: 719.733.8100
Cell: 941.518.8488
Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com>
[cid:image003.png at 01D79A93.51FAA610]

From: Computerisms Corporation <bob at computerisms.ca><mailto:bob at computerisms.ca>
Sent: Thursday, August 26, 2021 12:34 PM
To: Thomas, Austin <Austin.Thomas at brxtn.com><mailto:Austin.Thomas at brxtn.com>; Enrique P. <eps.lab at protonmail.com><mailto:eps.lab at protonmail.com>
Cc: Michelle Sullivan <michelle at sorbs.net><mailto:michelle at sorbs.net>; bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org>
Subject: Re: [Bucardo-general] Bucardo Error


Hi Austin,

This is what my notes say I did to get it installed on my system.  I remember having a bit of grief figuring out what commands to run as postgres, and what ones to run as bucardo, and I also remember that peer authentication in the pg_hba.conf didn't work, there is a previous post on this list from me that got an answer on the best way to set up the postgres permissions, might be worth chasing that down.  There might also be more info in the postgres logs.

su - postgres
bucardo install
*set:
1. Host:           /var/run/postgresql
2. Port:           5432 <= note: check conf file
3. User:           postgres
4. Database:       postgres
5. PID directory:  /var/run/bucardo
On 2021-08-26 11:25 a.m., Thomas, Austin wrote:

Retried using `sudo su - postgres`, dropping the database via `psql -U postgres` and `DROP DATABASE bucardo;` `exit`, reinstalling Bucardo via `bucardo install --dbport=5432 --dbname=postgres --dbuser=postgres --batch`, and then try to setup the database via `bucardo add db db_postgresql-athomas-node1_lokidb` and I get the same error as before.

[cid:image004.png at 01D79A93.51FAA610]





Best regards,







Austin Thomas

Senior Software Developer

Mission Solutions – EGS SatOps Prototype and Integration (SPI)



6 N Tejon Street Suite 400

Colorado Springs, CO 80903

Office: 719.380.8488

Direct: 719.733.8100

Cell: 941.518.8488

Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com>





-----Original Message-----
From: Computerisms Corporation <bob at computerisms.ca><mailto:bob at computerisms.ca>
Sent: Wednesday, August 25, 2021 3:25 PM
To: Thomas, Austin <Austin.Thomas at brxtn.com><mailto:Austin.Thomas at brxtn.com>; Enrique P. <eps.lab at protonmail.com><mailto:eps.lab at protonmail.com>
Cc: Michelle Sullivan <michelle at sorbs.net><mailto:michelle at sorbs.net>; bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org>
Subject: Re: [Bucardo-general] Bucardo Error



If you installed with sudo, then you installed as root.  Bucardo, nor postgres, will be able to do anything to root-owned stuff.  Try installing as the postgres user?



On 2021-08-25 11:20 a.m., Thomas, Austin wrote:

> Any update on this? I’m still stuck :/

>

> *Best regards,*

>

>

>

> Austin Thomas

>

> *Senior Software Developer*

>

> *Mission Solutions – EGS SatOps Prototype and Integration (SPI) *

>

> *6 N Tejon Street Suite 400*

>

> *Colorado Springs, CO 80903*

>

> *Office: 719.380.8488*

>

> *Direct: 719.733.8100*

>

> *Cell: 941.518.8488*

>

> *Austin.Thomas at brxtn.com*<mailto:*Austin.Thomas at brxtn.com*>

>

> *From:* Thomas, Austin

> *Sent:* Wednesday, August 18, 2021 1:11 PM

> *To:* Enrique P. <eps.lab at protonmail.com<mailto:eps.lab at protonmail.com>>

> *Cc:* Michelle Sullivan <michelle at sorbs.net<mailto:michelle at sorbs.net>>; Computerisms Corporation

> <bob at computerisms.ca<mailto:bob at computerisms.ca>>; bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org>

> *Subject:* RE: [Bucardo-general] Bucardo Error

>

> I’m able to use `psql -U postgres`  and a `\c bucardo` to enter the

> bucardo database. I’m able to run `\dt bucardo_config` and it appears

> under the bucardo schema.

>

> Also maybe worth noting, I installed bucardo via `sudo bucardo install

> –dbport=5432 –dbname=postgres –dbuser=postgres –batch`

>

> *Best regards,*

>

>

> Austin Thomas

>

> *Senior Software Developer*

>

> *Mission Solutions – EGS SatOps Prototype and Integration (SPI) *

>

> *6 N Tejon Street Suite 400*

>

> *Colorado Springs, CO 80903*

>

> *Office: 719.380.8488*

>

> *Direct: 719.733.8100*

>

> *Cell: 941.518.8488*

>

> *Austin.Thomas at brxtn.com<mailto:*Austin.Thomas at brxtn.com> <mailto:Austin.Thomas at brxtn.com>*

>

> *From:* Enrique P. <eps.lab at protonmail.com<mailto:eps.lab at protonmail.com>

> <mailto:eps.lab at protonmail.com>>

> *Sent:* Wednesday, August 18, 2021 12:33 PM

> *To:* Thomas, Austin <Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com>

> <mailto:Austin.Thomas at brxtn.com>>

> *Cc:* Michelle Sullivan <michelle at sorbs.net<mailto:michelle at sorbs.net>

> <mailto:michelle at sorbs.net>>; Computerisms Corporation

> <bob at computerisms.ca <mailto:bob at computerisms.ca<mailto:bob at computerisms.ca%20%3cmailto:bob at computerisms.ca>>>;

> bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org> <mailto:bucardo-general at bucardo.org>

> *Subject:* Re: [Bucardo-general] Bucardo Error

>

> Hi sir,

>

> Can you, using plain psql, access your bucardo database? And if so, is

> the relation bucardo_config there?

>

> Best regards.

>

> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

>

> On Wednesday, August 18th, 2021 at 7:18 PM, Thomas, Austin

> <Austin.Thomas at brxtn.com <mailto:Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com%20%3cmailto:Austin.Thomas at brxtn.com>>> wrote:

>

>     I attempted the $(sudo -c ""command" bucardo) method with no luck

>     and I am using the postgres superuser for the bucardo. See sample

>     pg_hba.conf file below where master-n are my postgres IPs:

>

>     Best regards,

>

>     Austin Thomas

>

>     Senior Software Developer

>

>     Mission Solutions – EGS SatOps Prototype and Integration (SPI)

>

>     6 N Tejon Street Suite 400

>

>     Colorado Springs, CO 80903

>

>     Office: 719.380.8488

>

>     Direct: 719.733.8100

>

>     Cell: 941.518.8488

>

>     Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com> <mailto:Austin.Thomas at brxtn.com>

>

>     -----Original Message-----

>

>     From: Michelle Sullivan <michelle at sorbs.net<mailto:michelle at sorbs.net>

>     <mailto:michelle at sorbs.net>>

>

>     Sent: Tuesday, August 17, 2021 7:50 PM

>

>     To: Computerisms Corporation <bob at computerisms.ca<mailto:bob at computerisms.ca>

>     <mailto:bob at computerisms.ca>>

>

>     Cc: Thomas, Austin <Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com>

>     <mailto:Austin.Thomas at brxtn.com>>; bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org>

>     <mailto:bucardo-general at bucardo.org>

>

>     Subject: Re: [Bucardo-general] Bucardo Error

>

>     You’re using the sudo command to root... I assume your Postgres

>     instance has a root user or you have setup your .rc file with

>     credentials..  however, don’t forget that if you chose a user other

>     than the default “bucardo” you *will* need to setup credentials in

>     the Shell home directory for the root user.. if you used the

>     defaults you may still need to depending on the version and who you

>     were when you used the bucardo setup utility.

>

>     Michelle Sullivan

>

>     http://www.mhix.org/ <http://www.mhix.org/>

>

>     Hallowed are those that walk in unison.

>

>      > On 18 Aug 2021, at 11:40, Computerisms Corporation

>     <bob at computerisms.ca <mailto:bob at computerisms.ca<mailto:bob at computerisms.ca%20%3cmailto:bob at computerisms.ca>>> wrote:

>

>      >

>

>      > well, guess that isn't the problem then ;)

>

>      >

>

>      > I note you are using sudo to run the command.  Not sure how your

>     setup works, but on my systems I need to have a bucardo users, and

>     do $(sudo -c "commands go here" bucardo), or switch to the bucardo user.

>

>      >

>

>      >> On 2021-08-17 6:35 p.m., Thomas, Austin wrote:

>

>      >> I've only started the bucardo installation on one instance so far.

>

>      >> I've been testing and installing on node-1 Get Outlook for iOS

>

>      >> <https://aka.ms/o0ukef <https://aka.ms/o0ukef<https://aka.ms/o0ukef%20%3chttps:/aka.ms/o0ukef>>>

>

>      >>

>

> ---------------------------------------------------------------------

>

>      >> ---

>

>      >> *From:* Computerisms Corporation <bob at computerisms.ca<mailto:bob at computerisms.ca>

>     <mailto:bob at computerisms.ca>>

>

>      >> *Sent:* Tuesday, August 17, 2021 7:28:06 PM

>

>      >> *To:* Thomas, Austin <Austin.Thomas at brxtn.com<mailto:Austin.Thomas at brxtn.com>

>     <mailto:Austin.Thomas at brxtn.com>>;

>

>      >> bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org> <mailto:bucardo-general at bucardo.org>

>     <bucardo-general at bucardo.org <mailto:bucardo-general at bucardo.org<mailto:bucardo-general at bucardo.org%20%3cmailto:bucardo-general at bucardo.org>>>

>

>      >> *Subject:* Re: [Bucardo-general] Bucardo Error just a guess;

> perhaps

>

>      >> you are running the command on the postgres instance that is

> *not

>

>      >> running bucardo?

>

>      >>> On 2021-08-17 2:51 p.m., Thomas, Austin wrote:

>

>      >>> Anyone seen this error before with Bucardo?  Google says to

> make

>

>      >>> sure the Bucardo database and postgres user are created but

> I've

>

>      >>> already confirmed that… *Best regards,* Austin Thomas *Senior

>

>      >>> Software Developer* *Mission Solutions – EGS SatOps Prototype

> and

>

>      >>> Integration (SPI) *

>

>      >>> *6 N Tejon Street Suite 400*

>

>      >>> *Colorado Springs, CO 80903*

>

>      >>> *Office: 719.380.8488*

>

>      >>> *Direct: 719.733.8100*

>

>      >>> *Cell: 941.518.8488*

>

>      >>> *Austin.Thomas at brxtn.com*<mailto:*Austin.Thomas at brxtn.com*> <mailto:*Austin.Thomas at brxtn.com*>

>

>      >>> _______________________________________________

>

>      >>> Bucardo-general mailing list

>

>      >>> Bucardo-general at bucardo.org<mailto:Bucardo-general at bucardo.org>

> <mailto:Bucardo-general at bucardo.org>

>

>      >>> https://bucardo.org/mailman/listinfo/bucardo-general

>     <https://bucardo.org/mailman/listinfo/bucardo-general>

>

>      >> <https://bucardo.org/mailman/listinfo/bucardo-general

>     <https://bucardo.org/mailman/listinfo/bucardo-general>>

>

>      > _______________________________________________

>

>      > Bucardo-general mailing list

>

>      > Bucardo-general at bucardo.org<mailto:Bucardo-general at bucardo.org>

> <mailto:Bucardo-general at bucardo.org>

>

>      > https://bucardo.org/mailman/listinfo/bucardo-general

>     <https://bucardo.org/mailman/listinfo/bucardo-general>

>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/0c3d4c1c/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 4096 bytes
Desc: image002.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/0c3d4c1c/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6468 bytes
Desc: image003.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/0c3d4c1c/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 19914 bytes
Desc: image004.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/0c3d4c1c/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 6468 bytes
Desc: image005.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/0c3d4c1c/attachment-0007.png>


More information about the Bucardo-general mailing list