JasperServer -- Backup MySQL & Tomcat ?

[runner1549]

What directory is JasperServer's MySQL located in and what is the backup for JasperServer's MySQL & Tomcat ?

P.S. I already have some experience with MySQL's backup & restore.

Thanks ...

[swood]

If you installed MySQL and Tomcat from the JasperServer installer, they are both under the installation directory.

 

I don't know what you mean by "what is the backup for JasperServer's MySQL & Tomcat".

 

Sherman

Jaspersoft

[runner1549]

Below are the steps I did:

1. cmd to C:Program FilesJasperServermysqlbin
2. type mysql –-user=root –-password=admin –-port=3306
3. type show databases;

Question #1 = Four database names appear, what is JasperServer's default db name ?

Question #2  = What is the default user/pass so I can do the below dump to backup the db ?

mysqldump –u User –p DataBaseName > dump.sql

Question #3 = I contacted sales@jaspersoft.com three days ago asking for JasperServer pricing, but got no reply, is there a better email address to send requests to ?

Thanks ...

 

[mmcaulay]

The default database is 'jasperserver'.

If you are able to show the databases, that means you logged in. Why can't you do the backup with those credentials for root? I assume you're using mysqldump?

Regards,

Mark.

[swood]

If you installed JasperServer and installed MySQL at that time, you would have been prompted to provide a MySQL user name and password. If you took the option to use a pre-existing MySQL instance, you would have had to have entered credentials for your enviornment.

 

Sherman

Jaspersoft

[tkavanagh]

On question three: The email you contacted is correct. I'll send to the sales dept directly for you now. Let me know if I can help further.

 

Regarding the users and passwords, the installer creates a few sets of hardcoded username/password sets. It is recommended that these be changed to better passwords once you go to Production.

 

1) MySQL DB Credentials

  a) root/password             - this is the MySQL root DB user

  b) jasperdb/password    - this is the DB user used by JasperServer at runtime

  c) (Database name used for the JasperServer repository:  jasperserver)

 

2) JasperServer User Login Credentials

  a) jasperadmin/jasperadmin      - default administrative user

  b) joeuser/joeuser                         - default standard user (created if you choose to install Sample Data)

 

[swood]

Scott,

The folks behind sales@jaspersoft.com did respond to you, but you did not follow up with them.

sales@jaspersoft.com is a good way to get in contact with Jaspersoft sales. You can also ask for information through www.jaspersoft.com

 

Sherman

Jaspersoft