Server Administration on Linux

Hi

A client has just setup a new Servoy install on a linux box using Servoy v4.1

He has it up an operational using Sybase for repository

He has MySQL on the same linux box and wants to point the repository to run under MySQL

The Linux version has no GUI to work with - only command line or Servoy Server Administration interface

How does he alter the repository to look at MySQL ?

Is there a guide anywhere to administering a linux server as I could not find anything on the forum ?

Cheers
Harry

Hi,

I would do this:
1.- Create one database in mysql for the repository with the same name and password as the current you have in sybase.

2.- Edit the file …/application_server/servoy.properties and search the string “serverName=repository_server”. In the line “URL=…” change the actual for “jdbc:mysql://localhost/<database_name>” and the driver for: “org.gjt.mm.mysql.Driver”

3.- Save the changes and the command line type: ./servoy_server.sh -upgradeRepository

4.- Start the server normally.

Hope this helps.

Hola Adelo

Thanks for the advice

I will ask my client to try this tomorrow

Gracias
Harry

Hi,

I have done the follows steps:

1 - I’ve installed the last java version on a remote linux server (centOS)
2 - I’ve installed servoy without console
3 - I’ve changed the servoy properties in:

server.0.serverName=repository_server
server.0.URL=jdbc:mysql://localhost:3306/servoy_repository
server.0.driver=org.gjt.mm.mysql.Driver
server.0.userName=DBA
server.0.password=
server.0.schema=<none>
server.0.catalog=<none>

I run “sh servoy_server.sh” and I obtain this error:

2011-09-20 16:50:44,187 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository: 
com.servoy.j2db.persistence.RepositoryException: Error checking repository
	at com.servoy.j2db.server.Zc.Za.Zb(Za.java:1132)
	at com.servoy.j2db.server.Zc.Za.<init>(Za.java:1349)
	at com.servoy.j2db.server.Zc.Za.<init>(Za.java:142)
	at com.servoy.j2db.server.Zc.Zo.Za(Zo.java:330)
	at com.servoy.j2db.server.ApplicationServer.main(ApplicationServer.java:265)
Caused by: java.sql.SQLException: JDBC Driver 'org.gjt.mm.mysql.Driver' not found in classpath or drivers directory : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver org.gjt.mm.mysql.Driver
	at com.servoy.j2db.server.Zc.Zo.Zh(Zo.java:752)
	at com.servoy.j2db.server.Zc.Zo.Zg(Zo.java:560)
	at com.servoy.j2db.server.Zc.Zo.checkIfTableExistsInDatabase(Zo.java:523)
	at com.servoy.j2db.server.Zc.Za.Zb(Za.java:969)
	... 4 more
2011-09-20 16:50:44,189 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!

Can someone help me?

Thanks in advance

Marco

you need to manually download the mysql jdbc driver, and put it into the drivers folder.
mySQL jdbc drivers can’t be shipped without permission.

Hi Harjo,

Because I’ve seen that a mySQL connection is between the connection template
I thought that the driver was already included and the error was in something other (classpath problem for example).

Ok, thanks Harjo! I go to download the driver!

Regards

Marco

Also remember to create the repository tables at the first run by using:

./servoy_server.sh -upgradeRepository

Ok, now it run properly!

thank you for your help(to all)!

Marco