DSN not working for Linux / Mysql

claustrophonic

unread,

Oct 5, 2004, 12:14:05 PM10/5/04

to

Hi,

Just had CFMX installed on our Linux server, and using the CF Server admin, I
can't assign DSN to the mysql database. i get this in red at the top of the
Datasources page when I try to set up the DSN:

Connection verification failed for data source: dbname
[]java.sql.SQLException: Invalid authorization specification: Access denied
for user: 'user...@localhost.localdomain' (Using password: YES)
The root cause was that: java.sql.SQLException: Invalid authorization
specification: Access denied for user: 'user...@localhost.localdomain' (Using
password: YES)

Naturally, I used real values for "dbname" and "username" above.

Not sure what the problem could be. Have only worked on CFMX for Windows in
the past.

Thanks in advance.

claustrophonic

unread,

Oct 5, 2004, 12:20:23 PM10/5/04

to

Just a note to add that I AM able to SSH into the server and connect to the
mysql via a command line, like so:

mysql -p --user=greg

Which then prompts me for password which I enter, then I'm in mysql.

-Greg

claustrophonic

unread,

Oct 5, 2004, 1:39:52 PM10/5/04

to

my problem looks like the fourth case on this page http://www.macromedia.com/support/coldfusion/ts/documents/tn17903.htm but the mysterious thing is that i am able to connect to the mysql via shell.

Coldfusionkiddie

unread,

Oct 14, 2004, 4:17:38 PM10/14/04

to

I don't really have any experience with your setup, but being a Unix admin, I feel your pain. Is is possible that the domain name tacked on to the end of the username is the problem?

lanfeustdetroy

unread,

Oct 18, 2004, 8:49:41 AM10/18/04

to

you have to edit your etc/host file and a simpler definition of your host
127.0.0.1 localhost localhost and remove (.localdomain)
it worked for me !

HippieX

unread,

Nov 3, 2004, 4:04:43 PM11/3/04

to

if you define your server as localhost it must be the first thing in your localhost file.

127.0.0.1 localhost machine_name

by default redhat puts the machine name first.

edixon_

unread,

Nov 8, 2004, 6:00:27 PM11/8/04

to

In my experience, CFADMIN pukes on using 'localhost', try and use 127.0.0.1 and more likely that not, everything will work.

EdmundPW

unread,

Nov 15, 2004, 12:27:27 PM11/15/04

to

Are you using MySQL 4.1 or above? If so you have change all your passwords using OLD_PASSWORD or else CF will get the same error as below.

Amin

unread,

Oct 20, 2005, 3:39:43 PM10/20/05

to

Hi I have same problem and I have modifiyed scripts in /etc/hosts

Old Code was
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
216.55.162.34 216-55-162-34.infopoint.co.ug

I have put new code as u said
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost localhost
216.55.162.34 216-55-162-34.infopoint.co.ug
--

but sill I am getting error as below
Connection verification failed for data source: habariDNS

[]java.sql.SQLException: Invalid authorization specification: Access

denied for user: 'habar...@localhost.localdomain' (Using password:

YES)
The root cause was that: java.sql.SQLException: Invalid authorization

specification: Access denied for user: 'habar...@localhost.localdomain'
(Using password: YES)

I have restart web server and CF.

I am using Fedora Core I with Plesk 7.5.4

Please help me

Regards
Amin

Amin

unread,

Oct 25, 2005, 4:14:19 PM10/25/05

to

Hi

anyone can give me solution for above error.......
PLEASE HELP ME..............

REG
AMIN

Amin

unread,

Oct 29, 2005, 2:10:39 PM10/29/05

to

I have found problem that I need to reboot server after edit file

That is it & it will work fine

Amin