View Full Version : Perfect Debian install (Sarge) with JDBC
handband2
25th April 2006, 21:26
First I want to thank FALKO for the great howto on the Debian install.
Now that I have the server up and running I would like to get the MySQL Connector/J 3.1 working. I've tried a few different ways but it doesn't seem to be working.
The software I'm trying to get up and running is the Wildfire IM server (http://www.jivesoftware.org/downloads.jsp#wildfire).
If anyone knows how or can refer me to a location on to configure Debian for the JDBC driver I would really appreciate it!
Thanks!!
falko
26th April 2006, 14:38
I haven't worked with the JDBC driver yet, but did you take a look here? http://www.jivesoftware.org/community/search.jspa?threadID=&q=mysql+debian+jdbc&objID=f40&dateRange=last90days&userID=&numResults=15&rankBy=10001
handband2
26th April 2006, 22:25
Thanks...I guess my frustration wasn't allowing me to get a good search on the forums.
I did get is working. For anyone else who wants to use JiveSoftware - wildfire this is how I got it working on a Debian Sarge 3.1 server:
http://www.jivesoftware.org/community/thread.jspa?messageID=116842
PART A Java on Debian:
(1) (as root) type: apt-get install java-package.
(2) (not as root) dowload the desired java sdk from java.sun.com
(3) (not as root) type: fakeroot make-jpkg <name-of-the sdk-file-you-downloaded>
It's really important you _don't_ do this part as root.
If you get an error saying that 'fakeroot' isn't found, then, as root, do:
apt-get install fakeroot.
When you have successfully run 'fakeroot make-jpkg', you should a debian package
in the same directory as your downloaded sun sdk, for example:
sun-j2sdk1.5_1.5.0+update06_i386.deb
Possible glitch; fakeroot complains that you are missing some plugins; try (as non-root):
for 32-bit machines:
DEB_BUILD_GNU_TYPE=x86_32-linux fakeroot make-jpkg <name-of-the-sdk-file-you-downloaded>
for amd 64-bit machines:
DEB_BUILD_GNU_TYPE=x86_64-linux fakeroot make-jpkg <name-of-the-sdk-file-you-downloaded>
commands are all on one line.
(4) Check you have the dependencies for java installed. As root
apt-get libasound2
apt-get java-common
apt-get xfree86-common
apt-get xlibs
apt-get libmysql-java (I installed this just in case)
Don't worry about messages saying you already have the latest version installed.
(5) Install your java debian package (as root)
dpkg -i <path-to-the-debian-package-you-built>,
e.g.
dpkg -i sun-j2sdk1.5_1.5.0+update06_i386.deb
(6) Hopefully all will be well. Try typing: java
at the command prompt.
PART B Wildfire on Debian.
(1) Download Wildfire. ( http://www.jivesoftware.org/downloads.jsp )
(2) Check you have 'alien' installed.
(as root) apt-get install alien
(3) Make the wildfire debian package:
fakeroot alien wildfire_2_6_2.rpm (or whatever version it is)
(4) You should now have a package called something like:
wildfire_2.6.2-2_i386.deb
in the directory where you ran 'fakeroot alien'.
(5) Install Wildfire:
(as root) dpkg -i wildfire_2.6.2-2_i386.deb (or whatever the name of your new debian package was)
-----
What I did...
6) Download mysql-connector-java ( http://dev.mysql.com/downloads/connector/j/3.0.html )
$ tar -xvzf mysql-connector-java-3.1.10.tgz
Copy mysql-connector-java-3.1.10-bin.jar to /usr/lib/j2sdk1.5-sun/jre/lib/ext
7) Since I want to use MySQL as my database I need to create a database and then my tables. Wildfire makes it easy, it comes with a MySQL script for all the tables:
/opt/wildfire/resources/database/wildfire_mysql.sql
I used phpmyadmin so it made it very easy! More instructions are here: ( http://www.jivesoftware.org/builds/wildfire/docs/latest/documentation/database.html )
8) make sure wildfire.xml is writable
# chmod 777 /opt/wildfire/conf/wildfire.xml
9) start up wildfire service
# /opt/wildfire/bin/wildfire start
9) Getting all the settings input
http://localhost:9090 or http://127.0.0.1:9090
In my debian setup it seemed all the defaults worked but when I tried to setup MySQL as my choice of database it wanted:
jdbc:mysql://server1.com:3306/wildfire
NOT
jdbc:mysql://localhost:3306/wildfire
10) protect your wildfire.xml file from being changed
# chmod 644 /opt/wildfire/conf/wildfire.xml
I hope this helps anyone who runs into problems like me.
If anyone has an easier and/or better way please share!!
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.