random connect/authenication error

[James Kupernik]

Re: random connect/authenication error

I think it's happening when more than one person tried to connect at the
same time ... this is just a guess, but when i was on my messageboard, there
was several people on there, and i got the error message more frequently
than I usually do.

http://www.saxmanwebs.com, if you want to check that out, play around it for
a while and you should hit the error.

"BDR" <joe@noemail.co m> wrote in message
news:3F68A7B1.8 040303@noemail. com...[color=blue]
> This, is the error you get when trying to connect?:
>
> Access denied for user: 'root@localhost ' (Using password: YES)
>
> The details are important, as I can't see what you're looking at...
>
> Does the @ ->'localhost' name show up in the access denied msg or is it
> without it?
>
> 4 and 40 time to start punting...
>
> James Kupernik wrote:[color=green]
> > It fails when you try to connect. At the command line it's only done it[/color][/color]
as[color=blue][color=green]
> > root, because I've only logged in that way as root.
> >
> > It just seems to fail authentication for any user for a moment, then[/color][/color]
next[color=blue][color=green]
> > try it works.
> >
> > "BDR" <joe@noemail.co m> wrote in message
> > news:3F688B25.5 060301@noemail. com...
> >[color=darkred]
> >>Exactly what error message are you receiving from the command line when
> >>you try to access mysql? I mean, is it when you try to log in as root
> >>or ? in mysql or is it failing intermittently when you're doing sample
> >>queries?
> >>[/color]
> >
> >
> >[/color]
>[/color]

[BDR]

Re: random connect/authenication error

Here's what I'd try.... 3rd and 10 again...

flush priviledges - try that.

Maybe set it up by actual ip address instead of localhost... 127.0.0.1 or
dang it....

jkupe@127.0.0.1 or....???

enter into your users table host: your actual ip instead of fqdn,
and see if it's not a network resolve thing...
or another way...

check the hosts file for 127.0.0.1 localhost?? or add your own entry to
it so that whatever you're connecting from will work directly as an ip
address so it doesn't have to verify the local host bit if you can get
my drift.

heck I don't know,
It's been a long time since I had to do anything network wise on a box
like this - (sorry but mine works forever and I forgot all this stuff
.... lol..) - but I REALLY THINK, that this is what is causing the
connection problem.

There's gotta be some linux network box guru on this thread somewhere
listening...


James Kupernik wrote:[color=blue]
> yes, that is correct, here is a snip from the log
>
> 030917 13:49:54 409 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)
> 476 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)
> 030917 14:35:30 534 Connect Access denied for user:
> 'phpBB@localhos t' (Using password: YES)
> 556 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)[/color]

[James Kupernik]

Re: random connect/authenication error

I think it's happening when more than one person tried to connect at the
same time ... this is just a guess, but when i was on my messageboard, there
was several people on there, and i got the error message more frequently
than I usually do.

http://www.saxmanwebs.com, if you want to check that out, play around it for
a while and you should hit the error.

"BDR" <joe@noemail.co m> wrote in message
news:3F68A7B1.8 040303@noemail. com...[color=blue]
> This, is the error you get when trying to connect?:
>
> Access denied for user: 'root@localhost ' (Using password: YES)
>
> The details are important, as I can't see what you're looking at...
>
> Does the @ ->'localhost' name show up in the access denied msg or is it
> without it?
>
> 4 and 40 time to start punting...
>
> James Kupernik wrote:[color=green]
> > It fails when you try to connect. At the command line it's only done it[/color][/color]
as[color=blue][color=green]
> > root, because I've only logged in that way as root.
> >
> > It just seems to fail authentication for any user for a moment, then[/color][/color]
next[color=blue][color=green]
> > try it works.
> >
> > "BDR" <joe@noemail.co m> wrote in message
> > news:3F688B25.5 060301@noemail. com...
> >[color=darkred]
> >>Exactly what error message are you receiving from the command line when
> >>you try to access mysql? I mean, is it when you try to log in as root
> >>or ? in mysql or is it failing intermittently when you're doing sample
> >>queries?
> >>[/color]
> >
> >
> >[/color]
>[/color]

[BDR]

Re: random connect/authenication error

Here's what I'd try.... 3rd and 10 again...

