Any other ideas?
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.tho...@brxtn.com [cid:image002.png@01D7A3DA.4E6FB260] From: Thomas, Austin Sent: Thursday, August 26, 2021 3:59 PM To: Computerisms Corporation <b...@computerisms.ca>; Enrique P. <eps....@protonmail.com> Cc: Michelle Sullivan <miche...@sorbs.net>; bucardo-general@bucardo.org Subject: RE: [Bucardo-general] Bucardo Error 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.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> [cid:image003.png@01D7A3DA.4E632F40] From: Computerisms Corporation <b...@computerisms.ca<mailto:b...@computerisms.ca>> Sent: Thursday, August 26, 2021 3:00 PM To: Thomas, Austin <austin.tho...@brxtn.com<mailto:austin.tho...@brxtn.com>>; Enrique P. <eps....@protonmail.com<mailto:eps....@protonmail.com>> Cc: Michelle Sullivan <miche...@sorbs.net<mailto:miche...@sorbs.net>>; bucardo-general@bucardo.org<mailto:bucardo-general@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) [cid:image005.png@01D7A3DA.4E632F40] 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.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> [cid:image003.png@01D7A3DA.4E632F40] From: Computerisms Corporation <b...@computerisms.ca><mailto:b...@computerisms.ca> Sent: Thursday, August 26, 2021 12:34 PM To: Thomas, Austin <austin.tho...@brxtn.com><mailto:austin.tho...@brxtn.com>; Enrique P. <eps....@protonmail.com><mailto:eps....@protonmail.com> Cc: Michelle Sullivan <miche...@sorbs.net><mailto:miche...@sorbs.net>; bucardo-general@bucardo.org<mailto:bucardo-general@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. [cid:image006.png@01D7A3DA.4E632F40] 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.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> -----Original Message----- From: Computerisms Corporation <b...@computerisms.ca><mailto:b...@computerisms.ca> Sent: Wednesday, August 25, 2021 3:25 PM To: Thomas, Austin <austin.tho...@brxtn.com><mailto:austin.tho...@brxtn.com>; Enrique P. <eps....@protonmail.com><mailto:eps....@protonmail.com> Cc: Michelle Sullivan <miche...@sorbs.net><mailto:miche...@sorbs.net>; bucardo-general@bucardo.org<mailto:bucardo-general@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.tho...@brxtn.com*<mailto:*austin.tho...@brxtn.com*> > > *From:* Thomas, Austin > *Sent:* Wednesday, August 18, 2021 1:11 PM > *To:* Enrique P. <eps....@protonmail.com<mailto:eps....@protonmail.com>> > *Cc:* Michelle Sullivan <miche...@sorbs.net<mailto:miche...@sorbs.net>>; > Computerisms Corporation > <b...@computerisms.ca<mailto:b...@computerisms.ca>>; > bucardo-general@bucardo.org<mailto:bucardo-general@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.tho...@brxtn.com<mailto:*austin.tho...@brxtn.com> > <mailto:austin.tho...@brxtn.com>* > > *From:* Enrique P. <eps....@protonmail.com<mailto:eps....@protonmail.com> > <mailto:eps....@protonmail.com>> > *Sent:* Wednesday, August 18, 2021 12:33 PM > *To:* Thomas, Austin <austin.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> > <mailto:austin.tho...@brxtn.com>> > *Cc:* Michelle Sullivan <miche...@sorbs.net<mailto:miche...@sorbs.net> > <mailto:miche...@sorbs.net>>; Computerisms Corporation > <b...@computerisms.ca > <mailto:b...@computerisms.ca<mailto:b...@computerisms.ca%20%3cmailto:b...@computerisms.ca>>>; > bucardo-general@bucardo.org<mailto:bucardo-general@bucardo.org> > <mailto:bucardo-general@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.tho...@brxtn.com > <mailto:austin.tho...@brxtn.com<mailto:austin.tho...@brxtn.com%20%3cmailto:austin.tho...@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.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> > <mailto:austin.tho...@brxtn.com> > > -----Original Message----- > > From: Michelle Sullivan <miche...@sorbs.net<mailto:miche...@sorbs.net> > <mailto:miche...@sorbs.net>> > > Sent: Tuesday, August 17, 2021 7:50 PM > > To: Computerisms Corporation > <b...@computerisms.ca<mailto:b...@computerisms.ca> > <mailto:b...@computerisms.ca>> > > Cc: Thomas, Austin > <austin.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> > <mailto:austin.tho...@brxtn.com>>; > bucardo-general@bucardo.org<mailto:bucardo-general@bucardo.org> > <mailto:bucardo-general@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/> > > Hallowed are those that walk in unison. > > > On 18 Aug 2021, at 11:40, Computerisms Corporation > <b...@computerisms.ca > <mailto:b...@computerisms.ca<mailto:b...@computerisms.ca%20%3cmailto:b...@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 > <b...@computerisms.ca<mailto:b...@computerisms.ca> > <mailto:b...@computerisms.ca>> > > >> *Sent:* Tuesday, August 17, 2021 7:28:06 PM > > >> *To:* Thomas, Austin > <austin.tho...@brxtn.com<mailto:austin.tho...@brxtn.com> > <mailto:austin.tho...@brxtn.com>>; > > >> bucardo-general@bucardo.org<mailto:bucardo-general@bucardo.org> > <mailto:bucardo-general@bucardo.org> > <bucardo-general@bucardo.org > <mailto:bucardo-general@bucardo.org<mailto:bucardo-general@bucardo.org%20%3cmailto:bucardo-general@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.tho...@brxtn.com*<mailto:*austin.tho...@brxtn.com*> > <mailto:*austin.tho...@brxtn.com*> > > >>> _______________________________________________ > > >>> Bucardo-general mailing list > > >>> Bucardo-general@bucardo.org<mailto:Bucardo-general@bucardo.org> > <mailto:Bucardo-general@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>> > > > _______________________________________________ > > > Bucardo-general mailing list > > > Bucardo-general@bucardo.org<mailto:Bucardo-general@bucardo.org> > <mailto:Bucardo-general@bucardo.org> > > > https://bucardo.org/mailman/listinfo/bucardo-general > <https://bucardo.org/mailman/listinfo/bucardo-general> >
_______________________________________________ Bucardo-general mailing list Bucardo-general@bucardo.org https://bucardo.org/mailman/listinfo/bucardo-general
