connection failed jdbc data source mysql

[espresso]

hello all

I have a problem,
  I have a data base Myphpadmin,
xml file to create the dimensions and measures

the connection works with iReport

hours should I do if I understood the connection with JasperSoft to make olap

but I can not connect to the database
I insert the data that are:
Driver: org.mysql.Driver
url: jdbc: mysql :/ / localhost: 3306/nomedb

when I go to test the connection tells me failed

I inserted anywhere: mysql-connector-java-5.0.5-bin

 

 

Someone can explain all the steps to configure my database and XML?? I need that data
thanks

Post Edited by espresso at 03/13/2012 22:38

[ogavavka]

 Hi, about your connection

If you can sucessfully connect to database using iReport then look for driver name and URL in iReport

enter into Connections/Datasources 

select connection

push "Modify" button

there you find which driver to use

and URL

in my case driver: com.mysql.jdbc.Driver

URL: jdbc:mysql://127.0.0.1:3306/databasename

i was trying to upload a image but i receive errors, trying to attach file...

About mysql-connector-java....  it must be in server lib folder, in my case: Jasperserver\apache-tomcat\lib\

my server version 4.5.0

Good luck.

[espresso]

thanks for the answer

iReport with me I can not connect me with JasperSoft success and that I can not follow all the procedures in this guide miente but when I go to add a new data source does not connect
I have the version mysql-connector-java-5.1.5-bin

[ogavavka]

To help you - need more data:

1. Which OS you use ?

2. Where mysql server is (on same host with Jasperserver or not) ?

Is mysql server listeting for connection on 3306 port and it`s acessible ?

to check this try running command "telnet ip_address_of_mysql_server 3306"

if it`s in same machine then "telnet 127.0.0.1 3306"

if mysql accept connection then you receive something like this " 5.0.67-community-nt"

if you receive "Connection failure" or "timeout" then Mysql server is not configured to work with network or firewall blocking it

 

If connection to mysql are sucessfull, then you must check is your login in mysql allowed to work from network !

[atifpmalik]

 espresso  .. have you been able to figure out what was wrong .. ?