[Bucardo-general] Bucardo Error

Thu Aug 26 18:25:31 UTC 2021

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:image001.png at 01D79A75.89E97AB0]

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

-----Original Message-----
From: Computerisms Corporation <bob at computerisms.ca>
Sent: Wednesday, August 25, 2021 3:25 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

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>>

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

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

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

> *Cc:* Michelle Sullivan <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>>

>

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

>

>     To: Computerisms Corporation <bob at computerisms.ca

>     <mailto:bob at computerisms.ca>>

>

>     Cc: Thomas, Austin <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>>

>

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

>

>      >> *To:* Thomas, Austin <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/486842e9/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 19914 bytes
Desc: image001.png
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/486842e9/attachment-0001.png>