SnipSnap on MySQL ~~This snip was written for SnipSnap 0.42. SnipSnap 0.5 has MySQL support. This means you do not have to run de database creation commands. It is stil needed to create de mySQL User and add the correct libraries~~ I have SnipSnap working on MySQL. There was no need to change the code. The installation is a bit more complex. Below is described what I did. 1.1 Create a mySQL database and a mySQL user (0.5 en 0.42). Login in mysql with the __mysql__ command. Execute the following command {code} GRANT ALL PRIVILEGES ON *.* to snipsnap@'%' IDENTIFIED by 'snipsnap' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO snipsnap@localhost IDENTIFIED by 'snipsnap' WITH GRANT OPTION; create database snipsnap; use database snipsnap; {code} Now you have an user snipsnap with the password snipsnap. For security reasons you can choose other values. 1.1 Create the database structure (only 0.42). Run the script __createdb.sql__ (the file can be found{link:here|http://home.planet.nl/~himalaya/createdb.sql}) with the following command. {code} source createdb.sql {code} Now you have the snip tables, a default snip and an user __admin__ with the password __snipsnap__ 1.1 Create a snipsnap application (only 0.42). Now you can create snipsnap application with the standard installer. This application will use by default the mckoi database. 1.1 Add the correct libraries (0.42 and 0.5). Copy the following libraries to the ~~applications\<appname>\WEB-INF\lib~~ directory: * __mysql.jar__: The jdbc driver. You can download mysql.jar {link:here|http://home.planet.nl/~himalaya/mysql.jar} or from the official {link:MySQL Site|http://www.mysql.com/downloads/api-jdbc-stable.html}. * __jdbcpool.jar__: This library can be found in the ~~snip\lib~~ directory. I do not know why this is needed, but otherwise it wil not work. 1.1 Change the configuration file (only 0.42) Change the following values in the configuration file: {code} admin.login=snipsnap admin.password=snipsnap app.jdbc.url=jdbc:mysql://10.0.0.175/snipsnap app.jdbc.driver=com.mysql.jdbc.Driver {code} 1.1 Import default snips (only 0.42) Restart snipsnap. Your application wil point to mySQL. Most if the standard information is gone. It must be reloaded. * Login as admin with the password snipsnap (only 0.42). * Go to the manager menu. * Use import to import the __export.xml__.You can download this file from {link:here|http://home.planet.nl/~himalaya/export.xml}. This is an export off a just installed application. 2004-01-06 14:01:40.24 2003-04-26 13:56:40.704 comment-SnipSnap on MySQL-1 thank you for the tips, I was able to adapt this info to get snipsnap working on MS sqlserver see [SnipSnap on MS sqlserver] 2003-04-29 03:19:50.384 2003-04-29 03:19:52.296 comment-SnipSnap on MySQL-2 That is great. I think the same is possible for Oracle. 2003-04-29 08:04:51.928 2003-04-29 08:04:50.976 comment-SnipSnap on MySQL-3 Should have come by earlier :-) My SnipSnap on MySQL runs pritty well. I suggest a small change to the JDBC URL: {code}app.jdbc.url=jdbc:mysql://10.0.0.175/snipsnap__?autoReconnect=true__{code} So the driver reconnects to the database. MySQL shuts down idle connections in a connection pool after 8 hours (default config). 2003-05-01 09:34:49.224 2003-05-01 09:34:49.264 comment-SnipSnap on MySQL-4 What's the advantage of using mysql ? 2003-05-03 10:13:21.368 2003-05-03 10:13:15.768 comment-SnipSnap on MySQL-5 All my applications use mysql. It is convenient for me to use just one database (special for backup and recovery). If you do not use mysql mckoi is fine. 2003-05-03 21:38:13.744 2003-05-03 21:38:14.552 comment-SnipSnap on MySQL-6 Good stuff. I might give this a go over the weekend. I've been concerned about SnipSnap using McKoi. Using MySQL, at least I will feel safe that all my data is being backed up. I've got a couple of concerns though: 1. Is it possible to migrate an existing SnipSnap to use MySQL? Your example script just creates a new database, and doesn't do any sort of import from the look of it. Can you export an existing site, create the database, reconfigure SnipSnap, restart, and import? 1. I've not looked at the database or the code, so perhaps you could confirm that all of SnipsSnap's data in terms of snips, usage counters, trackbacks, users, etc are all stored on the database? ie. all of the non-config related stuff. 1. What do we do when it's time to upgrade... can [funzel] and co bear in mind that users might be using alternative databases in their upgrade scripts? 2003-08-21 14:58:08.472 2003-08-21 14:58:03.512 comment-SnipSnap on MySQL-7 Yes. We take care about update the next versions. We want to make update as smooth as possible. For now you could export SnipSnap to XML and then reimport into a new installation. Yes. Everything is stored in the database except the config stuff (which will be stored in snips in 1.0 too) and CSS (which will be stored in snips after 1.0). 2003-08-21 15:17:10.24 2003-08-21 15:17:09.056 comment-SnipSnap on MySQL-8 The import and export are database agnostic. This means you can use then to convert a McKoi installation into a MySQL installation. The __export.xml__ script I use for a new MySQL installation comes from a fresh McKoi install. 2003-08-22 12:17:35.832 2003-08-22 12:17:37.928 comment-SnipSnap on MySQL-9 Works for me on 0.4.2a with MySQL4.0.15 and Connector-3.0.8-stable __if__ I add the user and password to the JDBC URL in the [application.conf] file. (Without those parameters, the connections will timeout.) 2003-10-07 20:02:29.848 2003-10-07 20:02:29.44 comment-SnipSnap on MySQL-10 Please Help! I'm using what i believe is the latest version of snipsnap (downloaded the .war a few days ago, just says SnipSnap 1.0b1-uttoxeter). I'm running mysql 4.023, and tomcat 5.0.28. I deployed the war. that's fine. Then i stopped the war site, and dumped the mysql jar and the jdbcpool jar files (weren't there already) into the /web-inf/lib folder. I've also dumped them into nearly every lib folder for tomcat i could find. I then start the service. i authenticate, then try and create a mysql database. It says the url is wrong. I've tried rebooting everything, still no luck. the database and username (no pass) exists - if i type the exact same data word for word into my connection string in Squirrel SQL it connects, no problems. but it doesn't like me! My connection string is jdbc:mysql://riaz01:3306/snipsnapdb. I've tried it with localhost, still no luck. it's for our intranet - we have a file system at present and want to start using a database. riaz01 is the server the database is on. I'm really stuck. I can't see what else i'm missing. i've tried the above tutorial but i still get nowhere. I've done everything that it says to do for snipsnap 0.5 but it doesn't seem to work. Please help. Thanks. 2005-01-18 09:56:23.191 2005-01-18 09:56:22.655 comment-SnipSnap on MySQL-11 It's just occured to me that the errors tomcat come out with say that it's trying to log into my database without the specified username/password - it's just using 'nobody' without a password. how do i get around this? Can anyone tell me how to put this info in the jdbc url? 2005-01-18 10:08:39.244 2005-01-18 10:08:38.704 comment-SnipSnap on MySQL-12 Fine! Just worked it out. You have to have a password otherwise snipsnap reverts to a 'nobody' login. This is fine, but you may want to look into this. Hope this helps anyone else trying to do this. Excellent system by the way. 2005-01-18 10:24:35.286 2005-01-18 10:24:34.725 comment-SnipSnap on MySQL-13 I guess the "nobody" is from the mysql driver itself. If you don't give it a name/password then the driver gets an empty string as far as I remember my programming. We should look into this anyway though. 2005-01-18 14:05:47.812 2005-01-18 14:05:47.288 comment-SnipSnap on MySQL-14 ....I can't find the jdbcpool.jar file anywhere! Where do you find it? Thanks, Timothy 2005-01-19 12:25:52.599 2005-01-19 12:25:52.061 comment-SnipSnap on MySQL-15 2005-02-06 22:48:51.662 2005-02-06 22:48:51.637 comment-SnipSnap on MySQL-16 __I have latest guide, please see here: [Install SnipSnap with Tomcat and MySQL|suxx0011/Install SnipSnap with Tomcat and MySQL]__ 2006-05-09 05:29:10.634 2006-05-09 05:21:28.317