Moving the mysql database to a different server

[Kedgar]

Hello,

I'm looking into the possibility of moving the MySQL database from the jss
to a different server. Mainly to consolidate backup of multiple mysql
databases. I found that the JSS uses the username of jamfsoftware to access
the database. I have not seen in any documentation what that password is or
how to set it. As important is how would I tell the JSS to look for the
database on a different box? Has anyone done this before? We are looking
at tossing it onto a RHEL5 machine.

Thanks,
Ken

[tlarkin]

Actually, I think by default it uses the mysql root account with no password on OS X Server and you have to set a mysql root (different from system root) password.

So, just try mysql -u root -p

Then hit enter to keep the password blank or try entering a password for the mysql root user if one was set.

---

Thomas Larkin
TIS Department
KCKPS USD500
tlarki at kckps.org
blackberry: 913-449-7589
office: 913-627-0351
chown -R us /.base

[rmanly]

So you're saying they were just trying to keep me honest…nice

:)

~Ryan

[Kedgar]

I do see an account in that database called jamfsoftware. Also I'm looking
for where to point the JSS at a different database server.

[tlarkin]

The database is called jamfsoftware...

this is my JSS, and I use default installs

s001-casper:~ root# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 9298 Server version: 5.0.67-log Source distribution

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show databases ; +--------------------+ | Database | +--------------------+ | information_schema | | jamfsoftware | | mysql | | test | +--------------------+ 4 rows in set (0.00 sec)

mysql>

The user name you want is the mysql root user as it can administer the
database

[Kedgar]

Ok, think I found it... In /Library/Tomcat/conf/server.xml there is
information about how it connects to mysql. It shows the user
'jamfsoftware' and the password in this file. In mysql, you can see that
jamfsoftware is a user.

Looks like you may be able to change the mysql server from here as well.
There are a few variables called 'jdbcUrl' that point at the local server's
mysql database.

[Kedgar]

Hmm, dumpped the database to a new sql server box and can connect to it over
the network fine. However, the tomcat apps don't start properly after
editing /Library/Tomcat/server.xml I have contacted support to see if
they have any pointers... Maybe there are other files that need to be edited
in order to get this working.

[Cem]

.