Hi Unicell-'<div><br></div><div>But still I get the same error.</div><div><br></div><div>When I issue the glance command, the following warning is issued.</div><div><br></div><div>"WARNING! This tool is deprecated in favor of python-glanceclient..."</div>
<div><br></div><div>Can any one help me on how to resolve the issue.</div><div><br></div><div>-</div><div>TNS</div><div><br><div class="gmail_quote">On Thu, Aug 30, 2012 at 8:47 PM, unicell <span dir="ltr"><<a href="mailto:unicell@gmail.com" target="_blank">unicell@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Trinath,<div><br></div><div>For the first db_sync issue you mentioned, it seems to be caused by Folsom version of glance-manage db_sync, which is caused "glance-manage db_sync" followed by "glance version_control 0". And I can duplicate it at my side.</div>
<div><br></div><div>Brian is working on another issue ( <a href="https://bugs.launchpad.net/glance/+bug/1042925" target="_blank">https://bugs.launchpad.net/glance/+bug/1042925</a> ), the proposed solution might be helpful for this issue, I think.</div>
<div><br></div><div>For now, as a workaround, you can simply run "glance-manage db_sync", and no need for "glance-manage version_control 0". "glance-manage db_sync" command alone is enough to create the database model.</div>
<div><br></div><div>For the second issue you mentioned, "glance index" is deprecated in Folsom. You can now refer to "glance image-list" and "glance --help" for more information.</div><div><br>
</div><div>Best Regards,<br clear="all">--<br>Qiu Yu<br><a href="http://www.unicell.info" target="_blank">http://www.unicell.info</a><div><div class="h5"><br>
<br><br><div class="gmail_quote">On Thu, Aug 30, 2012 at 5:42 PM, Trinath Somanchi <span dir="ltr"><<a href="mailto:trinath.somanchi@gmail.com" target="_blank">trinath.somanchi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi-<div><br></div><div>This issue is resolved, reset the mysql passcode for glance.</div><div><br></div><div>But struck with another issue, 'glance index' command.</div><div><br></div><div>I have issued 'glance index' command to check the accuracy of my glance installations.</div>
<div><br></div><div>But I got the following error</div><div><br></div><div><div>/opt/stack/glance/glance/openstack/common/version.py:22: UserWarning: Module glance was already imported from /opt/stack/glance/glance/__init__.pyc, but /usr/local/lib/python2.7/dist-packages/glance-2012.2-py2.7.egg is being added to sys.path</div>
<div> import pkg_resources</div><div>WARNING! This tool is deprecated in favor of python-glanceclient (see <a href="http://github.com/openstack/python-glanceclient" target="_blank">http://github.com/openstack/python-glanceclient</a>).</div>
<div>Failed to show index. Got error:</div><div>[Errno 111] Connection refused</div><div><br></div><div><br></div><div>Can any one help me on solving this issue.</div><div><br></div><div>-</div><div>TNS</div><div><div>
<div><br></div>
<div><br></div><div><br></div><br><div class="gmail_quote">On Wed, Aug 29, 2012 at 10:25 PM, Trinath Somanchi <span dir="ltr"><<a href="mailto:trinath.somanchi@gmail.com" target="_blank">trinath.somanchi@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi-<div>here are my steps:</div><div><br></div><div>[1] I have just downloaded the tar.gz file of glance</div><div>[2] untar and run the following commands, python setup.py build , python setup.py install</div>
<div>[3] create the galnce db in mysql manually.</div>
<div>[4] previously done with keystone work as specified in the ESSESX release, since I dont have folsom-3 specific document to go with,</div><div>[5] updated glance-registry.conf, glance-api-paste.ini, glance-registry-api.ini (some difference in file name, as I did not remember them) with SQL information.</div>
<div>[6] run command ' glance-manage versiont_control 0'</div><div>[7] run command 'glance-manage db_sync'</div><div><br></div><div>This is the complete set of order of steps I have used, and at the end of the 7th step, I got the below error.</div>
<div><br></div><div>Can you please guide me on troubleshooting the issue.</div><div><br></div><div>Thanking you the reply.</div><div><br></div><div>-</div><div>TNS.<div><div><br><br><div class="gmail_quote">On Wed, Aug 29, 2012 at 8:12 PM, Brian Waldon <span dir="ltr"><<a href="mailto:bcwaldon@gmail.com" target="_blank">bcwaldon@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can you share the sequence of commands you used during the install process?<br>
<div><div><br>
<br>
On Aug 29, 2012, at 3:18 AM, Trinath Somanchi wrote:<br>
<br>
> Hi-<br>
><br>
> I have installed Openstack Folsom-3 Glance for my testing and found this error while db sync.<br>
><br>
> /usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py:8: UserWarning: Module glance was already imported from /opt/stack/glance/glance/__init__.pyc, but /usr/local/lib/python2.7/dist-packages/glance-2012.2-py2.7.egg is being added to sys.path<br>
> import pkg_resources<br>
> Traceback (most recent call last):<br>
> File "./bin/glance-manage", line 131, in <module><br>
> main()<br>
> File "./bin/glance-manage", line 127, in main<br>
> dispatch_cmd(args)<br>
> File "./bin/glance-manage", line 103, in dispatch_cmd<br>
> cmd_func(args)<br>
> File "./bin/glance-manage", line 91, in do_db_sync<br>
> glance.db.sqlalchemy.migration.db_sync(version, current_version)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 124, in db_sync<br>
> upgrade(version=version)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 67, in upgrade<br>
> return versioning_api.upgrade(sql_connection, repo_path, version)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade<br>
> return _migrate(url, repository, version, upgrade=True, err=err, **opts)<br>
> File "<string>", line 2, in _migrate<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine<br>
> return f(*a, **kw)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate<br>
> schema.runchange(ver, change, changeset.step)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange<br>
> change.run(self.engine, step)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run<br>
> script_func(engine)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/001_add_images_table.py", line 49, in upgrade<br>
> create_tables(tables)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/schema.py", line 96, in create_tables<br>
> table.create()<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 594, in create<br>
> checkfirst=checkfirst)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2303, in _run_visitor<br>
> conn._run_visitor(visitorcallable, element, **kwargs)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1973, in _run_visitor<br>
> **kwargs).traverse_single(element)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single<br>
> return meth(obj, **kw)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line 86, in visit_table<br>
> self.connection.execute(schema.CreateTable(table))<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute<br>
> params)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl<br>
> compiled<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context<br>
> context)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context<br>
> context)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute<br>
> cursor.execute(statement, parameters)<br>
> sqlalchemy.exc.OperationalError: (OperationalError) table images already exists u'\nCREATE TABLE images (\n\tid INTEGER NOT NULL, \n\tname VARCHAR(255), \n\ttype VARCHAR(30), \n\tsize INTEGER, \n\tstatus VARCHAR(30) NOT NULL, \n\tis_public BOOLEAN NOT NULL, \n\tlocation TEXT, \n\tcreated_at DATETIME NOT NULL, \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tdeleted BOOLEAN NOT NULL, \n\tPRIMARY KEY (id), \n\tCHECK (is_public IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)\n\n' ()<br>
><br>
> Can any one help me on troubleshooting the same.<br>
><br>
><br>
><br>
><br>
> --<br>
> Regards,<br>
> ----------------------------------------------<br>
> Trinath Somanchi,<br>
> <a href="tel:%2B91%209866%20235%20130" value="+919866235130" target="_blank">+91 9866 235 130</a><br>
><br>
</div></div>> _______________________________________________<br>
> Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
> Post to : <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
> Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
> More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>Trinath Somanchi,<div><a href="tel:%2B91%209866%20235%20130" value="+919866235130" target="_blank">+91 9866 235 130</a></div>
<br>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>Trinath Somanchi,<div><a href="tel:%2B91%209866%20235%20130" value="+919866235130" target="_blank">+91 9866 235 130</a></div>
<br>
</div></div></div>
<br>_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to : <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>Trinath Somanchi,<div>+91 9866 235 130</div><br>
</div>