Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql connection on jserve

 
amit tantia
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have just got jserve installed on our servers. I would like the exact instructions how to set up mysql for it. Mysql has already been installed on our server.
 
Joe Wolf
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I suppose it'd be difficult to give exact instructions. But given that JServ and MySQL are installed, you should now install a driver so servlets you can user JDBC for MySQL access.
http://www.mysql.com/downloads/api-jdbc.html
Then, depending on what kind of security you want on your databases, you have to create a MySQL user someuser@"%" who has with the appropriate privileges. Do something like
GRANT ALL PRIVILEGES ON my_jdbc_database.* TO someuser IDENTIFIED BY 'somepassword';
For tighter security, replace "ALL PRIVILEGES" with "SELECT" or "UPDATE". After creating the user reload MySQL with
# ./mysqladmin reload �p
Then you create a servlet in your repository that can read data from my_jdbc_database. You can find example code on the web for this with the mm driver documentation.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic