By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,822 Members | 729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,822 IT Pros & Developers. It's quick & easy.

random connect/authenication error

P: n/a
Hello everyone!

I'm hoping someone can shed some light on my ever daunting mysql/php
problem.

I'm currently trying to get a new server up and running using
apache/php/mysql. Everything runs fine, except every so often (very random)
mysql will not autenticate the username and password. Once you hit refresh
it goes through fine.

I started with apache 1.3/php 4.3.2/mysql 4.0.1

i then upgraded php to 4.3.3, no change
i then downgraded mysql to 3.23, no change

I've installed apache/php/mysql many times and have never had this problem.
I am stuck here and need to get this server production ready ASAP.

Thanks you in advance for any help you can provide.

-James
Jul 19 '05 #1
Share this Question
Share on Google+
22 Replies


P: n/a
Well it just failed from the command line, so I now can say it's a mysql
problem for sure.

Any ideas???

"James Kupernik" <ja************@verizon.net> wrote in message
news:Hr***************@nwrdny01.gnilink.net...
Hello everyone!

I'm hoping someone can shed some light on my ever daunting mysql/php
problem.

I'm currently trying to get a new server up and running using
apache/php/mysql. Everything runs fine, except every so often (very random) mysql will not autenticate the username and password. Once you hit refresh
it goes through fine.

I started with apache 1.3/php 4.3.2/mysql 4.0.1

i then upgraded php to 4.3.3, no change
i then downgraded mysql to 3.23, no change

I've installed apache/php/mysql many times and have never had this problem. I am stuck here and need to get this server production ready ASAP.

Thanks you in advance for any help you can provide.

-James

Jul 19 '05 #2

P: n/a
Well it just failed from the command line, so I now can say it's a mysql
problem for sure.

Any ideas???

"James Kupernik" <ja************@verizon.net> wrote in message
news:Hr***************@nwrdny01.gnilink.net...
Hello everyone!

I'm hoping someone can shed some light on my ever daunting mysql/php
problem.

I'm currently trying to get a new server up and running using
apache/php/mysql. Everything runs fine, except every so often (very random) mysql will not autenticate the username and password. Once you hit refresh
it goes through fine.

I started with apache 1.3/php 4.3.2/mysql 4.0.1

i then upgraded php to 4.3.3, no change
i then downgraded mysql to 3.23, no change

I've installed apache/php/mysql many times and have never had this problem. I am stuck here and need to get this server production ready ASAP.

Thanks you in advance for any help you can provide.

-James

Jul 19 '05 #3

P: n/a
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough
memory and processor (according to top).

[root@zeus root]# pstree
init-+-aacraid
|-atd
|-bdflush
|-crond
|-cucipop---2*[cucipop]
|-cupsd
|-httpd---7*[httpd]
|-keventd
|-khubd
|-4*[kjournald]
|-klogd
|-kscand/DMA
|-kscand/HighMem
|-kscand/Normal
|-ksoftirqd_CPU0
|-ksoftirqd_CPU1
|-ksoftirqd_CPU2
|-ksoftirqd_CPU3
|-kswapd
|-kupdated
|-master-+-nqmgr
| |-pickup
| `-2*[smtpd]
|-mdrecoveryd
|-6*[mingetty]
|-named
|-proftpd
|-rpc.statd
|-safe_mysqld---mysqld---mysqld---8*[mysqld]
|-scsi_eh_0
|-spamd
|-sshd---sshd---sshd---bash---su---bash---pstree
|-syslogd
|-xfs
`-xinetd---2*[in.telnetd]

When I said from the command line, i meant through an ssh connection. I
could not even get to the mysql prompt. I had to try it again, then it went
fine.

If you have any ideas on how I can start looking at socket/port/comm latency
that would be a big help!

