[Bucardo-general] Bucardo Error
Computerisms Corporation
bob at computerisms.ca
Thu Aug 26 23:32:37 UTC 2021
Maybe enable query logging on postgres?
have you checked the bucardo logs for any details? pretty sure you can
enable debug level logging for that, as well.
On 2021-08-26 2:58 p.m., Thomas, Austin wrote:
> 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*
>
> *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)
>
> *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:* 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.
>
> 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>>
>
> >
>
More information about the Bucardo-general
mailing list