flush priviledges - try that.

Maybe set it up by actual ip address instead of localhost... 127.0.0.1 or
dang it....

jkupe@127.0.0.1 or....???

enter into your users table host: your actual ip instead of fqdn,
and see if it's not a network resolve thing...
or another way...

check the hosts file for 127.0.0.1 localhost?? or add your own entry to
it so that whatever you're connecting from will work directly as an ip
address so it doesn't have to verify the local host bit if you can get
my drift.

heck I don't know,
It's been a long time since I had to do anything network wise on a box
like this - (sorry but mine works forever and I forgot all this stuff
.... lol..) - but I REALLY THINK, that this is what is causing the
connection problem.

There's gotta be some linux network box guru on this thread somewhere
listening...


James Kupernik wrote:[color=blue]
> yes, that is correct, here is a snip from the log
>
> 030917 13:49:54 409 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)
> 476 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)
> 030917 14:35:30 534 Connect Access denied for user:
> 'phpBB@localhos t' (Using password: YES)
> 556 Connect Access denied for user:
> 'jkupe@localhos t' (Using password: YES)[/color]

[BDR]

Re: random connect/authenication error

It took me about 80 tries before I got a connect error, so it may be
your config settings.


Do this and see what your system vars are:

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --help'.
The default values (after parsing the command line arguments) are:

basedir: /usr/
datadir: /var/lib/mysql/
tmpdir: /tmp/
language: /usr/share/mysql/english/
pid file: /var/lib/mysql/serv.pid
TCP port: 3306
Unix socket: /var/lib/mysql/mysql.sock

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log current value: 50
bdb_cache_size current value: 8388600
bdb_log_buffer_ size current value: 0
bdb_max_lock current value: 10000
bdb_lock_max current value: 10000
binlog_cache_si ze current value: 32768
connect_timeout current value: 5
delayed_insert_ timeout current value: 300
delayed_insert_ limit current value: 100
delayed_queue_s ize current value: 1000
flush_time current value: 0
interactive_tim eout current value: 28800
join_buffer_siz e current value: 131072
key_buffer_size current value: 8388600
long_query_time current value: 10
lower_case_tabl e_names current value: 0
max_allowed_pac ket current value: 1048576
max_binlog_cach e_size current value: 4294967295
max_binlog_size current value: 1073741824
max_connections current value: 100
max_connect_err ors current value: 10
max_delayed_thr eads current value: 20
max_heap_table_ size current value: 16777216
max_join_size current value: 4294967295
max_sort_length current value: 1024
max_tmp_tables current value: 32
max_user_connec tions current value: 0
max_write_lock_ count current value: 4294967295
myisam_sort_buf fer_size current value: 8388608
myisam_max_extr a_sort_file_siz e current value: 256
myisam_max_sort _file_size current value: 2047
net_buffer_leng th current value: 16384
net_retry_count current value: 10
net_read_timeou t current value: 30
net_write_timeo ut current value: 60
open_files_limi t current value: 0
query_buffer_si ze current value: 0
record_buffer current value: 131072
record_rnd_buff er current value: 0
slave_net_timeo ut current value: 3600
slow_launch_tim e current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurre ncy current value: 10
thread_cache_si ze current value: 0
tmp_table_size current value: 33554432
thread_stack current value: 65536
wait_timeout current value: 28800

[BDR]

Re: random connect/authenication error

It took me about 80 tries before I got a connect error, so it may be
your config settings.


Do this and see what your system vars are:

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --help'.
The default values (after parsing the command line arguments) are:

