On 22 May 2001 11:01:59 -0400, Liu, Xiaoyan wrote:
> /home/xliu/Apache/turbine/tdk/webapps/newapp/WEB-INF/src/sql/newapp-id-table
> -init.sql
> 
> init-tasks:
> Hi, 
> 
> I'm trying to build the very first newapp with mysql3.23.38 and jdk1.3,
> somehow it
> failed at create database with the following exception. However, if I
> manually issue
> those sql as the same user, there doesn't seem to have any access permission
> problem.

As the same user *and* the same host name? In my experience mysql es
particularily picky about the "security" configuration.

In file <appname>/WEB-INF/build/project/<appname>.properties I have
these lines:

databaseUrl = jdbc:mysql://grass.iac.com.mx/woman
databaseDriver = org.gjt.mm.mysql.Driver
databaseUser = bruno
databasePassword = <my-password>
databaseHost = grass.iac.com.mx

Therefore, I *must* be able to establish a connection with the DB using
this line:

mysql -u bruno -p -h grass.iac.com.mx woman

Note that in this context using grass.iac.com.mx is *not* the same as
using localhost.


> 
> thanks for any information.
> 
> 
> -yan
> 
> ----------------------------------------------------------------------------
> ------------
> create-database:
> /home/xliu/Apache/turbine/tdk/webapps/newapp/WEB-INF/src/sql/create-database
> .sh
> 
> insert-sql:
> 
> insert-sql-file:
> 
> BUILD FAILED
> 
> /home/xliu/Apache/turbine/tdk/webapps/newapp/WEB-INF/build/build.xml:376:
> java.s
> ql.SQLException: Server configuration denies access to data source
> --- Nested Exception ---
> java.sql.SQLException: Server configuration denies access to data source
>       at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:193)
>       at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
>       at
> org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
>       at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
>       at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java)
>       at org.apache.tools.ant.Target.execute(Target.java)
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

-- 
"Create like a god,                Bruno Unna <[EMAIL PROTECTED]>
 command like a king,                   Internet de Alta Calidad
 and work like a slave."              Red Hat Certified Engineer
             Kawasaki                   PGP public key available


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to