help: can't connect to external mysql atabase
![](https://secure.gravatar.com/avatar/ec677c7a258b1407e7d98fd3ee3ce937.jpg?s=120&d=mm&r=g)
Hi; the mysql databse is installed inside drupal in local server. the mysql path location is /opt/drupal-6.16-0/mysql/bin/mysql. when I tried to connect Galaxy to mysql database by modifying database_connection in file universe_wsgi.ini as following database_connection = /opt/drupal-6.16-0/mysql/bin/mysql://tiger:godatabase@localhost/mydatabase I fialed to do it. and ArgumentError: could not parse rfc1738URL from string '/opt/drupal-6.16-0/mysql/bin/mysql://tiger:godatabase@localhost/mydatabase' someone can help me? thanks. _________________________________________________________________ The New Busy is not the old busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:W...
![](https://secure.gravatar.com/avatar/7c41ba4ddfe89f9fd664fa9ceee9404c.jpg?s=120&d=mm&r=g)
Hello, The problem is that the connection string is a URL, it shouldn't have the path to the mysql binary in it (should just be "mysql://tiger:goDB@localhost/mydatabase") Also, Galaxy and drupal are different and unrelated pieces of software, and Galaxy should have its own dedicated database. Galaxy should work with mysql, but we highly recommend postgres. On Jun 9, 2010, at 6:55 PM, wenqing zhang wrote:
Hi;
the mysql databse is installed inside drupal in local server. the mysql path location is /opt/drupal-6.16-0/mysql/bin/mysql.
when I tried to connect Galaxy to mysql database by modifying database_connection in file universe_wsgi.ini as following database_connection = /opt/drupal-6.16-0/mysql/bin/mysql://tiger:godatabase@localhost/mydatabase I fialed to do it. and ArgumentError: could not parse rfc1738URL from string '/opt/drupal-6.16-0/mysql/bin/mysql://tiger:godatabase@localhost/mydatabase'
someone can help me?
thanks.
The New Busy is not the old busy. Search, chat and e-mail from your inbox. Get started. _______________________________________________ galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev
Greg Von Kuster Galaxy Development Team greg@bx.psu.edu
participants (2)
-
Greg Von Kuster
-
wenqing zhang