-
1. Re: Issues and Resolutions
lphipps Oct 28, 2003 4:42 AM (in response to raja05)Yup I found with the snapshot download I got on October 27th that I had to run the MySQL command,
ALTER TABLE nuke_users ADD COLUMN pn_last_visit DATETIME NOT NULL DEFAULT '0';
after I had loaded the setup.ddl as that particular line was commented out of the setup.ddl but is required else you can't logon.
I also had to edit prepare.ddl to remove the ' ' tics from the line,
ON nukes.* TO nukes@localhost WITH GRANT OPTION;
And for my system I had to edit the,
$NUKES_HOME/nukes/src/resources/mysql/nukes-ds.xml
as follows: Change line 7 and replace,
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
with,
<driver-class>com.mysql.jdbc.Driver</driver-class>
Is there a reason to be using the Giant Java Tree definition as opposed to the MySQL.com one ?. Is GJT more future-proof or flexible over the MySQL one ?. -
2. Re: Issues and Resolutions
nefilim Oct 28, 2003 1:25 PM (in response to raja05)Same here, also, I had to add an entry into the MySQL user table for localhost.localdomain, which appears to be the target host when using jdbc on a redhat box with the localhost.localdomain /etc/hosts entry.
-
3. Re: Issues and Resolutions
julien1 Oct 28, 2003 3:50 PM (in response to raja05)> Same here, also, I had to add an entry into the MySQL
> user table for localhost.localdomain, which appears
> to be the target host when using jdbc on a redhat box
> with the localhost.localdomain /etc/hosts entry.
yes it suxx sometimes on redhat for that. -
4. Re: Issues and Resolutions
nefilim Oct 28, 2003 5:50 PM (in response to raja05)oh also, according to the mysql documentation the use of single ticks (') is valid and recommended for hostnames and usernames with non alphanumeric characters such as '-'.
i modified the statement to the following to make it work (dropped some privileges):
grant select,insert,update,delete,create,drop,references,index,alter on nukes.* to nukes@'localhost' with grant option;
and
grant select,insert,update,delete,create,drop,references,index,alter on nukes.* to nukes@'localhost.localdomain' with grant option;