Thank you so much!
"BDR" <jo*@noemail.com> wrote in message news:3F************@noemail.com...
At this point, since you've been from 4.01 to 3.23, I'd start looking at
the o/s itself. It sounds like it could be a socket/port/comm latency
problem with the server and not necessarily with MySql. (This assumes
you've got a problem and error free cpu, - eg... no ram problems, system
isn't running too hot, plenty of system overhead, etc ad-nauseum).

What's your server base os and version # anyways? Linux? Unix? Winsloth?

CPU/Ram/Swap Space/Free Disk space/Running Apps?

(Perhaps if you can run a top report to see what your server's actually
doing sec to sec...)

There's all kinds of help out here for all kinds and means of crazy
prob's like this, but what you're looking for, could be one that is
related to the O/S, or a combination of O/S kernel version and MySql itself.
Another issue, you said it failed from the command line, did you mean
from the mysql prompt, (telnet or ssh... or terminal connected directly
to the server itself?), or through a command prompt using another
interface... and how was that communicating to the server?.

fwiw....

Then again, it could be something as simple as your settings in the
config file... Not sure... I could be just blowing wind out my sass too.... --------------------------------------------------------------------
James Kupernik wrote:
Well it just failed from the command line, so I now can say it's a mysql
problem for sure.

Any ideas???


snip...

Jul 19 '05 #4

P: n/a
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough
memory and processor (according to top).

[root@zeus root]# pstree
init-+-aacraid
|-atd
|-bdflush
|-crond
|-cucipop---2*[cucipop]
|-cupsd
|-httpd---7*[httpd]
|-keventd
|-khubd
|-4*[kjournald]
|-klogd
|-kscand/DMA
|-kscand/HighMem
|-kscand/Normal
|-ksoftirqd_CPU0
|-ksoftirqd_CPU1
|-ksoftirqd_CPU2
|-ksoftirqd_CPU3
|-kswapd
|-kupdated
|-master-+-nqmgr
| |-pickup
| `-2*[smtpd]
|-mdrecoveryd
|-6*[mingetty]
|-named
|-proftpd
|-rpc.statd
|-safe_mysqld---mysqld---mysqld---8*[mysqld]
|-scsi_eh_0
|-spamd
|-sshd---sshd---sshd---bash---su---bash---pstree
|-syslogd
|-xfs
`-xinetd---2*[in.telnetd]

When I said from the command line, i meant through an ssh connection. I
could not even get to the mysql prompt. I had to try it again, then it went
fine.

If you have any ideas on how I can start looking at socket/port/comm latency
that would be a big help!

Thank you so much!
"BDR" <jo*@noemail.com> wrote in message news:3F************@noemail.com...
At this point, since you've been from 4.01 to 3.23, I'd start looking at
the o/s itself. It sounds like it could be a socket/port/comm latency
problem with the server and not necessarily with MySql. (This assumes
you've got a problem and error free cpu, - eg... no ram problems, system
isn't running too hot, plenty of system overhead, etc ad-nauseum).

What's your server base os and version # anyways? Linux? Unix? Winsloth?

CPU/Ram/Swap Space/Free Disk space/Running Apps?

(Perhaps if you can run a top report to see what your server's actually
doing sec to sec...)

There's all kinds of help out here for all kinds and means of crazy
prob's like this, but what you're looking for, could be one that is
related to the O/S, or a combination of O/S kernel version and MySql itself.
Another issue, you said it failed from the command line, did you mean
from the mysql prompt, (telnet or ssh... or terminal connected directly
to the server itself?), or through a command prompt using another
interface... and how was that communicating to the server?.

fwiw....

Then again, it could be something as simple as your settings in the
config file... Not sure... I could be just blowing wind out my sass too.... --------------------------------------------------------------------
James Kupernik wrote:
Well it just failed from the command line, so I now can say it's a mysql
problem for sure.

Any ideas???


snip...

Jul 19 '05 #5

P: n/a
The thing has been a nightmare from day one, I had a runaway mrtg which
locked it up every 32 hours. I've never had a system setup that was this
difficult. This is my last issue (i hope), so once I get this figured out
I'll be able to sleep at night.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
At this moment, all I can think of is to consider that the socket file
may be getting deleted by other system processes... That's the first and
easiest thing to check for. Take a `very close` look at this article:

http://www.mysql.com/doc/en/Problems...ysql.sock.html

I've seen this kind of a sit before, but under different circumstances
and results...

(And while we're at it I'll gladly trade boxes with you.. lol)

James Kupernik wrote:
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough memory and processor (according to top).

Jul 19 '05 #6

P: n/a
The thing has been a nightmare from day one, I had a runaway mrtg which
locked it up every 32 hours. I've never had a system setup that was this
difficult. This is my last issue (i hope), so once I get this figured out
I'll be able to sleep at night.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
At this moment, all I can think of is to consider that the socket file
may be getting deleted by other system processes... That's the first and
easiest thing to check for. Take a `very close` look at this article:

http://www.mysql.com/doc/en/Problems...ysql.sock.html

I've seen this kind of a sit before, but under different circumstances
and results...

(And while we're at it I'll gladly trade boxes with you.. lol)

James Kupernik wrote:
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough memory and processor (according to top).

Jul 19 '05 #7

P: n/a
Well that didn't seem to help any ...

Any other ideas ... (=

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
At this moment, all I can think of is to consider that the socket file
may be getting deleted by other system processes... That's the first and
easiest thing to check for. Take a `very close` look at this article:

http://www.mysql.com/doc/en/Problems...ysql.sock.html

I've seen this kind of a sit before, but under different circumstances
and results...

(And while we're at it I'll gladly trade boxes with you.. lol)

James Kupernik wrote:
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough memory and processor (according to top).

Jul 19 '05 #8

P: n/a
It fails when you try to connect. At the command line it's only done it as
root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next
try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...

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?

Jul 19 '05 #9

P: n/a
Well that didn't seem to help any ...

Any other ideas ... (=

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
At this moment, all I can think of is to consider that the socket file
may be getting deleted by other system processes... That's the first and
easiest thing to check for. Take a `very close` look at this article:

http://www.mysql.com/doc/en/Problems...ysql.sock.html

I've seen this kind of a sit before, but under different circumstances
and results...

(And while we're at it I'll gladly trade boxes with you.. lol)

James Kupernik wrote:
I'm running redhat linux 2.4.20-8smp

I have a dual 2.0 xeon processor with 512 RAM and 1GB swap. I have enough memory and processor (according to top).

Jul 19 '05 #10

P: n/a
It fails when you try to connect. At the command line it's only done it as
root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next
try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...

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?

Jul 19 '05 #11

P: n/a
BDR
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:
It fails when you try to connect. At the command line it's only done it as
root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next
try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?



Jul 19 '05 #12

P: n/a
BDR
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:
It fails when you try to connect. At the command line it's only done it as
root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next
try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?



Jul 19 '05 #13

P: n/a
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
602 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
030917 15:03:09 659 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
030917 15:04:20 670 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)

That is a mile log, hehe, it's the same error that I see either on the
webpage or from the command like when I try to connect to mysql

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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:
It fails when you try to connect. At the command line it's only done it as root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?


Jul 19 '05 #14

P: n/a
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
602 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
030917 15:03:09 659 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
030917 15:04:20 670 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)

That is a mile log, hehe, it's the same error that I see either on the
webpage or from the command like when I try to connect to mysql

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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:
It fails when you try to connect. At the command line it's only done it as root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?


Jul 19 '05 #15

P: n/a
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" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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:
It fails when you try to connect. At the command line it's only done it as root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?


Jul 19 '05 #16

P: n/a
BDR
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....

jk***@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:
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)


Jul 19 '05 #17

P: n/a
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" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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:
It fails when you try to connect. At the command line it's only done it as root, because I've only logged in that way as root.

It just seems to fail authentication for any user for a moment, then next try it works.

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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?


Jul 19 '05 #18

P: n/a
BDR
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....

jk***@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:
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)


