running antclick with mySQL
...is more challenging than i thought. at least i have the database up & ready now, but i have yet to figure out how to connect. i think i've got the db.properties under control, but i can't figure out what to do with db.conf - is there a mySQL -version somewhere out there? couldn't find one in the CVS...
and if there isn't, could someone please care to explain what do to with database_path & root_path? i tried some variations that seemed logical to me, but none of it worked. ahem. feeling a little stupid right now...
kris
i have antville + mysql on my desktop and on a server in my factory.
Chronistin
thx, kris.
robert
all you have to do (assuming that your mysql-installation is running and the antville-database was setup correctly - you should use this sql-script) is to replace the db.properties-file of antville with the following:
the file db.conf is used just for the internal mckoi-database of antclick, you can safely ignore it if you're using mysql. if you're still getting errors please post them here.
Chronistin
nice to read you again!
what you propose is what i started out with. the result seemed to work (no error messages in any of the logs) but nothing was written to the database. that's why i thought i have to change the db.conf, too.
(in detail: everything worked fine as long as i didn't restart the hop. as soon as i did, there was no data. a manual query in mySQL revealed that my tables are in fact empty.)
[history]
i used the sql script you mentioned to create the database & my db-properties look just like above. only thing i changed are username & password, but i checked, re-checked & double-checked them on both ends (capitalization included), so that shouldn't be the problem.
next thing i tried was to remove the db.conf file (because i suspected it was there especially for the mcKoi stuff), and what i got when looking at "localhost" was
"Error retrieving NodeIDs: Datasource is not defined: antville."
so i figured that db.conf is necessary after all & tried to adapt it. playing around with paths & port got me a partial success at some point (instead of "Datasource is not defined" i could see the Antville Frontpage with a [HOP Macro Error: database-path not defined]).
Last thing i did was to avoid calling McKoi.jar in hop.bat, and ever since i'm stuck with "Error retrieving NodeIDs: Datasource is not defined: antville."
so I deduct that for some strange reason, my antclick is still trying to use McKoi.
Any ideas?
robert
short question: did you modify the db.properties in antclick's root-directory or the one in apps/antville? (you have to modify the latter!).
i just tested it once again on another machine, and it worked right out of the box.
Chronistin
Works fine now.
(I think I'm gonna hide under the carpet for the rest of the day)