I can’t get MySQL to work???
Hi,
I read through everything posted here and at project.antville.org. MySQL support seems to be an easy task but I can’t get it to work. I keep getting the error:
Error in application 'antville': Error retrieving Node: java.sql.SQLException: Datasource is not defined: antville.
I did exactly what the guides say. I created the mysql tables (I didn’t even change the password for the antville account) and I changed the apps/antville/db.properties to contain:
antville.url=jdbc:mysql://localhost:3306/antville antville.driver=org.gjt.mm.mysql.Driver antville.user=antville antville.password=antville
I’m running a freshly installed version of Red hat 9.0 (I had RH8 before, same problem) and I have these modifications in my hop.sh file:
JAVA_HOME=/usr/java/j2re1.4.1_02/ JAVA_OPTIONS="-Djava.awt.headless=true" AJP13_PORT=8009
It seems to me that it can’t connect to mysql. I though maybe the script connects remotely so I even got mysql to work from a remote location. I can connect to the antville db from another machine and access all the tables etc. using a mysql client.
I even install mod_jk and got that working with my wierd version of apache 2.0 which didn't like the pre-compiled mod_jk!
Does anyone have any suggestions on how I can track down the problem?
Thanks for any help you can give me.
-Stefan
nex
On my FreeBSD installation, 'localhost' doesn't work for some reason and has to be replaced with something like '127.0.0.1'; could that be the problem? And did you confirm your MySQL runs at port 3306?
Apart from that, I didn't spot any potential source of trouble in your description.
cyzoonic
127.0.0.1 doesn't work and I'm sure MySQL is on port 3306 since I connected to this port from another computer.
This is so odd.
-Stefan
tobi Verwaltung
nex, do you have helma running with freebsd or is it the mysql server only? just being curious how java performs with freebsd (apart from mac os x, that is).
nex
sorry tobi, didn't spot your question until now ... the system still isn't 100% installed, i had to do too much other things ... but i'll yell when it's doing something useful and post my notes on the configuration. i'm indeed running apache, mysql and helma+antville on a freebsd server. so far it performs great, but i have yet to collect data with a few dozen users :-)
hns
if it says something about "Error creating DbSource" in log/antville_event.log?
cyzoonic
............
[2003/04/17 15:45] Error creating DbSource antville
[2003/04/17 15:45] Reason: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
[2003/04/17 15:45] *** Data Source for prototype file does not exist: antville
[2003/04/17 15:45] *** accessing or storing a file object will cause an error.
...........
[2003/04/17 15:46] loaded macro help file
[2003/04/17 15:46] Exception in Transactor[antville/]: java.lang.RuntimeException: Error retrieving Node: java.sql.SQLException: Datasource is not defined: antville.
[2003/04/17 15:46] Error creating DbSource antville
[2003/04/17 15:46] Reason: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
...........
hns
Is most probably to put the following file into lib/ext/ (not lib/):
http://adele.helma.org/download/helma/contrib/hannes/mysql-2.0.14.jar
I added this point to my posting from yesterday. Sorry for the fuck-up.
cyzoonic
This was the problem, I needed that file in my lib/ext/ dir. thanks!
-Stefan