[openstack-dev] [Neutron] Help with database migration error
Henry Gessau
gessau at cisco.com
Thu Jul 4 02:27:24 UTC 2013
Matt, thanks for looking. I should have followed up with a note that I did
find what the problem was.
The Cisco plugin is a special case -- it is a wrapper that loads
sub-plugins. The database connection is specified in config file of the
first sub-plugin. By specifying that instead of cisco_plugins.ini everything
works.
-- Henry
On Wed, Jul 03, at 10:10 pm, Matt Riedemann <mriedem at us.ibm.com> wrote:
> What is the sql_connection value in your cisco_plugins.ini file? Looks like
> sqlalchemy is having issues parsing the URL.
>
>
>
> Thanks,
>
> *MATT RIEDEMANN*
> Advisory Software Engineer
> Cloud Solutions and OpenStack Development
> ----------------------------------------------------------------------------
> *Phone:*1-507-253-7622| *Mobile:*1-507-990-1889*
> E-mail:*_mriedem at us.ibm.com_ <mailto:mriedem at us.ibm.com>
> IBM
>
> 3605 Hwy 52 N
> Rochester, MN 55901-1407
> United States
>
>
>
>
>
>
> From: Henry Gessau <gessau at cisco.com>
> To: OpenStack Development Mailing List
> <openstack-dev at lists.openstack.org>,
> Date: 07/02/2013 09:05 PM
> Subject: [openstack-dev] [Neutron] Help with database migration error
> ----------------------------------------------------------------------------
>
>
>
> I have not worked with databases much and this is my first attempt
> at a database migration. I am trying to follow this Howto:
> https://wiki.openstack.org/wiki/Neutron/DatabaseMigration
>
> I get the following error at step 3:
>
> /opt/stack/quantum[master] $ quantum-db-manage --config-file
> /etc/quantum/quantum.conf --config-file
> /etc/quantum/plugins/cisco/cisco_plugins.ini stamp head
> Traceback (most recent call last):
> File "/usr/local/bin/quantum-db-manage", line 9, in <module>
> load_entry_point('quantum==2013.2.a882.g0fc6605', 'console_scripts',
> 'quantum-db-manage')()
> File "/opt/stack/quantum/quantum/db/migration/cli.py", line 136, in main
> CONF.command.func(config, CONF.command.name)
> File "/opt/stack/quantum/quantum/db/migration/cli.py", line 81, in do_stamp
> sql=CONF.command.sql)
> File "/opt/stack/quantum/quantum/db/migration/cli.py", line 54, in
> do_alembic_command
> getattr(alembic_command, cmd)(config, *args, **kwargs)
> File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 221,
> in stamp
> script.run_env()
> File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 193,
> in run_env
> util.load_python_file(self.dir, 'env.py')
> File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 177, in
> load_python_file
> module = imp.load_source(module_id, path, open(path, 'rb'))
> File "/opt/stack/quantum/quantum/db/migration/alembic_migrations/env.py",
> line 100, in <module>
> run_migrations_online()
> File "/opt/stack/quantum/quantum/db/migration/alembic_migrations/env.py",
> line 73, in run_migrations_online
> poolclass=pool.NullPool)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/__init__.py", line
> 338, in create_engine
> return strategy.create(*args, **kwargs)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py",
> line 48, in create
> u = url.make_url(name_or_url)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/url.py", line 178,
> in make_url
> return _parse_rfc1738_args(name_or_url)
> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/url.py", line 219,
> in _parse_rfc1738_args
> "Could not parse rfc1738 URL from string '%s'" % name)
> sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string ''
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
More information about the OpenStack-dev
mailing list