Hi,
I've attached a patch.
- It adds a line to README to grant privileges to "test" database for
user "mifos".
- It changes the default user to "mifos" in build.properties,
hibernate.properties, HibernateTest.properties
I also think the "test" database name is too generic and likely to
clash with some existing one. Maybe called it testmifos or mifostest?
Pramod
On Nov 21, 2007 11:45 PM, Tom Bostelmann <[EMAIL PROTECTED]> wrote:
> Yes, please do! This is good information since it's best not to use the
> 'root' user for application-specific connection management :)
>
> You can submit a patch to the list and I'll try to take care of it quickly.
>
>
>
> On Nov 21, 2007 3:25 AM, Pramod Biligiri <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Hi,
> > The README file is pretty accurate. But I noticed that it instructs
> > the user to grant privileges for the database user on only the "mifos"
> > database. Since the "test" database is also used as part of the
> > default "dist" target which is later invoked in the README, I get this
> > error:
> >
> > build.xml:464: java.sql.SQLException: Access denied for user
> > 'mifos'@'%' to database "test".
> >
> > Of course this happens only if you change the database user from
> > "root" to something else. But it's still a minor problem.
> > Can I go ahead and change the README to say grant privileges to "test"
> > database also?
> >
> > Pramod Biligiri
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2005.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>
Index: /home/pramod/workspace/mifos/conf/build.properties
===================================================================
--- /home/pramod/workspace/mifos/conf/build.properties (revision 12203)
+++ /home/pramod/workspace/mifos/conf/build.properties (working copy)
@@ -42,8 +42,8 @@
db.name=mifos
db.ip=localhost
db.port=3306
-db.user=root
-db.pwd=mysql
+db.user=mifos
+db.pwd=mifos
######################################################################
#test db related properties, used by the target build_test_db
@@ -48,8 +48,8 @@
######################################################################
#test db related properties, used by the target build_test_db
######################################################################
-testdb.name=test
+testdb.name=testmifos
testdb.ip=localhost
testdb.port=3306
-testdb.user=root
-testdb.pwd=mysql
\ No newline at end of file
+testdb.user=mifos
+testdb.pwd=mifos
\ No newline at end of file
Index: /home/pramod/workspace/mifos/conf/hibernate.properties
===================================================================
--- /home/pramod/workspace/mifos/conf/hibernate.properties (revision 12203)
+++ /home/pramod/workspace/mifos/conf/hibernate.properties (working copy)
@@ -1,7 +1,7 @@
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8
-hibernate.connection.username=root
-hibernate.connection.password=mysql
+hibernate.connection.username=mifos
+hibernate.connection.password=mifos
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
Index: /home/pramod/workspace/mifos/conf/HibernateTest.properties
===================================================================
--- /home/pramod/workspace/mifos/conf/HibernateTest.properties (revision 12203)
+++ /home/pramod/workspace/mifos/conf/HibernateTest.properties (working copy)
@@ -1,7 +1,7 @@
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost:3306/test
-hibernate.connection.username=root
-hibernate.connection.password=mysql
+hibernate.connection.username=mifos
+hibernate.connection.password=mifos
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory
Index: /home/pramod/workspace/mifos/README
===================================================================
--- /home/pramod/workspace/mifos/README (revision 12203)
+++ /home/pramod/workspace/mifos/README (working copy)
@@ -146,6 +146,7 @@
drop database if exists mifos
create database mifos
grant all privileges on mifos.* to mifos identified by 'mifos'
+ grant all privileges on testmifos.* to mifos identified by 'mifos'
Then reinvoke the ant build_db target.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
