Re: [GENERAL] Autentication exceptions in pgsql 8.3
Yes authd is running. And I am using 8.4 version. Sorry for the wrong version below. Thanks and Regards, Deepthi -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ext John R Pierce Sent: Monday, October 24, 2011 10:05 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3 On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote: Hello, I am using Postgresql 8.3, I am getting the belowauthenticationexceptions.I am not able to connect usingpostgres://mpp:mpp@localhost/mpp . hostall all 127.0.0.1/32 ident # IPv6 local connections: hostall all ::1/128 ident 'ident' on localhost requires your system runs an authd/identd service... is that the case? -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Autentication exceptions in pgsql 8.3
Hello, How can I check that? Should I do any configurations in ident server? Thanks and Regards, Deepthi From: ext Magnus Hagander [mailto:mag...@hagander.net] Sent: Monday, October 24, 2011 1:29 PM To: Prakash, Deepthi (NSN - IN/Bangalore) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3 On Monday, October 24, 2011, Prakash, Deepthi (NSN - IN/Bangalore) wrote: Hello, I am using Postgresql 8.3, I am getting the below authentication exceptions. I am not able to connect using postgres://mpp:mpp@localhost/mpp LOG: provided username (mpp) and authenticated username ([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match FATAL: Ident authentication failed for user mpp LOG: provided username (mpp) and authenticated username ([U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]) don't match This indicate that your auth server returned userid [U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=], which is obviously incorrect. Are you by any chance running with some sort of encryption/hashing in the ident server? That's not supported with PostgreSQL. If not that, then I'm not sure exactly what it could be - but it's obvious that your ident server is reporting an incorrect username, so you'll need to investigate that one. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
[GENERAL] Autentication exceptions in pgsql 8.3
Hello, I am using Postgresql 8.3, I am getting the below authentication exceptions. I am not able to connect using postgres://mpp:mpp@localhost/mpp LOG: provided username (mpp) and authenticated username ([U2FsdGVkX1/4XrEZ3dfREbh66kqWj66oEZjvotlVtqo=]) don't match FATAL: Ident authentication failed for user mpp LOG: provided username (mpp) and authenticated username ([U2FsdGVkX19aYlj8eW0BPmAZ4Loziuy64Urcd4ZhMOg=]) don't match Here is my contents in pg_ident.conf # MAPNAME SYSTEM-USERNAMEPG-USERNAME mpp mpp mpp Here are my contents in pg_hba.conf # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only local all postgres ident local all mpp ident local all mppadmin ident local all all ident # IPv4 local connections: hostall all 127.0.0.1/32 ident # IPv6 local connections: hostall all ::1/128 ident I tried adding the map and key value too but it did not help. Please help to resolve this issue. Thanks and Regards, Deepthi
Re: [GENERAL] Autentication exceptions in pgsql 8.3
Yes authd is running. And I am using 8.4 version. Sorry for the wrong version below. Thanks and Regards, Deepthi -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ext John R Pierce Sent: Monday, October 24, 2011 10:05 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Autentication exceptions in pgsql 8.3 On 10/23/11 9:08 PM, Prakash, Deepthi (NSN - IN/Bangalore) wrote: Hello, I am using Postgresql 8.3, I am getting the belowauthenticationexceptions.I am not able to connect usingpostgres://mpp:mpp@localhost/mpp . hostall all 127.0.0.1/32 ident # IPv6 local connections: hostall all ::1/128 ident 'ident' on localhost requires your system runs an authd/identd service... is that the case? -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Maximum limit on int in plpgsql
Hello, I am passing the ip address as a varchar. Eg: 133.9.4.11 Later on i am splitting the ip address with the delimiter as '.' ip1t:= split_part($1,'.',1); // returns a text value ip2t:= split_part($1,'.',2); // returns a text value ip3t:= split_part($1,'.',3); ip4t:= split_part($1,'.',4); Then i am type casting it into an integer select into ip1 cast(ip1t as integer); select into ip2 cast(ip2t as integer); select into ip3 cast(ip3t as integer); select into ip4 cast(ip4t as integer); The i am taking the sum using this formula out_sum=ip1*256*256*256+ip2*256*256+ip3*256+ip4; When i run the procedure i am getting following error pg_atoi : Numerical result out of range I tried all possible datatypes but still i am getting the same error. Is it the problem of typecasting or the limits on datatype? Thank you in advance, deepthi ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org