Raible's Wiki: AssistanceWithAntSetup

At line 1 changed 1 line.

If you are having problems with the root user account accessing mysql and setting up the AppFuse database, the chances are the problem is one of three things:

If you are having problems with the root user account accessing mysql and setting up

the AppFuse database, the chances are the problem is one of three things:

At line 3 changed 1 line.

*You have specified a password for the root user (but not changed build.properties to specify it)

*You have specified a password for the root user (but not changed build.properties

to specify it)

At line 7 changed 1 line.

The following describes how to re-initialising your root mysql account and ensuring things are setup correctly so ant setup runs smoothly.

The following describes how to re-initialising your root mysql account and

ensuring things are setup correctly so ant setup runs smoothly.

At line 9 changed 1 line.

When you login to mysql there are a number of databases available to you. One of these databases is called mysql which is the 'system' database. Within the mysql database, there is a table called 'users' which holds all the mysql user information, along with their grants (their privileges).

When you login to mysql there are a number of databases available to you. One of

these databases is called mysql which is the 'system' database. Within the mysql

database, there is a table called 'users' which holds all the mysql user information,

along with their grants (their privileges).

At line 14 changed 1 line.

Invalid authorization specification message from server: "Access denied for user: 'test@wl16lx1' (Using password: YES)"

Invalid authorization specification message from server:

"Access denied for user: 'test@wl16lx1' (Using password: YES)"

At line 17 changed 1 line.

Then your problem is NOT the root account and you need to change metadata/sql/mysql-create.sql to specify your hostname (along with your domain name if you have one, else just your hostname). Below, I have given an example if your hostname is 'mypc':

Then your problem is NOT the root account and you need to change

metadata/sql/mysql-create.sql to specify your hostname (along with your domain

name if you have one, else just your hostname). Below, I have given an example

if your hostname is 'mypc':

At line 25 changed 1 line.

Now, presuming it is the root account that you are getting errors with, here is how you reset the mysql DB to setup the root user with no password (to get you going with ant setup - you can add a root password after you have setup the appfuse DB).

Now, presuming it is the root account that you are getting errors with,

here is how you reset the mysql DB to setup the root user with no password (to

get you going with ant setup - you can add a root password after you have setup

the appfuse DB).

At line 27 changed 1 line.

In this example, we will pretend your hostname is 'mypc'. Also, where ${MYSQL_HOME} is shown, please replace that with the path to your mysql installation. At the end of these steps, you should be able to login to your mysql database and see this:

In this example, we will pretend your hostname is 'mypc'. Also, where ${MYSQL_HOME}

is shown, please replace that with the path to your mysql installation. At the end

of these steps, you should be able to login to your mysql database and see this:

At line 46 changed 1 line.

and if you execute select * from user where user = "root"; we want to see Y's on all the grant columns within the user table, which denotes that the root user has all the neccesary grant options to be able to setup the appfuse database and give the test user privileges on it.

and if you execute select * from user where user = "root"; we want to see Y's

on all the grant columns within the user table, which denotes that the root user

has all the neccesary grant options to be able to setup the appfuse database and

give the test user privileges on it.

At line 54 changed 1 line.

If mysql is still running (check the process on UNIX or use TaskManager on Windows), then kill the process:

If mysql is still running (check the process on UNIX or use TaskManager on Windows),

then kill the process:

At line 61 changed 1 line.

Now we want to restart mysql but bypass the authentication tables so we can go in and change the user database table, so now execute this command (UNIX command given but for Windows, leaving out the ampersand):

Now we want to restart mysql but bypass the authentication tables so we can go in

and change the user database table, so now execute this command (UNIX command

given but for Windows, leaving out the ampersand):

At line 76 changed 1 line.

Now we want to setup the root user using the GRANT command, so execute the following commands (Note you should change mypc to your hostname or hostname.domainname:

Now we want to setup the root user using the GRANT command, so execute the

following commands (Note you should change mypc to your hostname or hostname.domainname:

At line 90 changed 1 line.

We now have the root user setup properly, lets restart mysql without bypassing the authentication stuff.. Stop mysql using the instructions above once more. Now, if you run ant setup you might be ok. If you are not, and you are getting error:

We now have the root user setup properly, lets restart mysql without bypassing

the authentication stuff.. Stop mysql using the instructions above once more.

Now, if you run ant setup you might be ok. If you are not, and you are getting error:

At line 93 changed 1 line.

java.sql.SQLException: Invalid authorization specification message from server: "Access denied for user: 'test@wl16lx1' (Using password: YES)"

java.sql.SQLException: Invalid authorization specification message from server:

"Access denied for user: 'test@wl16lx1' (Using password: YES)"

Raible's Wiki

AppFuse

Other Applications

AssistanceWithAntSetup