On Mon, Jun 11, 2018 at 1:38 PM, Robert Emery <robertem...@codeweavers.net> wrote:
> Hello Again, > > I've just tested the patch and the output is *much* more verbose with the > same > set of flags now, even more so than the old version (see attached). > Yes. A many systems, pgAgent service starts before the database service file on opearting system start. Hence - instead of quitting on first connection failure, we attempt to connect the database server at least 10 time before quitting, and that would give the database server to start. -- Thanks, Ashesh > > Thanks, > Rob > > On 11/06/2018, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote: > > Hi Rob, > > > > > > On Mon, Jun 11, 2018 at 12:50 PM, Rob Emery <re-pg...@codeweavers.net> > > wrote: > > > >> Hi Ashesh, > >> > >> Log-level wise I was using the same command for both versions: > >> > >> ./pgagent -f -l 2 -t 1 -r 1 'hostaddr=server user=username > >> password=password dbname=postgres' > >> > >> and messing up the connection string in various ways (missing dbname, > >> incorrect password, incorrect hostaddr) > >> > >> This was built and tested on Debian GNU/Linux 9.4 (stretch). > >> > > If you're working on the source, would please test the patch sent by me? > > > >> > >> I've attached an example of the differing output when the dbname is > >> missing > >> from the connectionstring; basically it's the same for all errors. > >> > > > > Thanks a lot for the information. > > > > -- Thanks, Ashesh > > > >> > >> Many Thanks, > >> Rob > >> > >> On 11/06/2018, Ashesh Vashi <ashesh.va...@enterprisedb.com> wrote: > >> > Hi Rob, > >> > > >> > On Sun, Jun 10, 2018 at 2:26 AM, Rob Emery <re-pg...@codeweavers.net> > >> > wrote: > >> > > >> >> Hi Guys, > >> >> > >> >> I've been testing out PGAgent 4 (build today from master at commit > >> >> 86ca5c5ed1ad572075ba27e05e4680ebdf5b9feb) to check the connection > >> >> handling on error is still fixed with the boost reimplementation > >> >> (which it is!) > >> >> and noticed a few issues compared to PGAgent 3 around feedback to the > >> >> user if the connection string is incorrect. > >> >> > >> >> I've tested with incorrect username and password, user not in the > hba, > >> >> db doesn't exist, postgresql not running on the host (or incorrect > >> >> hostaddr) and 4 seems to always returns the error : > >> >> ` > >> >> ERROR: Couldn't find the function 'pgagent_schema_version' - please > >> >> run pgagent_upgrade.sql. > >> >> ` > >> >> > >> >> whereas 3.4.1 tends to output from the pgconnection itself like: > >> >> ` > >> >> Sat Jun 9 21:32:13 2018 : WARNING: Couldn't create the primary > >> >> connection (attempt 1): FATAL: no pg_hba.conf entry for host > >> >> "172.30.0.16", user "pgagent_login_role", database > >> >> "pgagent_login_role", SSL on > >> >> FATAL: no pg_hba.conf entry for host "172.30.0.16", user > >> >> "pgagent_login_role", database "pgagent_login_role", SSL off > >> >> ` > >> >> > >> >> which at least points the user towards the actual error! > >> >> > >> >> Not sure if this is known already, but I thought I'd raise it prior > to > >> >> release. > >> >> > >> > Thanks for sharing the information. > >> > > >> > Is it possible for you to share the logs with log level set to debug? > >> > Also - please share the operating system details? > >> > > >> > -- > >> > > >> > Thanks & Regards, > >> > > >> > Ashesh Vashi > >> > EnterpriseDB INDIA: Enterprise PostgreSQL Company > >> > <http://www.enterprisedb.com/> > >> > > >> > > >> > *http://www.linkedin.com/in/asheshvashi* > >> > <http://www.linkedin.com/in/asheshvashi> > >> > > >> > > >> > > >> >> > >> >> Thanks, > >> >> Rob > >> >> -- > >> >> > >> >> -- > >> >> <https://codeweavers.net> > >> >> > >> >> > >> >> Codeweavers May Newsletter > >> >> <https://mailchi.mp/codeweavers/march-edition-336883> l > Codeweavers > >> >> April > >> >> Finance Trends > >> >> <https://codeweavers.net/company-blog/codeweavers- > april-finance-trends> > >> >> > >> >> > >> >> April’s Dealer Highlights > >> >> <https://codeweavers.net/company-blog/aprils-dealer-highlights> > >> >> <https://codeweavers.net/company-blog/codeweavers- > >> march-car-finance-trends > >> >> > > >> >> > >> >> _ > >> >> _ > >> >> > >> >> > >> >> > >> >> *Phone:* 0800 021 0888 Email: contac...@codeweavers.net > >> >> <mailto:contac...@codeweavers.net> > >> >> Codeweavers Ltd | Barn 4 | Dunston > >> >> Business Village | Dunston | ST18 9AB > >> >> Registered in England and Wales No. > >> >> 04092394 | VAT registration no. 974 9705 63 > >> >> > >> >> > >> >> > >> >> > >> >> <https://www.linkedin.com/company/codeweavers-limited> > >> >> <https://vimeo.com/codeweaversltd> > >> >> <https://plus.google.com/b/105942302039373248738/+CodeweaversNet> > >> >> <https://twitter.com/CodeweaversTeam> > >> >> > >> >> > >> >> > >> > > >> > >> -- > >> <https://codeweavers.net> > >> > >> > >> Codeweavers May Newsletter > >> <https://mailchi.mp/codeweavers/march-edition-336883> l Codeweavers > >> April > >> Finance Trends > >> <https://codeweavers.net/company-blog/codeweavers-april-finance-trends> > >> > >> > >> April’s Dealer Highlights > >> <https://codeweavers.net/company-blog/aprils-dealer-highlights> > >> <https://codeweavers.net/company-blog/codeweavers- > march-car-finance-trends > >> > > >> > >> _ > >> _ > >> > >> > >> > >> *Phone:* 0800 021 0888 Email: contac...@codeweavers.net > >> <mailto:contac...@codeweavers.net> > >> Codeweavers Ltd | Barn 4 | Dunston > >> Business Village | Dunston | ST18 9AB > >> Registered in England and Wales No. > >> 04092394 | VAT registration no. 974 9705 63 > >> > >> > >> > >> > >> <https://www.linkedin.com/company/codeweavers-limited> > >> <https://vimeo.com/codeweaversltd> > >> <https://plus.google.com/b/105942302039373248738/+CodeweaversNet> > >> <https://twitter.com/CodeweaversTeam> > >> > >> > > > > > -- > Robert Emery > Infrastructure Director > > E: robertem...@codeweavers.net | T: 01785 711633 | W: www.codeweavers.net > > -- > <https://codeweavers.net> > > > Codeweavers May Newsletter > <https://mailchi.mp/codeweavers/march-edition-336883> l Codeweavers > April > Finance Trends > <https://codeweavers.net/company-blog/codeweavers-april-finance-trends> > > > April’s Dealer Highlights > <https://codeweavers.net/company-blog/aprils-dealer-highlights> > <https://codeweavers.net/company-blog/codeweavers-march-car-finance-trends > > > > _ > _ > > > > *Phone:* 0800 021 0888 Email: contac...@codeweavers.net > <mailto:contac...@codeweavers.net> > Codeweavers Ltd | Barn 4 | Dunston > Business Village | Dunston | ST18 9AB > Registered in England and Wales No. > 04092394 | VAT registration no. 974 9705 63 > > > > > <https://www.linkedin.com/company/codeweavers-limited> > <https://vimeo.com/codeweaversltd> > <https://plus.google.com/b/105942302039373248738/+CodeweaversNet> > <https://twitter.com/CodeweaversTeam> > >
