Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'password'
I CANNOT connect using 'psql', I get authentication error.
-
ANYONE have any ideas why?
I now have tried an equal length name, and it logs in fine:
't012345678901_web_user' with pword 'password' works fine.
The problem below is consistent. I can drop and recrate the user, and it always cannot
be logged into using that name. I can successfully alter the user, so the system is
another name that does not work is 'H1q2W3e4R5_web_user'.
It seems to not like many alternations between numbers and letters.
Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user
tried it with two underscores and short name:
H1q2W_web_user
with only one underscore and a long name:
H1q2W3e4R5t6Y7u8Iweb_user
with only oneunderscore and a short name:
H1q2Wweb_user
with no underscore and a long name:
H1q2W3e4R5t6Y7u8Iwebuser
with no underschore and a short name:
Dennis Gearon wrote:
another name that does not work is 'H1q2W3e4R5_web_user'.
Sounds like a quoting problem. In the meantime, read this:
http://www.fr.postgresql.org/docs/7.4/static/bug-reporting.html
It seems to not like many alternations between numbers and letters.
Dennis Gearon
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
IIRC, psql (and the createuser shell script and such) treat it as if you
had double quoted its argument because of the way shells handle quotes
which would necessitate something like 'FOO' to use a quoted uppercase
name. So,
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
IIRC, psql (and the createuser shell script and such) treat it as if you
had double quoted its argument because of the way shells handle quotes
which would necessitate something like 'FOO' to use a quoted