You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Erik Engstrom <ee...@ip-wizard.com> on 2001/08/08 05:45:05 UTC
ant init problems
Hi,
I am trying to get the tdk(2.1) up and running on RH 7.1, sun's jdk1.3.1 and
mysql 3.23.40. I changed the build.properties to an account that I created
with full permissions. I am able to create tables with that account in
mysql but when i run the ant init script no tables are created and I get the
following error. I get the same results when using the root account for the
database. Any ideas?
Thanks in advance,
Erik
<------------------------------build output ------------------------------>
Buildfile: build.xml
init:
init-tasks:
set-os:
set-windows2000:
set-windowsNT:
set-windows98:
set-unix:
unix-ext:
windows-ext:
ext:
[echo] Platform = unix
[echo] Extension = sh
create-database:
[echo] create-database.sh
/home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/create-database.sh
[exec] Database "newapp" dropped
init-tasks:
turbine-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for Turbine base system! |
[echo] | |
[echo] +------------------------------------------+
/home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-schema.sql
init-tasks:
turbine-id-table-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating SQL for YOUR Turbine project! |
[echo] | Woo hoo! |
[echo] | |
[echo] +------------------------------------------+
/home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/id-table-schema.sql
init-tasks:
turbine-id-table-init-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating TURBINE initialization SQL |
[echo] | for ID Broker system! |
[echo] | |
[echo] +------------------------------------------+
/home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-id-table-init.sql
init-tasks:
turbine-security-sql:
[echo] +------------------------------------------+
[echo] | |
[echo] | Generating Turbine security system SQL! |
[echo] | |
[echo] +------------------------------------------+
/home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-security.sql
turbine-insert-sql:
insert-sql-file:
BUILD FAILED
/home/engs1eri/tdk/webapps/newapp/WEB-INF/build/build.xml:367:
java.sql.SQLExcep
tion: Invalid authorization specification: Access denied for user:
'turbine@loca
lhost.localdomain' (Using password: YES)
--- Nested Exception ---
java.sql.SQLException: Invalid authorization specification: Access denied
for us
er: 'turbine@localhost.localdomain' (Using password: YES)
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:265)
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:352)
at org.apache.tools.ant.Target.execute(Target.java:153)
at org.apache.tools.ant.Project.runTarget(Project.java:898)
at org.apache.tools.ant.Project.executeTarget(Project.java:536)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
at org.apache.tools.ant.Target.execute(Target.java:153)
at org.apache.tools.ant.Project.runTarget(Project.java:898)
at org.apache.tools.ant.Project.executeTarget(Project.java:536)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
at org.apache.tools.ant.Target.execute(Target.java:153)
at org.apache.tools.ant.Project.runTarget(Project.java:898)
at org.apache.tools.ant.Project.executeTarget(Project.java:536)
at org.apache.tools.ant.Project.executeTargets(Project.java:510)
at org.apache.tools.ant.Main.runBuild(Main.java:421)
at org.apache.tools.ant.Main.main(Main.java:149)
Total time: 32 seconds
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: ant init problems
Posted by Erik Engstrom <ee...@ip-wizard.com>.
Sorry for the poorly worded subject. Thanks for the tip.
-----Original Message-----
From: Jason van Zyl [mailto:jvanzyl@apache.org]
Sent: August 07, 2001 10:49 PM
To: turbine-user@jakarta.apache.org
Subject: Re: ant init problems
Please take care with your subject line: this is not an 'ant init' problem.
This is a configuration error on your part, looks like a misconfiguration of
MySQL.
If you want to try things quickly, go to
/etc/rc.d/init.d/mysqld
and add
--skip-grant-tables
to the options that are used when starting mysql. I use this on my test
machine so that I can test the TDK quickly. Definitely NOT recommended as a
standard setup but it will get you going until you figure out your mysql
problem.
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ant init problems
Posted by Jason van Zyl <jv...@apache.org>.
On 8/7/01 11:45 PM, "Erik Engstrom" <ee...@ip-wizard.com> wrote:
> Hi,
>
> I am trying to get the tdk(2.1) up and running on RH 7.1, sun's jdk1.3.1 and
> mysql 3.23.40. I changed the build.properties to an account that I created
> with full permissions. I am able to create tables with that account in
> mysql but when i run the ant init script no tables are created and I get the
> following error. I get the same results when using the root account for the
> database. Any ideas?
>
> Thanks in advance,
Please take care with your subject line: this is not an 'ant init' problem.
This is a configuration error on your part, looks like a misconfiguration of
MySQL.
If you want to try things quickly, go to
/etc/rc.d/init.d/mysqld
and add
--skip-grant-tables
to the options that are used when starting mysql. I use this on my test
machine so that I can test the TDK quickly. Definitely NOT recommended as a
standard setup but it will get you going until you figure out your mysql
problem.
> Erik
>
> <------------------------------build output ------------------------------>
>
> Buildfile: build.xml
>
> init:
>
> init-tasks:
>
> set-os:
>
> set-windows2000:
>
> set-windowsNT:
>
> set-windows98:
>
> set-unix:
>
> unix-ext:
>
> windows-ext:
>
> ext:
> [echo] Platform = unix
> [echo] Extension = sh
>
> create-database:
> [echo] create-database.sh
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/create-database.sh
> [exec] Database "newapp" dropped
>
> init-tasks:
>
> turbine-sql:
> [echo] +------------------------------------------+
> [echo] | |
> [echo] | Generating SQL for Turbine base system! |
> [echo] | |
> [echo] +------------------------------------------+
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-schema.sql
>
> init-tasks:
>
> turbine-id-table-sql:
> [echo] +------------------------------------------+
> [echo] | |
> [echo] | Generating SQL for YOUR Turbine project! |
> [echo] | Woo hoo! |
> [echo] | |
> [echo] +------------------------------------------+
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/id-table-schema.sql
>
> init-tasks:
>
> turbine-id-table-init-sql:
> [echo] +------------------------------------------+
> [echo] | |
> [echo] | Generating TURBINE initialization SQL |
> [echo] | for ID Broker system! |
> [echo] | |
> [echo] +------------------------------------------+
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-id-table-init.sql
>
> init-tasks:
>
> turbine-security-sql:
> [echo] +------------------------------------------+
> [echo] | |
> [echo] | Generating Turbine security system SQL! |
> [echo] | |
> [echo] +------------------------------------------+
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/src/sql/turbine-security.sql
>
> turbine-insert-sql:
>
> insert-sql-file:
>
> BUILD FAILED
>
> /home/engs1eri/tdk/webapps/newapp/WEB-INF/build/build.xml:367:
> java.sql.SQLExcep
> tion: Invalid authorization specification: Access denied for user:
> 'turbine@loca
> lhost.localdomain' (Using password: YES)
> --- Nested Exception ---
> java.sql.SQLException: Invalid authorization specification: Access denied
> for us
> er: 'turbine@localhost.localdomain' (Using password: YES)
> at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330)
> at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:265)
> 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:352)
> at org.apache.tools.ant.Target.execute(Target.java:153)
> at org.apache.tools.ant.Project.runTarget(Project.java:898)
> at org.apache.tools.ant.Project.executeTarget(Project.java:536)
> at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
> at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
>
> at org.apache.tools.ant.Target.execute(Target.java:153)
> at org.apache.tools.ant.Project.runTarget(Project.java:898)
> at org.apache.tools.ant.Project.executeTarget(Project.java:536)
> at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:213)
> at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:103)
>
> at org.apache.tools.ant.Target.execute(Target.java:153)
> at org.apache.tools.ant.Project.runTarget(Project.java:898)
> at org.apache.tools.ant.Project.executeTarget(Project.java:536)
> at org.apache.tools.ant.Project.executeTargets(Project.java:510)
> at org.apache.tools.ant.Main.runBuild(Main.java:421)
> at org.apache.tools.ant.Main.main(Main.java:149)
>
> Total time: 32 seconds
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: newbie sql2xml ant task question
Posted by Huy Do <hu...@tramada.com>.
I was using the schema dump from pg_dump -s.
CREATE TABLE bkn_contact_comments (
key1 character varying(12) NOT NULL,
key2 character varying(12) NOT NULL,
description character varying(60),
contact_comm_desc text,
Constraint bkn_contact_comments_pkey Primary Key (key1, key2));
sql2xml doesn't seem to like the line
Constraint bkn_contact_comments_pkey Primary Key (key1, key2)
It loops indefinitely. It works fine if i just use Primary Key (key1, key2)
Thanks
Huy
> -----Original Message-----
> From: Leon Messerschmidt [mailto:leon@opticode.co.za]
> Sent: Wednesday, 8 August 2001 5:54 PM
> To: turbine-user@jakarta.apache.org
> Subject: Re: newbie sql2xml ant task question
>
>
> Hi Huy,
>
> It is working for me. If you have problems I could help fix them.
>
> ~ Leon
>
> ----- Original Message -----
> From: "Huy Do" <hu...@tramada.com>
> To: <tu...@jakarta.apache.org>
> Sent: Wednesday, August 08, 2001 7:06 AM
> Subject: newbie sql2xml ant task question
>
>
> > Hi all,
> >
> > Just trying to use the sql2xml ant task. Is it working ?
> > I saw a posting in the archive which said it is not really
> > working. Is this true ?
> >
> > Is there any other way of converting an existing database schema
> > (postgresql) into an xml schema so I can use torque.
> >
> > Many thanks
> >
> > Huy
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: turbine-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: newbie sql2xml ant task question
Posted by Leon Messerschmidt <le...@opticode.co.za>.
Hi Huy,
It is working for me. If you have problems I could help fix them.
~ Leon
----- Original Message -----
From: "Huy Do" <hu...@tramada.com>
To: <tu...@jakarta.apache.org>
Sent: Wednesday, August 08, 2001 7:06 AM
Subject: newbie sql2xml ant task question
> Hi all,
>
> Just trying to use the sql2xml ant task. Is it working ?
> I saw a posting in the archive which said it is not really
> working. Is this true ?
>
> Is there any other way of converting an existing database schema
> (postgresql) into an xml schema so I can use torque.
>
> Many thanks
>
> Huy
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
newbie sql2xml ant task question
Posted by Huy Do <hu...@tramada.com>.
Hi all,
Just trying to use the sql2xml ant task. Is it working ?
I saw a posting in the archive which said it is not really
working. Is this true ?
Is there any other way of converting an existing database schema
(postgresql) into an xml schema so I can use torque.
Many thanks
Huy
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org