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 22 3191
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
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
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...
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...
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).
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).
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).
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?
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).
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?
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?
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?
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?
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?
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?
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)
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?
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)
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
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
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)
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Acacia |
last post by:
How would you generate a random number in C++?
|
by: Figmo |
last post by:
I have MySQL 4 running on a Win2K3 Server. I can connect to it from
MySQL Control Center running on a client PC on our network. But I
cannot connect to it from the outside world. Get the "can't...
|
by: chris |
last post by:
Hi,
I try to connect to Access with php with te code below. The database and
table are ok.
<?php
include('../adodb/adodb.inc.php');
$db =& ADONewConnection('access');
$dsn =...
|
by: Manny |
last post by:
i'm using ver 1.1 of the framework developing a website, and seem to
getting a random "System.NullReferenceException" error. The error
occurs in different parts of the website in random fashion....
|
by: Mark Harrs |
last post by:
Hey all
I'm currently deploying a web service to our new servers and am having
something of an issue with it!? When one of the applications that use it
wasn't working correctly, i ran the web...
|
by: jabdulius |
last post by:
Hi all,
I'm trying to send a page using Perl via the WCTP protocol. For some reason, I cannot connect to the host "wctp.att.net/WCTP" (or any host for that matter). I figure it must be some...
|
by: =?Utf-8?B?Ulc=?= |
last post by:
Using this code:
Dim oConn As SqlClient.SqlConnection
oConn = New SqlClient.SqlConnection()
oConn.ConnectionString = "..." 'Connection string I got via an .udl file
oConn.Open()
I get an...
|
by: mthalavai |
last post by:
I am using the ftp functions in my project and it is properly run in my local server. but the same script is not working in client server.
My program
<?php
...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |