- Dan
Robert Douglass wrote:
Thank you Xavier, I added the password and username to both files, as you suggested. I get the following error message: [exec] D:\JavaTools\tdk\webapps\rob\WEB-INF\build>REM - Batch file to automatically create [exec] D:\JavaTools\tdk\webapps\rob\WEB-INF\build>REM - MySQL database from Windows machines :-) [exec] D:\JavaTools\tdk\webapps\rob\WEB-INF\build>mysqladmin -u root -prob123 -h 127.0.0.1 --force drop rob [exec] mysqladmin: connect to server at '127.0.0.1' failed [exec] error: 'Access denied for user: 'root@localhost' (Using password: YES)' [exec] D:\JavaTools\tdk\webapps\rob\WEB-INF\build>mysqladmin -u root -prob123 -h 127.0.0.1 --force create rob [exec] mysqladmin: connect to server at '127.0.0.1' failed [exec] error: 'Access denied for user: 'root@localhost' (Using password: YES)'BUILD FAILED file:D:/JavaTools/tdk/webapps/rob/WEB-INF/build/build.xml:119: exec returned: 1 I'm not sure at this point if this is a MySql problem or a Turbine problem. Both mysql.exe and mysqladmin.exe launch from any place in the directory, so I know they're on the path. The good news, is, I'm getting a different problem than before :-) I always see that as progress. -Robert Douglass --------------------------------------------------------------------------- I think that the user "root" needs a password. Set a password to the user. Then in the build.properties, complete the following lines : databaseUser = root databasePassword = your_password In the TurbineResources.properties, complete the following lines : database.default.username=root database.default.password=your_password In the build.xml, the tag "torque-create-db" looks like this : <torque-create-db controlTemplate="sql/db-init/Control.vm" outputDirectory="${outputDirectory}/sql" templatePath="${templatePath}" outputFile="${script}" targetPlatform="${platform}" targetDatabase="${database}" databaseName="${project}" databaseUser="${databaseUser}" databasePassword="${databasePassword}" databaseHost="${databaseHost}" /> I think that it would help you Xavier -----Original Message----- From: Robert Douglass [mailto:[EMAIL PROTECTED]] Sent: Monday, 20 January, 2003 8:28 PM To: [EMAIL PROTECTED] Subject: Help with ant init Hello all, I, a new TDK and MySql user, am having troubles with the ant init phase of creating a new database. Here are the steps I'd taken so far; On Win2K, using tdk2.1, I've edited the tdk/build.properties file and run ant. That creates a directory tdk/webapps/appname. I've downloaded and unpacked MySql 4.0.9 gamma. It runs as a service. I've stopped other services that listen to 127.0.0.1 (Apache). I've updated the following TWO properties in tdk/webapps/appname/web-inf/build/build.properties: databaseUser = root databasePassword = because I read in the MySql manual that new databases are created with an administrative user 'root' and an empty password. (Are there other properties the need setting?) When I run ant init, it hangs on the line [exec] D:\JavaTools\tdk\webapps\rob\WEB-INF\build>mysqladmin -u root -p -h 127.0.0.1 --force drop appname The processes java.exe and mysqld-max-nt.exe stay alive, albeit with no CPU cycles. I've tried creating the database appname in MySql before running this task, but it doesn't help, and I didn't get the idea that it was necessary from reading the TDK documentation. What have I done wrong? mysqladmin is on my PATH. I've spent quite a bit of time searching the mailing list archive, and haven't seen anyone with this exact problem. Help would be appreciated. -Robert Douglass -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
