[
https://issues.apache.org/jira/browse/OLIO-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xavier Dutreilh updated OLIO-147:
---------------------------------
Attachment: olio-06-09-2010.patch
The attached patch is a proposal to fix this issue by adding the -p parameter
to the mysql command. Might not be the best thing if security matters
(passwords specified this way are viewable by all system users when running 'ps
aux').
A good alternative would be to use the Ruby library for MySQL.
> Cannot import the default 'geolocations' data into the database
> ---------------------------------------------------------------
>
> Key: OLIO-147
> URL: https://issues.apache.org/jira/browse/OLIO-147
> Project: Olio
> Issue Type: Bug
> Components: rails-app
> Affects Versions: 0.2
> Reporter: Xavier Dutreilh
> Assignee: Shanti Subramanyam
> Fix For: 0.2
>
> Attachments: olio-06-09-2010.patch
>
>
> 024_populate_geolocations.rb executes an external command (mysql) to populate
> the content of the 'geolocations' table. Depending of the system user
> environment, this command might succeed or not since it only provides the
> MySQL username and the database to connect to. But no password is provided.
> As a result, if security rules of the MySQL server require the use of a
> password, the authentication will fail.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.