basedir: /usr/
datadir: /var/lib/mysql/
tmpdir: /tmp/
language: /usr/share/mysql/english/
pid file: /var/lib/mysql/serv.pid
TCP port: 3306
Unix socket: /var/lib/mysql/mysql.sock

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log current value: 50
bdb_cache_size current value: 8388600
bdb_log_buffer_ size current value: 0
bdb_max_lock current value: 10000
bdb_lock_max current value: 10000
binlog_cache_si ze current value: 32768
connect_timeout current value: 5
delayed_insert_ timeout current value: 300
delayed_insert_ limit current value: 100
delayed_queue_s ize current value: 1000
flush_time current value: 0
interactive_tim eout current value: 28800
join_buffer_siz e current value: 131072
key_buffer_size current value: 8388600
long_query_time current value: 10
lower_case_tabl e_names current value: 0
max_allowed_pac ket current value: 1048576
max_binlog_cach e_size current value: 4294967295
max_binlog_size current value: 1073741824
max_connections current value: 100
max_connect_err ors current value: 10
max_delayed_thr eads current value: 20
max_heap_table_ size current value: 16777216
max_join_size current value: 4294967295
max_sort_length current value: 1024
max_tmp_tables current value: 32
max_user_connec tions current value: 0
max_write_lock_ count current value: 4294967295
myisam_sort_buf fer_size current value: 8388608
myisam_max_extr a_sort_file_siz e current value: 256
myisam_max_sort _file_size current value: 2047
net_buffer_leng th current value: 16384
net_retry_count current value: 10
net_read_timeou t current value: 30
net_write_timeo ut current value: 60
open_files_limi t current value: 0
query_buffer_si ze current value: 0
record_buffer current value: 131072
record_rnd_buff er current value: 0
slave_net_timeo ut current value: 3600
slow_launch_tim e current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurre ncy current value: 10
thread_cache_si ze current value: 0
tmp_table_size current value: 33554432
thread_stack current value: 65536
wait_timeout current value: 28800

[James Kupernik]

Re: random connect/authenication error

still failed (put angry face here)

"BDR" <joe@noemail.co m> wrote in message
news:3F68B496.9 020906@noemail. com...[color=blue]
> Here's what I'd try.... 3rd and 10 again...
>
> flush priviledges - try that.
>
> Maybe set it up by actual ip address instead of localhost... 127.0.0.1 or
> dang it....
>
> jkupe@127.0.0.1 or....???
>
> enter into your users table host: your actual ip instead of fqdn,
> and see if it's not a network resolve thing...
> or another way...
>
> check the hosts file for 127.0.0.1 localhost?? or add your own entry to
> it so that whatever you're connecting from will work directly as an ip
> address so it doesn't have to verify the local host bit if you can get
> my drift.
>
> heck I don't know,
> It's been a long time since I had to do anything network wise on a box
> like this - (sorry but mine works forever and I forgot all this stuff
> ... lol..) - but I REALLY THINK, that this is what is causing the
> connection problem.
>
> There's gotta be some linux network box guru on this thread somewhere
> listening...
>
>
> James Kupernik wrote:[color=green]
> > yes, that is correct, here is a snip from the log
> >
> > 030917 13:49:54 409 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)
> > 476 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)
> > 030917 14:35:30 534 Connect Access denied for user:
> > 'phpBB@localhos t' (Using password: YES)
> > 556 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)[/color]
>[/color]

[James Kupernik]

Re: random connect/authenication error

still failed (put angry face here)

"BDR" <joe@noemail.co m> wrote in message
news:3F68B496.9 020906@noemail. com...[color=blue]
> Here's what I'd try.... 3rd and 10 again...
>
> flush priviledges - try that.
>
> Maybe set it up by actual ip address instead of localhost... 127.0.0.1 or
> dang it....
>
> jkupe@127.0.0.1 or....???
>
> enter into your users table host: your actual ip instead of fqdn,
> and see if it's not a network resolve thing...
> or another way...
>
> check the hosts file for 127.0.0.1 localhost?? or add your own entry to
> it so that whatever you're connecting from will work directly as an ip
> address so it doesn't have to verify the local host bit if you can get
> my drift.
>
> heck I don't know,
> It's been a long time since I had to do anything network wise on a box
> like this - (sorry but mine works forever and I forgot all this stuff
> ... lol..) - but I REALLY THINK, that this is what is causing the
> connection problem.
>
> There's gotta be some linux network box guru on this thread somewhere
> listening...
>
>
> James Kupernik wrote:[color=green]
> > yes, that is correct, here is a snip from the log
> >
> > 030917 13:49:54 409 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)
> > 476 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)
> > 030917 14:35:30 534 Connect Access denied for user:
> > 'phpBB@localhos t' (Using password: YES)
> > 556 Connect Access denied for user:
> > 'jkupe@localhos t' (Using password: YES)[/color]
>[/color]