Jul 19 '05 #19

P: n/a
BDR
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_size current value: 32768
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
delayed_queue_size current value: 1000
flush_time current value: 0
interactive_timeout current value: 28800
join_buffer_size current value: 131072
key_buffer_size current value: 8388600
long_query_time current value: 10
lower_case_table_names current value: 0
max_allowed_packet current value: 1048576
max_binlog_cache_size current value: 4294967295
max_binlog_size current value: 1073741824
max_connections current value: 100
max_connect_errors current value: 10
max_delayed_threads 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_connections current value: 0
max_write_lock_count current value: 4294967295
myisam_sort_buffer_size current value: 8388608
myisam_max_extra_sort_file_size current value: 256
myisam_max_sort_file_size current value: 2047
net_buffer_length current value: 16384
net_retry_count current value: 10
net_read_timeout current value: 30
net_write_timeout current value: 60
open_files_limit current value: 0
query_buffer_size current value: 0
record_buffer current value: 131072
record_rnd_buffer current value: 0
slave_net_timeout current value: 3600
slow_launch_time current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurrency current value: 10
thread_cache_size current value: 0
tmp_table_size current value: 33554432
thread_stack current value: 65536
wait_timeout current value: 28800

Jul 19 '05 #20

P: n/a
BDR
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_size current value: 32768
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
delayed_queue_size current value: 1000
flush_time current value: 0
interactive_timeout current value: 28800
join_buffer_size current value: 131072
key_buffer_size current value: 8388600
long_query_time current value: 10
lower_case_table_names current value: 0
max_allowed_packet current value: 1048576
max_binlog_cache_size current value: 4294967295
max_binlog_size current value: 1073741824
max_connections current value: 100
max_connect_errors current value: 10
max_delayed_threads 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_connections current value: 0
max_write_lock_count current value: 4294967295
myisam_sort_buffer_size current value: 8388608
myisam_max_extra_sort_file_size current value: 256
myisam_max_sort_file_size current value: 2047
net_buffer_length current value: 16384
net_retry_count current value: 10
net_read_timeout current value: 30
net_write_timeout current value: 60
open_files_limit current value: 0
query_buffer_size current value: 0
record_buffer current value: 131072
record_rnd_buffer current value: 0
slave_net_timeout current value: 3600
slow_launch_time current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurrency current value: 10
thread_cache_size current value: 0
tmp_table_size current value: 33554432
thread_stack current value: 65536
wait_timeout current value: 28800

Jul 19 '05 #21

P: n/a
still failed (put angry face here)

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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....

jk***@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:
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)

Jul 19 '05 #22

P: n/a
still failed (put angry face here)

"BDR" <jo*@noemail.com> wrote in message
news:3F**************@noemail.com...
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....

jk***@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:
yes, that is correct, here is a snip from the log

030917 13:49:54 409 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
476 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)
030917 14:35:30 534 Connect Access denied for user:
'phpBB@localhost' (Using password: YES)
556 Connect Access denied for user:
'jkupe@localhost' (Using password: YES)

Jul 19 '05 #23

This discussion thread is closed

Replies have been disabled for this discussion.