Open Stack

Hi,

This seems to be this recently opened issue:
   https://bugzilla.redhat.com/show_bug.cgi?id=854984

         cheers, Jan


On 09/07/2012 03:03 PM, Salman Toor wrote:
> Hi,
>
> I have recently started with the Openstack deployment. I have
> successfully deployed Identity service. but get struck with the glance.
>
> I am working with Essex.
>
> Following guide I am using.
>
> OpenStack Install and Deploy Guide -Compute, Image and Identity services
> plus Dashboard for Red Hat Enterprise Linux, CentOS 6.x, or Fedora 17
>
>
> The problem is when I try to run
>
> -bash-4.1$ sudo glance-manage db_sync
>
> /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.3-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:639:
> SADeprecationWarning: The 'listeners' argument to Pool (and
> create_engine()) is deprecated. Use event.listen().
> Pool.__init__(self, creator, **kw)
> /usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.3-py2.6-linux-x86_64.egg/sqlalchemy/pool.py:145:
> SADeprecationWarning: Pool.add_listener is deprecated. Use event.listen()
> self.add_listener(l)
>
> Am I using some wrong version? why it said deprecated?
>
>
> -bash-4.1$ glance --version
> glance 2012.1.1
>
>
> I can access correct db_version
>
> -bash-4.1$ sudo glance-manage db_version
> 13
>
> glance api service start without any problem.
>
> Configuration file looks ok to me.
>
> ################ /etc/glance/glance-registry.conf ################
>
> [DEFAULT]
> # Show more verbose log output (sets INFO log level output)
> verbose = True
>
> # Show debugging output in logs (sets DEBUG log level output)
> debug = True
>
> # Address to bind the registry server
> bind_host = 0.0.0.0
>
> # Port the bind the registry server to
> bind_port = 9191
>
> # Log to this file. Make sure you do not set the same log
> # file for both the API and registry servers!
> log_file = /var/log/glance/registry.log
>
> # Backlog requests when creating socket
> backlog = 4096
>
> # SQLAlchemy connection string for the reference implementation
> # registry server. Any valid SQLAlchemy connection string is fine.
> # See:
> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/connections.html#sqlalchemy.create_engine
>
>
> ################# Modified By Salman Toor ###########################
> #sql_connection = mysql://glance:glance@localhost/glance
> sql_connection = mysql://glance1:glance1@188.184.20.197/glance
> #####################################################################
> # Whether the glance service creates the database tables
> # automatically at startup, or explicitly with db_sync
> db_auto_create = False
>
> # Period in seconds after which SQLAlchemy should reestablish its
> connection
> # to the database.
> #
> # MySQL uses a default `wait_timeout` of 8 hours, after which it will drop
> # idle connections. This can result in 'MySQL Gone Away' exceptions. If you
> # notice this, you can lower this value to ensure that SQLAlchemy
> reconnects
> # before MySQL can drop the connection.
> sql_idle_timeout = 3600
>
> # Limit the api to return `param_limit_max` items in a call to a
> container. If
> # a larger `limit` query param is provided, it will be reduced to this
> value.
> api_limit_max = 1000
>
> # If a `limit` query param is not provided in an api request, it will
> # default to `limit_param_default`
> limit_param_default = 25
>
> # Role used to identify an authenticated user as administrator
> #admin_role = admin
>
> # ================= Syslog Options ============================
>
> # Send logs to syslog (/dev/log) instead of to file specified
> # by `log_file`
> use_syslog = False
>
> # Facility to use. If unset defaults to LOG_USER.
> # syslog_log_facility = LOG_LOCAL1
>
> # ================= SSL Options ===============================
>
> # Certificate file to use when starting registry server securely
> # cert_file = /path/to/certfile
>
> # Private key file to use when starting registry server securely
> # key_file = /path/to/keyfile
> #
> # ############## Added By Salman Toor ##########################
> [paste_deploy]
> flavor = keystone
> ###############################################################
>
> last block from registry.log which might be interesting
>
> ############ registry.log ######################
>
> 2012-09-07 14:52:03 29891 DEBUG [sqlalchemy.engine.base.Engine] Row
> ('migrate_version', 'CREATE TABLE `migrate_version` (\n `repository_id`
> varchar(250) NOT NULL,\n `repository_path` text,\n `version` int(11)
> DEFAULT NULL,\n PRIMARY KEY (`repository_id`)\n) ENGINE=MyISAM DEFAULT
> CHARSET=latin1')
> 2012-09-07 14:52:03 29891 INFO [sqlalchemy.engine.base.Engine] SELECT
> migrate_version.repository_id, migrate_version.repository_path,
> migrate_version.version
> FROM migrate_version
> WHERE migrate_version.repository_id = %s
> 2012-09-07 14:52:03 29891 INFO [sqlalchemy.engine.base.Engine] ('Glance
> Migrations',)
> 2012-09-07 14:52:03 29891 DEBUG [sqlalchemy.engine.base.Engine] Col
> ('repository_id', 'repository_path', 'version')
> 2012-09-07 14:52:03 29891 DEBUG [sqlalchemy.engine.base.Engine] Row
> ('Glance Migrations',
> '/usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo', 13L)
> 2012-09-07 14:52:03 29891 DEBUG [migrate.versioning.util] Disposing
> SQLAlchemy engine Engine(mysql://glance1:glance1@188.184.20.197/glance)
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.util] Constructing
> engine
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.repository] Loading
> repository
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo...
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/001_add_images_table.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/001_add_images_table.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/002_add_image_properties_table.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/002_add_image_properties_table.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_add_disk_format.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_add_disk_format.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_sqlite_downgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_sqlite_downgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_sqlite_upgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/003_sqlite_upgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/004_add_checksum.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/004_add_checksum.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/005_size_big_integer.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/005_size_big_integer.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_key_to_name.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_key_to_name.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_mysql_downgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_mysql_downgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_sqlite_upgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_sqlite_upgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_sqlite_downgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_sqlite_downgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_mysql_upgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/006_mysql_upgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/007_add_owner.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/007_add_owner.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/008_add_image_members_table.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/008_add_image_members_table.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/009_add_mindisk_and_minram.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/009_add_mindisk_and_minram.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/010_default_update_at.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/010_default_update_at.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/011_make_mindisk_and_minram_notnull.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/011_make_mindisk_and_minram_notnull.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/012_id_to_uuid.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/012_id_to_uuid.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/013_add_protected.py...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/013_add_protected.py
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Loading
> script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/013_sqlite_downgrade.sql...
>
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.script.base] Script
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo/versions/013_sqlite_downgrade.sql
> loaded successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.repository]
> Repository
> /usr/lib/python2.6/site-packages/glance/registry/db/migrate_repo loaded
> successfully
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.repository] Config:
> {'db_settings': {'__name__': 'db_settings', 'required_dbs': '[]',
> 'version_table': 'migrate_version', 'repository_id': 'Glance Migrations'}}
> 2012-09-07 14:52:56 29904 DEBUG [migrate.versioning.util] Disposing
> SQLAlchemy engine Engine(mysql://glance1:glance1@188.184.20.197/glance)
>
> ########################################
>
>
> Can someone give me some hints.
>
> Regards..
> Salman.
>
>
>
>
>
> _______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators