database_connection = mysql://xxx@xxx/galaxy?unix_socket=/var/lib/mysql/mysql.sock The "galaxy" after the uname and pw is the host or dbname? I am asking because I get this: OperationalError: (OperationalError) (2005, "Unknown MySQL server host 'galaxy' (1)") None None 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