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)
*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*
*[email protected]*
*From:* Computerisms Corporation <[email protected]>
*Sent:* Thursday, August 26, 2021 12:34 PM
*To:* Thomas, Austin <[email protected]>; Enrique P.
<[email protected]>
*Cc:* Michelle Sullivan <[email protected]>; [email protected]
*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.
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
[email protected] <mailto:[email protected]>
-----Original Message-----
From: Computerisms Corporation <[email protected]>
<mailto:[email protected]>
Sent: Wednesday, August 25, 2021 3:25 PM
To: Thomas, Austin <[email protected]>
<mailto:[email protected]>; Enrique P.
<[email protected]> <mailto:[email protected]>
Cc: Michelle Sullivan <[email protected]>
<mailto:[email protected]>; [email protected]
<mailto:[email protected]>
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*
>
> *[email protected]* <mailto:*[email protected]*>
>
> *From:* Thomas, Austin
> *Sent:* Wednesday, August 18, 2021 1:11 PM
> *To:* Enrique P. <[email protected]
<mailto:[email protected]>>
> *Cc:* Michelle Sullivan <[email protected]
<mailto:[email protected]>>; Computerisms Corporation
> <[email protected] <mailto:[email protected]>>;
[email protected] <mailto:[email protected]>
> *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*
>
> *[email protected] <mailto:*[email protected]>
<mailto:[email protected] <mailto:[email protected]>>*
>
> *From:* Enrique P. <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
> *Sent:* Wednesday, August 18, 2021 12:33 PM
> *To:* Thomas, Austin <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
> *Cc:* Michelle Sullivan <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>;
Computerisms Corporation
> <[email protected] <mailto:[email protected]
<mailto:[email protected]%20%3cmailto:[email protected]>>>;
> [email protected] <mailto:[email protected]>
<mailto:[email protected]
<mailto:[email protected]>>
> *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
> <[email protected] <mailto:[email protected]
<mailto:[email protected]%20%3cmailto:[email protected]>>>
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
>
> [email protected] <mailto:[email protected]>
<mailto:[email protected] <mailto:[email protected]>>
>
> -----Original Message-----
>
> From: Michelle Sullivan <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
>
> Sent: Tuesday, August 17, 2021 7:50 PM
>
> To: Computerisms Corporation <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
>
> Cc: Thomas, Austin <[email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>>; [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
>
> 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/>
<http://www.mhix.org/ <http://www.mhix.org/>>
>
> Hallowed are those that walk in unison.
>
> > On 18 Aug 2021, at 11:40, Computerisms Corporation
> <[email protected] <mailto:[email protected]
<mailto:[email protected]%20%3cmailto:[email protected]>>> 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 <[email protected]
<mailto:[email protected]>
> <mailto:[email protected] <mailto:[email protected]>>>
>
> >> *Sent:* Tuesday, August 17, 2021 7:28:06 PM
>
> >> *To:* Thomas, Austin <[email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>>;
>
> >> [email protected]
<mailto:[email protected]>
<mailto:[email protected]
<mailto:[email protected]>>
> <[email protected]
<mailto:[email protected]
<mailto:[email protected]%20%3cmailto:[email protected]>>>
>
> >> *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*
>
> >>> *[email protected]*
<mailto:*[email protected]*>
<mailto:*[email protected]* <mailto:*[email protected]*>>
>
> >>> _______________________________________________
>
> >>> Bucardo-general mailing list
>
> >>> [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
>
> >>> 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>>
>
> >> <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
>
> > [email protected]
<mailto:[email protected]>
> <mailto:[email protected]
<mailto:[email protected]>>
>
> > 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
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
