[appfuse-issues] [JIRA] Resolved: (APF-381) Make MySQL database SQL creation script aware of build.properties

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[appfuse-issues] [JIRA] Resolved: (APF-381) Make MySQL database SQL creation script aware of build.properties

AppFuse - Issues mailing list
     [ http://issues.appfuse.org/browse/APF-381?page=all ]
     
Matt Raible resolved APF-381:
-----------------------------

    Resolution: Fixed

Fixed - thanks for the good idea.

https://appfuse.dev.java.net/source/browse/appfuse/build.xml?r1=1.128.2.3&r2=1.128.2.4
https://appfuse.dev.java.net/source/browse/appfuse/metadata/sql/mysql-create.sql?r1=1.5&r2=1.5.2.1

> Make MySQL database SQL creation script aware of build.properties
> -----------------------------------------------------------------
>
>          Key: APF-381
>          URL: http://issues.appfuse.org/browse/APF-381
>      Project: AppFuse
>         Type: Bug

>   Components: Build, Test, or Deploy Process
>     Versions: 1.9.2
>  Environment: N/A
>     Reporter: Rafael Cordones Marcos
>     Assignee: Matt Raible
>     Priority: Minor
>      Fix For: 1.9.3
>  Attachments: mysql-create.sql
>
> The SQL file for MySQL db creation contains the following SQL statements which do not take into account the variables "database.username" and "database.password" defined in properties.xml:
> grant all privileges on @dbname@.* to test@"%" identified by "test";
> -------------------------------------------------------------^^^------------------------------^^^
> In order to fix this I have added two variables to the file mysql-create.sql:
> grant all privileges on @dbname@.* to @dbuser@@"%" identified by "@dbpassword@";
> And changed the Ant build script and added these two lines in the "db-create" target:
>                 <filter token="dbuser" value="${database.username}"/>
>                 <filter token="dbpassword" value="${database.password}"/>
> I attach the modified mysql-create.sql

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.appfuse.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]