Hi, I'm familiar with linux, mysql and so forth, but not tomcat.
I've tried in vain to get xplanner-plus working on a stock ubuntu server 10.04 which bundles tomcat6, no joy.
I've also downloaded tomcat5.5 and tried with that, it seems to get further, but still no joy. It is now complaining about a xplanner.person table not existing during migration on startup (i think) but has happily created other tables.
If anybody can help who is installed Xplanner-Plus on Ubuntu with MySql I would greatly appreciate a step by step.
For the installation detail on the wiki, I also have a comment.:
You could change:
create
user 'xplanner' identified by 'xp';
--default user and pw choose the user/pw you want
grant all privileges on *.* to xplanner;
--TODO there should be something changed to give xplanner not right on every db
to
--default user and pw choose the user/pw you want
grant all privileges on xplanner.* to 'xplanner'@'localhost' identified by 'secretPasswordForXplannerAtLocalhost';
This would limit the privileges to the xplanner.* tables, per the TODO note.
seems i have it working with tomcat5.5 manual install, after doing an rm -rm on the hsqldb directory that was in the directory beside tomcat.
ie i dropped tomcat into /usr/local/me/tomcat and there was creatd a /usr/local/me/hsqldb folder. I binned that. Restarted tomcat, have a xplanner plus page now.
Still very interested in step by step instruction to get it working on tomcat6 as this is the default with ubuntu 10.04.
thanks