Connecting to mysql with crystal reports via ODBC

sosa

Joined
Oct 2, 2008
Messages
3
Likes
0
Points
0
#1
I have recently installed an elastix server, working perfectly no issues yet. The only problem is the reports are pretty weak, and would like to connect to mysql tables to generate custom reports using crystal reports. I am using ODBC connector to connect to mysql,

I configured the connection with root username and password we set at initial setup. Set the right ip address and also I have tried the default mysql port 3306 but that didn't work. Does anyone know what the problem could be? What am I missing? Any help?
 

danardf

Joined
Dec 3, 2007
Messages
8,069
Likes
10
Points
88
#2
Hi.

Do you use root account with eLaStIx.2oo7 for password?

Port 3306 is ok!
 

sosa

Joined
Oct 2, 2008
Messages
3
Likes
0
Points
0
#3
Thanks for your response, we tried that and it gave me this error

[MySQL][ODBC 3.51 Driver]Host 'adsl-99-3-78-164.dsl.rcsntx.sbcglobal.net' is not allowed to connect to this MySQL server
 

edk

Joined
Sep 11, 2008
Messages
6
Likes
0
Points
0
#4
you have the answer in error , yours mysql server configure to allow connection from localhost only
 

sosa

Joined
Oct 2, 2008
Messages
3
Likes
0
Points
0
#5
Ya that makes sense, I logged into the machine using telnet, and ran mysql comman

shell> mysql -u root eLaStIx.2oo7

to do this

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
AND
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

but it wouldn't log me to mysql server, it throws back this error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Does anyone know what I need to do?
 

rafael

Joined
May 14, 2007
Messages
1,454
Likes
1
Points
0
#6
mysql -u root -p

and the you would be ask for the password

Regards,

Rafael
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,886
Members
17,563
Latest member
dineshr
Top