[Bucardo-general] Bucardo Error
Computerisms Corporation
bob at computerisms.ca
Thu Aug 26 18:33:54 UTC 2021
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
>
> -----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 <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 <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>>>
>
> >
>
> > 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
> <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>>>
>
> >
>
> > >> *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 <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>>>
>
> >
>
> > > _______________________________________________
>
> >
>
> > > 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/22435c8a/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 19914 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210826/22435c8a/attachment-0001.png>
More information about the Bucardo-general
mailing list