Thanks... I have never used sqlalchemy so no knowledge on the connection string, now that I see it I could have come up with that myself though Works now Olaf On 3/9/10 9:09 AM, "Nate Coraor" <nate@bx.psu.edu> wrote: This is what happens when I go from memory. The DB engine URL documentation is here: http://www.sqlalchemy.org/docs/05/dbengine.html I had the '@' and ':' reversed. mysql://xxx:xxx@localhost/galaxy?unix_socket=/var/lib/mysql/mysql.sock Sorry for all the confusion. Stein, Olaf wrote:
Sorry, did not see the localhost in there Now using:
# instead. PostgreSQL and MySQL are supported. database_connection = mysql://xxx@xxx:localhost/galaxy?unix_socket=/var/lib/mysql/mysql.sock
Still get the the issue with the post however:
File "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/url.py", line 49, in __init__ self.port = int(port) ValueError: invalid literal for int(): localhost
On 3/9/10 8:46 AM, "Nate Coraor" <nate@bx.psu.edu> wrote:
Ah, probably the :, I thought it was valid to leave out the hostname when connecting via a socket. Try:
mysql://xxx@xxx:localhost/galaxy?unix_socket=/var/lib/mysql/mysql.sock
Stein, Olaf wrote: > database_connection = > mysql://xxx@xxx:/galaxy?unix_socket=/var/lib/mysql/mysql.sock > > > > On 3/8/10 10:13 PM, "Kanwei Li" <kanwei@gmail.com> wrote: > > Hi Olaf, > > Could you paste the DB url you're using? Anonymizing the user/pass > of course. > > Thanks, > > Kanwei > > On Mon, Mar 8, 2010 at 4:08 PM, Stein, Olaf > <Olaf.Stein@nationwidechildrens.org> wrote: > > Thanks > > > > Now I get this: > > > > galaxy.model.migrate.check DEBUG 2010-03-08 14:04:00,428 > MySQL_python egg > > successfully loaded for mysql dialect > > Traceback (most recent call last): > > File > "/export/home/steino/galaxy-dist/lib/galaxy/web/buildapp.py", line > > 61, in app_factory > > app = UniverseApplication( global_conf = global_conf, **kwargs ) > > File "/export/home/steino/galaxy-dist/lib/galaxy/app.py", line > 28, in > > __init__ > > create_or_verify_database( db_url, > self.config.database_engine_options ) > > File > "/export/home/steino/galaxy-dist/lib/galaxy/model/migrate/check.py", > > line 50, in create_or_verify_database > > engine = create_engine( url, **engine_options ) > > File > > > "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/__init__.py", > > line 223, in create_engine > > return strategy.create(*args, **kwargs) > > File > > > "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/strategies.py", > > line 46, in create > > u = url.make_url(name_or_url) > > File > > > "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/url.py", > > line 137, in make_url > > return _parse_rfc1738_args(name_or_url) > > File > > > "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/url.py", > > line 173, in _parse_rfc1738_args > > return URL(name, **components) > > File > > > "/export/home/steino/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.4.egg/sqlalchemy/engine/url.py", > > line 49, in __init__ > > self.port = int(port) > > ValueError: invalid literal for int(): > > > > > > > > And my mysql port is standard 3306. > > > > Any ideas? > > > > Thanks > > Olaf > > > > > > On 3/8/10 1:51 PM, "Nate Coraor" <nate@bx.psu.edu> wrote: > > > > Stein, Olaf wrote: > > > Hi all, > > > > > > Very new to galaxy and trying to setup an instance here with mysql as > > > the backend database. > > > > > > I added this line: > > > mysql:///galaxy?unix_socket=/var/run/mysqld/mysqld.sock > > > > > > To the universe_wsgi.ini file > > > Where do I define the dbuser, password and database that I want > to use? > > > And what else do I need to do, for instance create the schema, etc? > > > > Hi Olaf, > > > > Galaxy will automatically create the tables/etc. upon startup. To set > > the user, password, and database, use a URL like this: > > > > mysql://user@pass:/dbname?unix_socket=/var/run/mysqld/mysqld.sock > > > > --nate > > > > > > > > Thanks > > > Olaf > > > > > > > > > > > > > > > > > > ------------------------- > > > Olaf Stein > > > DBA > > > Battelle Center for Mathematical Medicine > > > Nationwide Children's Hospital, The Research Institute > > > 700 Children's Drive > > > 43205 Columbus, OH > > > phone: 1-614-355-5685 > > > cell: 1-614-843-0432 > > > email: olaf.stein@nationwidechildrens.org > > > > > > > > > "I consider that the golden rule requires that if I like a program I > > > must share it with other people who like it." > > > Richard M. Stallman > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > _______________________________________________ > > > galaxy-user mailing list > > > galaxy-user@lists.bx.psu.edu > > > http://lists.bx.psu.edu/listinfo/galaxy-user > > > > > > > > > > > > > > > > ------------------------- > > Olaf Stein > > DBA > > Battelle Center for Mathematical Medicine > > Nationwide Children's Hospital, The Research Institute > > 700 Children's Drive > > 43205 Columbus, OH > > phone: 1-614-355-5685 > > cell: 1-614-843-0432 > > email: olaf.stein@nationwidechildrens.org > > > > > > "I consider that the golden rule requires that if I like a program > I must > > share it with other people who like it." > > Richard M. Stallman > > > > _______________________________________________ > > galaxy-user mailing list > > galaxy-user@lists.bx.psu.edu > > http://lists.bx.psu.edu/listinfo/galaxy-user > > > > > > > > > > > ------------------------- > Olaf Stein > DBA > Battelle Center for Mathematical Medicine > Nationwide Children's Hospital, The Research Institute > 700 Children's Drive > 43205 Columbus, OH > phone: 1-614-355-5685 > cell: 1-614-843-0432 > email: olaf.stein@nationwidechildrens.org > > > "I consider that the golden rule requires that if I like a program I > must share it with other people who like it." > Richard M. Stallman
------------------------- Olaf Stein DBA Battelle Center for Mathematical Medicine Nationwide Children's Hospital, The Research Institute 700 Children's Drive 43205 Columbus, OH phone: 1-614-355-5685 cell: 1-614-843-0432 email: olaf.stein@nationwidechildrens.org
"I consider that the golden rule requires that if I like a program I must share it with other people who like it." Richard M. Stallman
------------------------- Olaf Stein DBA Battelle Center for Mathematical Medicine Nationwide Children's Hospital, The Research Institute 700 Children's Drive 43205 Columbus, OH phone: 1-614-355-5685 cell: 1-614-843-0432 email: olaf.stein@nationwidechildrens.org "I consider that the golden rule requires that if I like a program I must share it with other people who like it." Richard M. Stallman