Connecting to JasperServer MySQL DB

[elimesika]

HI

I need the connection string to the JasperServer MySQL DB

 

Thanks

[phlunk3]

I use the driver class name: com.mysql.jdbc.Driver

and as for connection url I have "jdbc:mysql://"SERVERURL:SERVERPORT/"databasename"

Hope this helps although it is for jasper workbench and not the actual server I presume it is somewhat similar.

[elimesika]

Thanks

But what are the specific parameter values for the JasperServer repository (dbname, user & password)

 

[anandharaj]

Where do you defining this? In JasperServer UI?

[elimesika]

HI

 

I want to connect to the MySQL repository using an external tool, what is the connection string I should use?

[anandharaj]

If you are using JDBC, the setting should be like below:

Driver class name: com.mysql.jdbc.Driver

Connection URL: jdbc:mysql://localhost/databasename?user=yourusername&password=yourpassword

Hope this is wht you looking for

[elimesika]

HI Again

Sorry for the misunderstanding .....

I will try to ask again ....

 

I have downloaded an external tool that can connect to MySQL DB

I did that in order to look on the Jasper Server repository schema and data.

What I need to know is

1) What is the name of the Jasper Servre database

2) What is the user name I can use to connect to this database

3) What is the password I can use to connect to this database

Thanks

 

 

 

 

Post Edited by elimesika at 05/12/2009 22:12

Post Edited by elimesika at 05/12/2009 22:12

[swood]

If you have a working version of JasperServer, you need to use the values you set when you installed.

 

Have a look in the web application META-INF/context.xml

 

 

Sherman

Jaspersoft

[elimesika]

HI

 

I am using

Host : 127.0.0.1

Schema : jasperserver

User : jasperdb

password  : password

 

and still got a connection error

 

 

[anandharaj]

If your tool not on the same server where the Jasper DB is running, than use the actual IP address instead of localhost / 127.0.0.1

[elimesika]

HI again and thanks for your help.

I am running the tool from the local machine where the jasperserver is installed.

I have looked at the context.xml file and the entry for the jasperserver repository looks as

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
            username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://127.0.0.1:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8"/>

and still , I can not connect to the database

Got MySQL error Number 2003

 

 

[anandharaj]

Simple way, test the connection from other SQL tool like SquirrelSQL just to be sure no issues on DB. What tool actually you wanted to use?

[elimesika]

HI

 

I have downloaded & installed SquirrelSQL , its working, Thanks for your help....I