[Bucardo-general] Bucardo Error
Michelle Sullivan
michelle at sorbs.net
Thu Aug 26 23:45:36 UTC 2021
Try not using batch and adding the DB host when prompted. Ensure you don’t have the name for the DB host in the /etc/hosts file pointing elsewhere.
Michelle Sullivan
http://www.mhix.org/
Hallowed are those that walk in unison.
> On 27 Aug 2021, at 09:32, Computerisms Corporation <bob at computerisms.ca> wrote:
>
> 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