[Bucardo-general] Bucardo Error
Computerisms Corporation
bob at computerisms.ca
Thu Aug 26 20:59:39 UTC 2021
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*
>
> *Austin.Thomas at brxtn.com*
>
> *From:* Computerisms Corporation <bob at computerisms.ca>
> *Sent:* Thursday, August 26, 2021 12:34 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
>
> 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
>
> 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 <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 <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 <mailto:Austin.Thomas at brxtn.com>>>
>
> > *Cc:* Michelle Sullivan <michelle at sorbs.net
> <mailto: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
> <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 <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 <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 <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
> <mailto:Austin.Thomas at brxtn.com>>>; bucardo-general at bucardo.org
> <mailto: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/>
> <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 <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
> <mailto:Austin.Thomas at brxtn.com>>>;
>
> >
>
> > >> bucardo-general at bucardo.org
> <mailto: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* <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
> <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>>
>
> >
>
> > >> <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
> <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>>
>
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/82d9b9f5/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4096 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/82d9b9f5/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 6468 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/82d9b9f5/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 19914 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/82d9b9f5/attachment-0005.png>
More information about the Bucardo-general
mailing list