[
https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dagmar updated RAVE-874:
------------------------
Description:
When using a MySQL database on a linux OS it is not possible to load the
initial data due the OS being case-sensitive.
The executeScriptQuery parameter of
org.apache.rave.jdbc.util.DataSourcePopulator is "SELECT * FROM WIDGET" but the
table is actually named "widget". (see line 31 in Spring configuration file
named dataContext.xml)
There are no error logs because it seems the exception where the table is not
found is swallowed (see line 166 in DataSourcePopulator).
To reproduce:
1. Create a database in MySQL and create a user and grant ALL permissions to
the user on the database
2. Follow instructions on the following page to setup your mysql database
(using the details of the database created above):
http://rave.apache.org/documentation/configure-database.html
3. Rebuild and restart your server
4. Load the Apache Rave login page
Expected result
1. You can login with the canonical user
2. Tables have been created in the database and you will see data returned if
you execute "select * from person"
Actual result
1. You cannot login with the canonical user
2. Tables have been created but they are empty
was:
When using a MySQL database on a linux OS it is not possible to load the
initial data due the OS being case-sensitive.
The executeScriptQuery parameter of
org.apache.rave.jdbc.util.DataSourcePopulator is "SELECT * FROM WIDGET" but the
table is actually named "widget".
There are no error logs because it seems the exception where the table is not
found is swallowed (see line 166 in DataSourcePopulator).
To reproduce:
1. Create a database in MySQL and create a user and grant ALL permissions to
the user on the database
2. Follow instructions on the following page to setup your mysql database
(using the details of the database created above):
http://rave.apache.org/documentation/configure-database.html
3. Rebuild and restart your server
4. Load the Apache Rave login page
Expected result
1. You can login with the canonical user
2. Tables have been created in the database and you will see data returned if
you execute "select * from person"
Actual result
1. You cannot login with the canonical user
2. Tables have been created but they are empty
> Unable to load initial data on a MySQL database when using linux
> ----------------------------------------------------------------
>
> Key: RAVE-874
> URL: https://issues.apache.org/jira/browse/RAVE-874
> Project: Rave
> Issue Type: Bug
> Components: rave-portal
> Environment: MySQL Community Server 5.5.28
> Fedora 17
> Reporter: Dagmar
>
> When using a MySQL database on a linux OS it is not possible to load the
> initial data due the OS being case-sensitive.
> The executeScriptQuery parameter of
> org.apache.rave.jdbc.util.DataSourcePopulator is "SELECT * FROM WIDGET" but
> the table is actually named "widget". (see line 31 in Spring configuration
> file named dataContext.xml)
> There are no error logs because it seems the exception where the table is not
> found is swallowed (see line 166 in DataSourcePopulator).
> To reproduce:
> 1. Create a database in MySQL and create a user and grant ALL permissions to
> the user on the database
> 2. Follow instructions on the following page to setup your mysql database
> (using the details of the database created above):
> http://rave.apache.org/documentation/configure-database.html
> 3. Rebuild and restart your server
> 4. Load the Apache Rave login page
> Expected result
> 1. You can login with the canonical user
> 2. Tables have been created in the database and you will see data returned
> if you execute "select * from person"
> Actual result
> 1. You cannot login with the canonical user
> 2. Tables have been created but they are empty
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
