You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "Xavier Dutreilh (JIRA)" <ji...@apache.org> on 2010/06/09 11:57:13 UTC
[jira] Created: (OLIO-147) Cannot import the default 'geolocations'
data into the database
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
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.
[jira] Resolved: (OLIO-147) Cannot import the default
'geolocations' data into the database
Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OLIO-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shanti Subramanyam resolved OLIO-147.
-------------------------------------
Fix Version/s: 0.3
(was: 0.2)
Resolution: Fixed
Fixed as described in JIRA and patch.
> 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
> Priority: Trivial
> Fix For: 0.3
>
> 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.
[jira] Updated: (OLIO-147) Cannot import the default 'geolocations'
data into the database
Posted by "Xavier Dutreilh (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OLIO-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xavier Dutreilh updated OLIO-147:
---------------------------------
Priority: Trivial (was: Major)
> 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
> Priority: Trivial
> 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.
[jira] Updated: (OLIO-147) Cannot import the default 'geolocations'
data into the database
Posted by "Xavier Dutreilh (JIRA)" <ji...@apache.org>.
[ 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.