Connecting to mysql with crystal reports via ODBC

Discussion in 'General' started by sosa, Oct 3, 2008.

  1. sosa

    Joined:
    Oct 2, 2008
    Messages:
    3
    Likes Received:
    0
    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?
     
  2. danardf

    Joined:
    Dec 3, 2007
    Messages:
    8,069
    Likes Received:
    12
    Hi.

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

    Port 3306 is ok!
     
  3. sosa

    Joined:
    Oct 2, 2008
    Messages:
    3
    Likes Received:
    0
    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
     
  4. edk

    edk

    Joined:
    Sep 11, 2008
    Messages:
    6
    Likes Received:
    0
    you have the answer in error , yours mysql server configure to allow connection from localhost only
     
  5. sosa

    Joined:
    Oct 2, 2008
    Messages:
    3
    Likes Received:
    0
    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?
     
  6. rafael

    Joined:
    May 14, 2007
    Messages:
    1,454
    Likes Received:
    1
    mysql -u root -p

    and the you would be ask for the password

    Regards,

    Rafael
     

Share This Page