can not get Glance RESTful to work.

Asked by steve chu on 2011-04-25

I installed Glance to Fedora and I am be able to upload images by CLI add command.
The CLI interface works fine but the RESTful interface does not.
I am expecting to view image meta data by typing http://my-glance-api-server-ip/images/ in a browser window. I am getting connection timeout error.
It seems neither port 9292 nor 9191 are opened up.

I can ping the IP but I cannot connect to port by command "telnet my-glance-api-server-ip 9292".

Running netstat -a on the host does not show these two ports (9191 or 9292) either.

Please help!

Question information

Language:
English Edit question
Status:
Solved
For:
Glance Edit question
Assignee:
No assignee Edit question
Solved by:
steve chu
Solved:
2011-04-28
Last query:
2011-04-28
Last reply:
2011-04-27

This question was reopened

Jay Pipes (jaypipes) said : #1

Hi again, Steve :) Please do enable logging and post output from the API log and registry log. We'll go from there.

Cheers!
jay

steve chu (steve-chu) said : #2

This is API log
2011-04-26 06:07:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:04 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:07:04 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:07:04 DEBUG [glance-api] ================================================
2011-04-26 06:07:04 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:07:04 DEBUG [glance-api] bind_port 9292
2011-04-26 06:07:04 DEBUG [glance-api] debug True
2011-04-26 06:07:04 DEBUG [glance-api] default_store file
2011-04-26 06:07:04 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:07:04 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:07:04 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:07:04 DEBUG [glance-api] registry_port 9191
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:07:04 DEBUG [glance-api] verbose True
2011-04-26 06:07:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:07:04 DEBUG [eventlet.wsgi.server] (1990) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:07:06 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:06] "GET /images HTTP/1.1" 200 130 0.014728
2011-04-26 06:07:13 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:13 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:13 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:13 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:13] "GET /images HTTP/1.1" 200 130 0.006719
2011-04-26 06:07:26 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:26] "GET /images HTTP/1.1" 200 130 0.005924
2011-04-26 06:07:57 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:57 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:07:57 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:07:57 DEBUG [glance-api] ================================================
2011-04-26 06:07:57 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:07:57 DEBUG [glance-api] bind_port 9292
2011-04-26 06:07:57 DEBUG [glance-api] debug True
2011-04-26 06:07:57 DEBUG [glance-api] default_store file
2011-04-26 06:07:57 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:07:57 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:07:57 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:07:57 DEBUG [glance-api] registry_port 9191
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:07:57 DEBUG [glance-api] verbose True
2011-04-26 06:07:57 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:57 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:07:57 DEBUG [eventlet.wsgi.server] (2009) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:07:59 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:59 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:07:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:07:59 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:59] "GET /images HTTP/1.1" 200 130 0.015041
2011-04-26 06:08:03 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:03 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:03 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:03 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:03] "GET /images HTTP/1.1" 200 130 0.006097
2011-04-26 06:08:04 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:04 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:04 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:04 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:04] "GET /images HTTP/1.1" 200 130 0.005635
2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.005909
2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.005753
2011-04-26 06:08:06 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:06] "GET /images HTTP/1.1" 200 130 0.005627
2011-04-26 06:08:07 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:07 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:07 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:07 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:07] "GET /images HTTP/1.1" 200 130 0.007509
2011-04-26 06:08:22 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:22] "GET /images HTTP/1.1" 200 130 0.005685
2011-04-26 06:08:25 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:25 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:25 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:25 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:25] "GET /images HTTP/1.1" 200 130 0.006088
2011-04-26 06:08:26 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:26] "GET /images HTTP/1.1" 200 130 0.006111
2011-04-26 06:08:27 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:27 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:27 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:27 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:27] "GET /images HTTP/1.1" 200 130 0.005660
2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.005708
2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.006275
2011-04-26 06:09:00 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:09:00 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:09:00 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:09:00 DEBUG [glance-api] ================================================
2011-04-26 06:09:00 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:09:00 DEBUG [glance-api] bind_port 9292
2011-04-26 06:09:00 DEBUG [glance-api] debug True
2011-04-26 06:09:00 DEBUG [glance-api] default_store file
2011-04-26 06:09:00 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:09:00 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:09:00 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:09:00 DEBUG [glance-api] registry_port 9191
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:09:00 DEBUG [glance-api] verbose True
2011-04-26 06:09:00 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:09:00 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:09:00 DEBUG [eventlet.wsgi.server] (2062) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:09:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:09:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:05] "GET /images HTTP/1.1" 200 130 0.014945
2011-04-26 06:09:22 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:09:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:22] "GET /images HTTP/1.1" 200 130 0.005967
2011-04-26 06:10:30 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:10:30 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:10:30 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:10:30 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:10:30] "GET /images HTTP/1.1" 200 130 0.006091
2011-04-26 06:19:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:19:04 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:19:04 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:19:04 DEBUG [glance-api] ================================================
2011-04-26 06:19:04 DEBUG [glance-api] bind_host 10.3.40.22
2011-04-26 06:19:04 DEBUG [glance-api] bind_port 9292
2011-04-26 06:19:04 DEBUG [glance-api] debug True
2011-04-26 06:19:04 DEBUG [glance-api] default_store file
2011-04-26 06:19:04 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:19:04 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:19:04 DEBUG [glance-api] registry_host 10.3.40.22
2011-04-26 06:19:04 DEBUG [glance-api] registry_port 9191
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:19:04 DEBUG [glance-api] verbose True
2011-04-26 06:19:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:19:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:19:04 DEBUG [eventlet.wsgi.server] (1728) wsgi starting up on http://10.3.40.22:9292/
2011-04-26 06:19:23 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:19:23 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:23 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:23 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:23] "GET /images HTTP/1.1" 200 274 0.016049
2011-04-26 06:19:55 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:19:55 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:55 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:55 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:55] "GET /images HTTP/1.1" 200 274 0.006598
2011-04-26 06:25:49 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:25:49 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:25:49 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:25:49 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:25:49] "GET /images HTTP/1.1" 200 274 0.007027

This is Registry log file
      1 2011-04-26 06:07:04 DEBUG [glance-registry] ********************************************************************************
      2 2011-04-26 06:07:04 DEBUG [glance-registry] Configuration options gathered from config file:
      3 2011-04-26 06:07:04 DEBUG [glance-registry] /usr/etc/glance.conf
      4 2011-04-26 06:07:04 DEBUG [glance-registry] ================================================
      5 2011-04-26 06:07:04 DEBUG [glance-registry] bind_host 0.0.0.0
      6 2011-04-26 06:07:04 DEBUG [glance-registry] bind_port 9191
      7 2011-04-26 06:07:04 DEBUG [glance-registry] debug True
      8 2011-04-26 06:07:04 DEBUG [glance-registry] log_file /var/log/glance/registry.log
      9 2011-04-26 06:07:04 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
     10 2011-04-26 06:07:04 DEBUG [glance-registry] sql_idle_timeout 3600
     11 2011-04-26 06:07:04 DEBUG [glance-registry] verbose True
     12 2011-04-26 06:07:04 DEBUG [glance-registry] ********************************************************************************
     13 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
     14 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     15 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
     16 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     17 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine]
     18 CREATE TABLE images (
     19 created_at DATETIME NOT NULL,
     20 updated_at DATETIME,
     21 deleted_at DATETIME,
     22 deleted BOOLEAN NOT NULL,
     23 id INTEGER NOT NULL,
     24 name VARCHAR(255),
     25 disk_format VARCHAR(20),
     26 container_format VARCHAR(20),
     27 size BIGINT,
     28 status VARCHAR(30) NOT NULL,
     29 is_public BOOLEAN NOT NULL,
     30 location TEXT,
     31 checksum VARCHAR(32),
     32 PRIMARY KEY (id),
     33 CHECK (deleted IN (0, 1)),
     34 CHECK (is_public IN (0, 1))
     35 )
     36
     37
     38 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     39 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     40 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine]
     41 CREATE TABLE image_properties (
     42 created_at DATETIME NOT NULL,
     43 updated_at DATETIME,
     44 deleted_at DATETIME,
     45 deleted BOOLEAN NOT NULL,
     46 id INTEGER NOT NULL,
     47 image_id INTEGER NOT NULL,
     48 name VARCHAR(255) NOT NULL,
     49 value TEXT,
     50 PRIMARY KEY (id),
     51 UNIQUE (image_id, name),
     52 CHECK (deleted IN (0, 1)),
     53 FOREIGN KEY(image_id) REFERENCES images (id)
     54 )
     55
     56
     57 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     58 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     59 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] CREATE INDEX ix_image_properties_name ON image_properties (name)
     60 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     61 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     62 2011-04-26 06:07:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
     63 2011-04-26 06:07:04 DEBUG [eventlet.wsgi.server] (1991) wsgi starting up on http://0.0.0.0:9191/
     64 2011-04-26 06:07:06 DEBUG [routes.middleware] Matched GET /images
     65 2011-04-26 06:07:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     66 2011-04-26 06:07:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     67 2011-04-26 06:07:06 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     68 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     69 WHERE images.deleted = ? AND images.is_public = ?
     70 2011-04-26 06:07:06 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     71 2011-04-26 06:07:06 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     72 2011-04-26 06:07:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:06] "GET /images HTTP/1.1" 200 130 0.010086
     73 2011-04-26 06:07:13 DEBUG [routes.middleware] Matched GET /images
     74 2011-04-26 06:07:13 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     75 2011-04-26 06:07:13 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     76 2011-04-26 06:07:13 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     77 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     78 WHERE images.deleted = ? AND images.is_public = ?
     79 2011-04-26 06:07:13 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     80 2011-04-26 06:07:13 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     81 2011-04-26 06:07:13 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:13] "GET /images HTTP/1.1" 200 130 0.004716
     82 2011-04-26 06:07:26 DEBUG [routes.middleware] Matched GET /images
     83 2011-04-26 06:07:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     84 2011-04-26 06:07:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     85 2011-04-26 06:07:26 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     86 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     87 WHERE images.deleted = ? AND images.is_public = ?
     88 2011-04-26 06:07:26 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     89 2011-04-26 06:07:26 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     90 2011-04-26 06:07:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:26] "GET /images HTTP/1.1" 200 130 0.004110
     91 2011-04-26 06:07:57 DEBUG [glance-registry] ********************************************************************************
     92 2011-04-26 06:07:57 DEBUG [glance-registry] Configuration options gathered from config file:
     93 2011-04-26 06:07:57 DEBUG [glance-registry] /usr/etc/glance.conf
     94 2011-04-26 06:07:57 DEBUG [glance-registry] ================================================
     95 2011-04-26 06:07:57 DEBUG [glance-registry] bind_host 0.0.0.0
     96 2011-04-26 06:07:57 DEBUG [glance-registry] bind_port 9191
     97 2011-04-26 06:07:57 DEBUG [glance-registry] debug True
     98 2011-04-26 06:07:57 DEBUG [glance-registry] log_file /var/log/glance/registry.log
     99 2011-04-26 06:07:57 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    100 2011-04-26 06:07:57 DEBUG [glance-registry] sql_idle_timeout 3600
    101 2011-04-26 06:07:57 DEBUG [glance-registry] verbose True
    102 2011-04-26 06:07:57 DEBUG [glance-registry] ********************************************************************************
    103 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    104 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    105 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    106 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    107 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine]
    108 CREATE TABLE images (
    109 created_at DATETIME NOT NULL,
    110 updated_at DATETIME,
    111 deleted_at DATETIME,
    112 deleted BOOLEAN NOT NULL,
    113 id INTEGER NOT NULL,
    114 name VARCHAR(255),
    115 disk_format VARCHAR(20),
    116 container_format VARCHAR(20),
    117 size BIGINT,
    118 status VARCHAR(30) NOT NULL,
    119 is_public BOOLEAN NOT NULL,
    120 location TEXT,
    121 checksum VARCHAR(32),
    122 PRIMARY KEY (id),
    123 CHECK (deleted IN (0, 1)),
    124 CHECK (is_public IN (0, 1))
    125 )
    126
    127
    128 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    129 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    130 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine]
    131 CREATE TABLE image_properties (
    132 created_at DATETIME NOT NULL,
    133 updated_at DATETIME,
    134 deleted_at DATETIME,
    135 deleted BOOLEAN NOT NULL,
    136 id INTEGER NOT NULL,
    137 image_id INTEGER NOT NULL,
    138 name VARCHAR(255) NOT NULL,
    139 value TEXT,
    140 PRIMARY KEY (id),
    141 UNIQUE (image_id, name),
    142 CHECK (deleted IN (0, 1)),
    143 FOREIGN KEY(image_id) REFERENCES images (id)
    144 )
    145
    146
    147 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    148 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    149 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] CREATE INDEX ix_image_properties_name ON image_properties (name)
    150 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    151 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    152 2011-04-26 06:07:57 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    153 2011-04-26 06:07:57 DEBUG [eventlet.wsgi.server] (2010) wsgi starting up on http://0.0.0.0:9191/
    154 2011-04-26 06:07:59 DEBUG [routes.middleware] Matched GET /images
    155 2011-04-26 06:07:59 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    156 2011-04-26 06:07:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    157 2011-04-26 06:07:59 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    158 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    159 WHERE images.deleted = ? AND images.is_public = ?
    160 2011-04-26 06:07:59 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    161 2011-04-26 06:07:59 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    162 2011-04-26 06:07:59 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:59] "GET /images HTTP/1.1" 200 130 0.010451
    163 2011-04-26 06:08:03 DEBUG [routes.middleware] Matched GET /images
    164 2011-04-26 06:08:03 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    165 2011-04-26 06:08:03 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    166 2011-04-26 06:08:03 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    167 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    168 WHERE images.deleted = ? AND images.is_public = ?
    169 2011-04-26 06:08:03 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    170 2011-04-26 06:08:03 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    171 2011-04-26 06:08:03 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:03] "GET /images HTTP/1.1" 200 130 0.004306
    172 2011-04-26 06:08:04 DEBUG [routes.middleware] Matched GET /images
    173 2011-04-26 06:08:04 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    174 2011-04-26 06:08:04 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    175 2011-04-26 06:08:04 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    176 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    177 WHERE images.deleted = ? AND images.is_public = ?
    178 2011-04-26 06:08:04 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    179 2011-04-26 06:08:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    180 2011-04-26 06:08:04 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:04] "GET /images HTTP/1.1" 200 130 0.004013
    181 2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
    182 2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    183 2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    184 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    185 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    186 WHERE images.deleted = ? AND images.is_public = ?
    187 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    188 2011-04-26 06:08:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    189 2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.004350
    190 2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
    191 2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    192 2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    193 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    194 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    195 WHERE images.deleted = ? AND images.is_public = ?
    196 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    197 2011-04-26 06:08:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    198 2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.004155
    199 2011-04-26 06:08:06 DEBUG [routes.middleware] Matched GET /images
    200 2011-04-26 06:08:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    201 2011-04-26 06:08:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    202 2011-04-26 06:08:06 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    203 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    204 WHERE images.deleted = ? AND images.is_public = ?
    205 2011-04-26 06:08:06 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    206 2011-04-26 06:08:06 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    207 2011-04-26 06:08:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:06] "GET /images HTTP/1.1" 200 130 0.004049
    208 2011-04-26 06:08:07 DEBUG [routes.middleware] Matched GET /images
    209 2011-04-26 06:08:07 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    210 2011-04-26 06:08:07 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    211 2011-04-26 06:08:07 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value

    212 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    213 WHERE images.deleted = ? AND images.is_public = ?
    214 2011-04-26 06:08:07 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    215 2011-04-26 06:08:07 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    216 2011-04-26 06:08:07 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:07] "GET /images HTTP/1.1" 200 130 0.005940
    217 2011-04-26 06:08:22 DEBUG [routes.middleware] Matched GET /images
    218 2011-04-26 06:08:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    219 2011-04-26 06:08:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    220 2011-04-26 06:08:22 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    221 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    222 WHERE images.deleted = ? AND images.is_public = ?
    223 2011-04-26 06:08:22 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    224 2011-04-26 06:08:22 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    225 2011-04-26 06:08:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:22] "GET /images HTTP/1.1" 200 130 0.003950
    226 2011-04-26 06:08:25 DEBUG [routes.middleware] Matched GET /images
    227 2011-04-26 06:08:25 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    228 2011-04-26 06:08:25 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    229 2011-04-26 06:08:25 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    230 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    231 WHERE images.deleted = ? AND images.is_public = ?
    232 2011-04-26 06:08:25 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    233 2011-04-26 06:08:25 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    234 2011-04-26 06:08:25 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:25] "GET /images HTTP/1.1" 200 130 0.003981
    235 2011-04-26 06:08:26 DEBUG [routes.middleware] Matched GET /images
    236 2011-04-26 06:08:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    237 2011-04-26 06:08:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    238 2011-04-26 06:08:26 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    239 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    240 WHERE images.deleted = ? AND images.is_public = ?
    241 2011-04-26 06:08:26 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    242 2011-04-26 06:08:26 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    243 2011-04-26 06:08:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:26] "GET /images HTTP/1.1" 200 130 0.004491
    244 2011-04-26 06:08:27 DEBUG [routes.middleware] Matched GET /images
    245 2011-04-26 06:08:27 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    246 2011-04-26 06:08:27 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    247 2011-04-26 06:08:27 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    248 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    249 WHERE images.deleted = ? AND images.is_public = ?
    250 2011-04-26 06:08:27 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    251 2011-04-26 06:08:27 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    252 2011-04-26 06:08:27 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:27] "GET /images HTTP/1.1" 200 130 0.004067
    253 2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
    254 2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    255 2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    256 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    257 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    258 WHERE images.deleted = ? AND images.is_public = ?
    259 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    260 2011-04-26 06:08:29 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    261 2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.004063
    262 2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
    263 2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    264 2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    265 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    266 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    267 WHERE images.deleted = ? AND images.is_public = ?
    268 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    269 2011-04-26 06:08:29 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    270 2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.004499
    271 2011-04-26 06:09:00 DEBUG [glance-registry] ********************************************************************************
    272 2011-04-26 06:09:00 DEBUG [glance-registry] Configuration options gathered from config file:
    273 2011-04-26 06:09:00 DEBUG [glance-registry] /usr/etc/glance.conf
    274 2011-04-26 06:09:00 DEBUG [glance-registry] ================================================
    275 2011-04-26 06:09:00 DEBUG [glance-registry] bind_host 0.0.0.0
    276 2011-04-26 06:09:00 DEBUG [glance-registry] bind_port 9191
    277 2011-04-26 06:09:00 DEBUG [glance-registry] debug True
    278 2011-04-26 06:09:00 DEBUG [glance-registry] log_file /var/log/glance/registry.log
    279 2011-04-26 06:09:00 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    280 2011-04-26 06:09:00 DEBUG [glance-registry] sql_idle_timeout 3600
    281 2011-04-26 06:09:00 DEBUG [glance-registry] verbose True
    282 2011-04-26 06:09:00 DEBUG [glance-registry] ********************************************************************************
    283 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    284 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] ()
    285 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    286 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    287 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    288 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    289 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    290 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    291 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'name', u'VARCHAR(255)', 0, None, 0)
    292 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'disk_format', u'VARCHAR(20)', 0, None, 0)
    293 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'container_format', u'VARCHAR(20)', 0, None, 0)
    294 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (8, u'size', u'BIGINT', 0, None, 0)
    295 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (9, u'status', u'VARCHAR(30)', 1, None, 0)
    296 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (10, u'is_public', u'BOOLEAN', 1, None, 0)
    297 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (11, u'location', u'TEXT', 0, None, 0)
    298 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (12, u'checksum', u'VARCHAR(32)', 0, None, 0)
    299 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    300 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] ()
    301 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    302 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    303 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    304 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    305 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    306 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    307 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'image_id', u'INTEGER', 1, None, 0)
    308 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'name', u'VARCHAR(255)', 1, None, 0)
    309 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'value', u'TEXT', 0, None, 0)
    310 2011-04-26 06:09:00 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    311 2011-04-26 06:09:00 DEBUG [eventlet.wsgi.server] (2063) wsgi starting up on http://0.0.0.0:9191/
    312 2011-04-26 06:09:05 DEBUG [routes.middleware] Matched GET /images
    313 2011-04-26 06:09:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    314 2011-04-26 06:09:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    315 2011-04-26 06:09:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    316 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    317 WHERE images.deleted = ? AND images.is_public = ?
    318 2011-04-26 06:09:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    319 2011-04-26 06:09:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    320 2011-04-26 06:09:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:05] "GET /images HTTP/1.1" 200 130 0.010245
    321 2011-04-26 06:09:22 DEBUG [routes.middleware] Matched GET /images
    322 2011-04-26 06:09:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    323 2011-04-26 06:09:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    324 2011-04-26 06:09:22 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    325 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    326 WHERE images.deleted = ? AND images.is_public = ?
    327 2011-04-26 06:09:22 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    328 2011-04-26 06:09:22 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    329 2011-04-26 06:09:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:22] "GET /images HTTP/1.1" 200 130 0.004139
    330 2011-04-26 06:10:30 DEBUG [routes.middleware] Matched GET /images
    331 2011-04-26 06:10:30 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    332 2011-04-26 06:10:30 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    333 2011-04-26 06:10:30 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    334 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    335 WHERE images.deleted = ? AND images.is_public = ?
    336 2011-04-26 06:10:30 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    337 2011-04-26 06:10:30 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    338 2011-04-26 06:10:30 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:10:30] "GET /images HTTP/1.1" 200 130 0.004215
    339 2011-04-26 06:19:04 DEBUG [glance-registry] ********************************************************************************
    340 2011-04-26 06:19:04 DEBUG [glance-registry] Configuration options gathered from config file:
    341 2011-04-26 06:19:04 DEBUG [glance-registry] /usr/etc/glance.conf
    342 2011-04-26 06:19:04 DEBUG [glance-registry] ================================================
    343 2011-04-26 06:19:04 DEBUG [glance-registry] bind_host 10.3.40.22
    344 2011-04-26 06:19:04 DEBUG [glance-registry] bind_port 9191
    345 2011-04-26 06:19:04 DEBUG [glance-registry] debug True
    346 2011-04-26 06:19:04 DEBUG [glance-registry] log_file /var/log/glance/registry.log
    347 2011-04-26 06:19:04 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    348 2011-04-26 06:19:04 DEBUG [glance-registry] sql_idle_timeout 3600
    349 2011-04-26 06:19:04 DEBUG [glance-registry] verbose True
    350 2011-04-26 06:19:04 DEBUG [glance-registry] ********************************************************************************
    351 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    352 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] ()
    353 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    354 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    355 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    356 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    357 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    358 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    359 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'name', u'VARCHAR(255)', 0, None, 0)
    360 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'disk_format', u'VARCHAR(20)', 0, None, 0)
    361 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'container_format', u'VARCHAR(20)', 0, None, 0)
    362 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (8, u'size', u'BIGINT', 0, None, 0)
    363 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (9, u'status', u'VARCHAR(30)', 1, None, 0)
    364 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (10, u'is_public', u'BOOLEAN', 1, None, 0)
    365 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (11, u'location', u'TEXT', 0, None, 0)
    366 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (12, u'checksum', u'VARCHAR(32)', 0, None, 0)
    367 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    368 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] ()
    369 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    370 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    371 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    372 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    373 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    374 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    375 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'image_id', u'INTEGER', 1, None, 0)
    376 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'name', u'VARCHAR(255)', 1, None, 0)
    377 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'value', u'TEXT', 0, None, 0)
    378 2011-04-26 06:19:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    379 2011-04-26 06:19:05 DEBUG [eventlet.wsgi.server] (1729) wsgi starting up on http://10.3.40.22:9191/
    380 2011-04-26 06:19:23 DEBUG [routes.middleware] Matched GET /images
    381 2011-04-26 06:19:23 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    382 2011-04-26 06:19:23 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    383 2011-04-26 06:19:23 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    384 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    385 WHERE images.deleted = ? AND images.is_public = ?
    386 2011-04-26 06:19:23 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    387 2011-04-26 06:19:23 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    388 2011-04-26 06:19:23 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    389 2011-04-26 06:19:23 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:23] "GET /images HTTP/1.1" 200 274 0.015262
    390 2011-04-26 06:19:55 DEBUG [routes.middleware] Matched GET /images
    391 2011-04-26 06:19:55 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    392 2011-04-26 06:19:55 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    393 2011-04-26 06:19:55 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    394 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    395 WHERE images.deleted = ? AND images.is_public = ?
    396 2011-04-26 06:19:55 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    397 2011-04-26 06:19:55 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    398 2011-04-26 06:19:55 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    399 2011-04-26 06:19:55 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:55] "GET /images HTTP/1.1" 200 274 0.004812
    400 2011-04-26 06:25:49 DEBUG [routes.middleware] Matched GET /images
    401 2011-04-26 06:25:49 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    402 2011-04-26 06:25:49 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    403 2011-04-26 06:25:49 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    404 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    405 WHERE images.deleted = ? AND images.is_public = ?
    406 2011-04-26 06:25:49 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    407 2011-04-26 06:25:49 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    408 2011-04-26 06:25:49 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    409 2011-04-26 06:25:49 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:25:49] "GET /images HTTP/1.1" 200 274 0.004863

steve chu (steve-chu) said : #3

This is API log
2011-04-26 06:07:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:04 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:07:04 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:07:04 DEBUG [glance-api] ================================================
2011-04-26 06:07:04 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:07:04 DEBUG [glance-api] bind_port 9292
2011-04-26 06:07:04 DEBUG [glance-api] debug True
2011-04-26 06:07:04 DEBUG [glance-api] default_store file
2011-04-26 06:07:04 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:07:04 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:07:04 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:07:04 DEBUG [glance-api] registry_port 9191
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:07:04 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:07:04 DEBUG [glance-api] verbose True
2011-04-26 06:07:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:07:04 DEBUG [eventlet.wsgi.server] (1990) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:07:06 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:06] "GET /images HTTP/1.1" 200 130 0.014728
2011-04-26 06:07:13 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:13 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:13 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:13 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:13] "GET /images HTTP/1.1" 200 130 0.006719
2011-04-26 06:07:26 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1402a50>}
2011-04-26 06:07:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:26] "GET /images HTTP/1.1" 200 130 0.005924
2011-04-26 06:07:57 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:57 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:07:57 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:07:57 DEBUG [glance-api] ================================================
2011-04-26 06:07:57 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:07:57 DEBUG [glance-api] bind_port 9292
2011-04-26 06:07:57 DEBUG [glance-api] debug True
2011-04-26 06:07:57 DEBUG [glance-api] default_store file
2011-04-26 06:07:57 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:07:57 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:07:57 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:07:57 DEBUG [glance-api] registry_port 9191
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:07:57 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:07:57 DEBUG [glance-api] verbose True
2011-04-26 06:07:57 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:07:57 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:07:57 DEBUG [eventlet.wsgi.server] (2009) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:07:59 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:07:59 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:07:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:07:59 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:59] "GET /images HTTP/1.1" 200 130 0.015041
2011-04-26 06:08:03 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:03 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:03 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:03 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:03] "GET /images HTTP/1.1" 200 130 0.006097
2011-04-26 06:08:04 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:04 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:04 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:04 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:04] "GET /images HTTP/1.1" 200 130 0.005635
2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.005909
2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.005753
2011-04-26 06:08:06 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:06] "GET /images HTTP/1.1" 200 130 0.005627
2011-04-26 06:08:07 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:07 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:07 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:07 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:07] "GET /images HTTP/1.1" 200 130 0.007509
2011-04-26 06:08:22 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:22] "GET /images HTTP/1.1" 200 130 0.005685
2011-04-26 06:08:25 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:25 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:25 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:25 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:25] "GET /images HTTP/1.1" 200 130 0.006088
2011-04-26 06:08:26 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:26] "GET /images HTTP/1.1" 200 130 0.006111
2011-04-26 06:08:27 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:27 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:27 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:27 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:27] "GET /images HTTP/1.1" 200 130 0.005660
2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.005708
2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x2276a90>}
2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.006275
2011-04-26 06:09:00 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:09:00 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:09:00 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:09:00 DEBUG [glance-api] ================================================
2011-04-26 06:09:00 DEBUG [glance-api] bind_host 0.0.0.0
2011-04-26 06:09:00 DEBUG [glance-api] bind_port 9292
2011-04-26 06:09:00 DEBUG [glance-api] debug True
2011-04-26 06:09:00 DEBUG [glance-api] default_store file
2011-04-26 06:09:00 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:09:00 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:09:00 DEBUG [glance-api] registry_host 0.0.0.0
2011-04-26 06:09:00 DEBUG [glance-api] registry_port 9191
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:09:00 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:09:00 DEBUG [glance-api] verbose True
2011-04-26 06:09:00 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:09:00 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:09:00 DEBUG [eventlet.wsgi.server] (2062) wsgi starting up on http://0.0.0.0:9292/
2011-04-26 06:09:05 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:09:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:05] "GET /images HTTP/1.1" 200 130 0.014945
2011-04-26 06:09:22 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:09:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:09:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:22] "GET /images HTTP/1.1" 200 130 0.005967
2011-04-26 06:10:30 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:10:30 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:10:30 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x1265a90>}
2011-04-26 06:10:30 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:10:30] "GET /images HTTP/1.1" 200 130 0.006091
2011-04-26 06:19:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:19:04 DEBUG [glance-api] Configuration options gathered from config file:
2011-04-26 06:19:04 DEBUG [glance-api] /usr/etc/glance.conf
2011-04-26 06:19:04 DEBUG [glance-api] ================================================
2011-04-26 06:19:04 DEBUG [glance-api] bind_host 10.3.40.22
2011-04-26 06:19:04 DEBUG [glance-api] bind_port 9292
2011-04-26 06:19:04 DEBUG [glance-api] debug True
2011-04-26 06:19:04 DEBUG [glance-api] default_store file
2011-04-26 06:19:04 DEBUG [glance-api] filesystem_store_datadir /var/lib/glance/images/
2011-04-26 06:19:04 DEBUG [glance-api] log_file /var/log/glance/api.log
2011-04-26 06:19:04 DEBUG [glance-api] registry_host 10.3.40.22
2011-04-26 06:19:04 DEBUG [glance-api] registry_port 9191
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_auth_address 127.0.0.1:8080/v1.0/
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_container glance
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_create_container_on_put False
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_key a86850deb2742ec3cb41518e26aa2d89
2011-04-26 06:19:04 DEBUG [glance-api] swift_store_user jdoe
2011-04-26 06:19:04 DEBUG [glance-api] verbose True
2011-04-26 06:19:04 DEBUG [glance-api] ********************************************************************************
2011-04-26 06:19:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
2011-04-26 06:19:04 DEBUG [eventlet.wsgi.server] (1728) wsgi starting up on http://10.3.40.22:9292/
2011-04-26 06:19:23 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:19:23 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:23 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:23 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:23] "GET /images HTTP/1.1" 200 274 0.016049
2011-04-26 06:19:55 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:19:55 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:55 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:19:55 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:55] "GET /images HTTP/1.1" 200 274 0.006598
2011-04-26 06:25:49 DEBUG [routes.middleware] Matched GET /images
2011-04-26 06:25:49 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:25:49 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.server.Controller object at 0x281ba50>}
2011-04-26 06:25:49 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:25:49] "GET /images HTTP/1.1" 200 274 0.007027

This is Registry log file
      1 2011-04-26 06:07:04 DEBUG [glance-registry] ********************************************************************************
      2 2011-04-26 06:07:04 DEBUG [glance-registry] Configuration options gathered from config file:
      3 2011-04-26 06:07:04 DEBUG [glance-registry] /usr/etc/glance.conf
      4 2011-04-26 06:07:04 DEBUG [glance-registry] ================================================
      5 2011-04-26 06:07:04 DEBUG [glance-registry] bind_host 0.0.0.0
      6 2011-04-26 06:07:04 DEBUG [glance-registry] bind_port 9191
      7 2011-04-26 06:07:04 DEBUG [glance-registry] debug True
      8 2011-04-26 06:07:04 DEBUG [glance-registry] log_file /var/log/glance/registry.log
      9 2011-04-26 06:07:04 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
     10 2011-04-26 06:07:04 DEBUG [glance-registry] sql_idle_timeout 3600
     11 2011-04-26 06:07:04 DEBUG [glance-registry] verbose True
     12 2011-04-26 06:07:04 DEBUG [glance-registry] ********************************************************************************
     13 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
     14 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     15 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
     16 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     17 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine]
     18 CREATE TABLE images (
     19 created_at DATETIME NOT NULL,
     20 updated_at DATETIME,
     21 deleted_at DATETIME,
     22 deleted BOOLEAN NOT NULL,
     23 id INTEGER NOT NULL,
     24 name VARCHAR(255),
     25 disk_format VARCHAR(20),
     26 container_format VARCHAR(20),
     27 size BIGINT,
     28 status VARCHAR(30) NOT NULL,
     29 is_public BOOLEAN NOT NULL,
     30 location TEXT,
     31 checksum VARCHAR(32),
     32 PRIMARY KEY (id),
     33 CHECK (deleted IN (0, 1)),
     34 CHECK (is_public IN (0, 1))
     35 )
     36
     37
     38 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     39 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     40 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine]
     41 CREATE TABLE image_properties (
     42 created_at DATETIME NOT NULL,
     43 updated_at DATETIME,
     44 deleted_at DATETIME,
     45 deleted BOOLEAN NOT NULL,
     46 id INTEGER NOT NULL,
     47 image_id INTEGER NOT NULL,
     48 name VARCHAR(255) NOT NULL,
     49 value TEXT,
     50 PRIMARY KEY (id),
     51 UNIQUE (image_id, name),
     52 CHECK (deleted IN (0, 1)),
     53 FOREIGN KEY(image_id) REFERENCES images (id)
     54 )
     55
     56
     57 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     58 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     59 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] CREATE INDEX ix_image_properties_name ON image_properties (name)
     60 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] ()
     61 2011-04-26 06:07:04 INFO [sqlalchemy.engine.base.Engine] COMMIT
     62 2011-04-26 06:07:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
     63 2011-04-26 06:07:04 DEBUG [eventlet.wsgi.server] (1991) wsgi starting up on http://0.0.0.0:9191/
     64 2011-04-26 06:07:06 DEBUG [routes.middleware] Matched GET /images
     65 2011-04-26 06:07:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     66 2011-04-26 06:07:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     67 2011-04-26 06:07:06 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     68 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     69 WHERE images.deleted = ? AND images.is_public = ?
     70 2011-04-26 06:07:06 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     71 2011-04-26 06:07:06 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     72 2011-04-26 06:07:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:06] "GET /images HTTP/1.1" 200 130 0.010086
     73 2011-04-26 06:07:13 DEBUG [routes.middleware] Matched GET /images
     74 2011-04-26 06:07:13 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     75 2011-04-26 06:07:13 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     76 2011-04-26 06:07:13 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     77 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     78 WHERE images.deleted = ? AND images.is_public = ?
     79 2011-04-26 06:07:13 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     80 2011-04-26 06:07:13 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     81 2011-04-26 06:07:13 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:13] "GET /images HTTP/1.1" 200 130 0.004716
     82 2011-04-26 06:07:26 DEBUG [routes.middleware] Matched GET /images
     83 2011-04-26 06:07:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x1fe0dd0>}
     84 2011-04-26 06:07:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1fe0dd0>}
     85 2011-04-26 06:07:26 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
     86 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
     87 WHERE images.deleted = ? AND images.is_public = ?
     88 2011-04-26 06:07:26 INFO [sqlalchemy.engine.base.Engine] (0, 1)
     89 2011-04-26 06:07:26 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
     90 2011-04-26 06:07:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:26] "GET /images HTTP/1.1" 200 130 0.004110
     91 2011-04-26 06:07:57 DEBUG [glance-registry] ********************************************************************************
     92 2011-04-26 06:07:57 DEBUG [glance-registry] Configuration options gathered from config file:
     93 2011-04-26 06:07:57 DEBUG [glance-registry] /usr/etc/glance.conf
     94 2011-04-26 06:07:57 DEBUG [glance-registry] ================================================
     95 2011-04-26 06:07:57 DEBUG [glance-registry] bind_host 0.0.0.0
     96 2011-04-26 06:07:57 DEBUG [glance-registry] bind_port 9191
     97 2011-04-26 06:07:57 DEBUG [glance-registry] debug True
     98 2011-04-26 06:07:57 DEBUG [glance-registry] log_file /var/log/glance/registry.log
     99 2011-04-26 06:07:57 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    100 2011-04-26 06:07:57 DEBUG [glance-registry] sql_idle_timeout 3600
    101 2011-04-26 06:07:57 DEBUG [glance-registry] verbose True
    102 2011-04-26 06:07:57 DEBUG [glance-registry] ********************************************************************************
    103 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    104 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    105 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    106 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    107 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine]
    108 CREATE TABLE images (
    109 created_at DATETIME NOT NULL,
    110 updated_at DATETIME,
    111 deleted_at DATETIME,
    112 deleted BOOLEAN NOT NULL,
    113 id INTEGER NOT NULL,
    114 name VARCHAR(255),
    115 disk_format VARCHAR(20),
    116 container_format VARCHAR(20),
    117 size BIGINT,
    118 status VARCHAR(30) NOT NULL,
    119 is_public BOOLEAN NOT NULL,
    120 location TEXT,
    121 checksum VARCHAR(32),
    122 PRIMARY KEY (id),
    123 CHECK (deleted IN (0, 1)),
    124 CHECK (is_public IN (0, 1))
    125 )
    126
    127
    128 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    129 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    130 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine]
    131 CREATE TABLE image_properties (
    132 created_at DATETIME NOT NULL,
    133 updated_at DATETIME,
    134 deleted_at DATETIME,
    135 deleted BOOLEAN NOT NULL,
    136 id INTEGER NOT NULL,
    137 image_id INTEGER NOT NULL,
    138 name VARCHAR(255) NOT NULL,
    139 value TEXT,
    140 PRIMARY KEY (id),
    141 UNIQUE (image_id, name),
    142 CHECK (deleted IN (0, 1)),
    143 FOREIGN KEY(image_id) REFERENCES images (id)
    144 )
    145
    146
    147 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    148 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    149 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] CREATE INDEX ix_image_properties_name ON image_properties (name)
    150 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] ()
    151 2011-04-26 06:07:57 INFO [sqlalchemy.engine.base.Engine] COMMIT
    152 2011-04-26 06:07:57 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    153 2011-04-26 06:07:57 DEBUG [eventlet.wsgi.server] (2010) wsgi starting up on http://0.0.0.0:9191/
    154 2011-04-26 06:07:59 DEBUG [routes.middleware] Matched GET /images
    155 2011-04-26 06:07:59 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    156 2011-04-26 06:07:59 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    157 2011-04-26 06:07:59 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    158 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    159 WHERE images.deleted = ? AND images.is_public = ?
    160 2011-04-26 06:07:59 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    161 2011-04-26 06:07:59 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    162 2011-04-26 06:07:59 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:07:59] "GET /images HTTP/1.1" 200 130 0.010451
    163 2011-04-26 06:08:03 DEBUG [routes.middleware] Matched GET /images
    164 2011-04-26 06:08:03 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    165 2011-04-26 06:08:03 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    166 2011-04-26 06:08:03 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    167 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    168 WHERE images.deleted = ? AND images.is_public = ?
    169 2011-04-26 06:08:03 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    170 2011-04-26 06:08:03 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    171 2011-04-26 06:08:03 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:03] "GET /images HTTP/1.1" 200 130 0.004306
    172 2011-04-26 06:08:04 DEBUG [routes.middleware] Matched GET /images
    173 2011-04-26 06:08:04 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    174 2011-04-26 06:08:04 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    175 2011-04-26 06:08:04 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    176 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    177 WHERE images.deleted = ? AND images.is_public = ?
    178 2011-04-26 06:08:04 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    179 2011-04-26 06:08:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    180 2011-04-26 06:08:04 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:04] "GET /images HTTP/1.1" 200 130 0.004013
    181 2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
    182 2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    183 2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    184 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    185 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    186 WHERE images.deleted = ? AND images.is_public = ?
    187 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    188 2011-04-26 06:08:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    189 2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.004350
    190 2011-04-26 06:08:05 DEBUG [routes.middleware] Matched GET /images
    191 2011-04-26 06:08:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    192 2011-04-26 06:08:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    193 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    194 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    195 WHERE images.deleted = ? AND images.is_public = ?
    196 2011-04-26 06:08:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    197 2011-04-26 06:08:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    198 2011-04-26 06:08:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:05] "GET /images HTTP/1.1" 200 130 0.004155
    199 2011-04-26 06:08:06 DEBUG [routes.middleware] Matched GET /images
    200 2011-04-26 06:08:06 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    201 2011-04-26 06:08:06 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    202 2011-04-26 06:08:06 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    203 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    204 WHERE images.deleted = ? AND images.is_public = ?
    205 2011-04-26 06:08:06 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    206 2011-04-26 06:08:06 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    207 2011-04-26 06:08:06 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:06] "GET /images HTTP/1.1" 200 130 0.004049
    208 2011-04-26 06:08:07 DEBUG [routes.middleware] Matched GET /images
    209 2011-04-26 06:08:07 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    210 2011-04-26 06:08:07 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    211 2011-04-26 06:08:07 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value

    212 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    213 WHERE images.deleted = ? AND images.is_public = ?
    214 2011-04-26 06:08:07 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    215 2011-04-26 06:08:07 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    216 2011-04-26 06:08:07 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:07] "GET /images HTTP/1.1" 200 130 0.005940
    217 2011-04-26 06:08:22 DEBUG [routes.middleware] Matched GET /images
    218 2011-04-26 06:08:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    219 2011-04-26 06:08:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    220 2011-04-26 06:08:22 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    221 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    222 WHERE images.deleted = ? AND images.is_public = ?
    223 2011-04-26 06:08:22 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    224 2011-04-26 06:08:22 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_del eted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'ima ges_location', 'images_checksum', 'image_properties_1_created_at', 'image_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_ properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    225 2011-04-26 06:08:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:22] "GET /images HTTP/1.1" 200 130 0.003950
    226 2011-04-26 06:08:25 DEBUG [routes.middleware] Matched GET /images
    227 2011-04-26 06:08:25 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server .Controller object at 0x2bb1e10>}
    228 2011-04-26 06:08:25 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    229 2011-04-26 06:08:25 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_upda ted_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images .disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.status AS images_ status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS images_checksum, image_properties_1.cre ated_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, imag e_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS imag e_properties_1_value
    230 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    231 WHERE images.deleted = ? AND images.is_public = ?
    232 2011-04-26 06:08:25 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    233 2011-04-26 06:08:25 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    234 2011-04-26 06:08:25 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:25] "GET /images HTTP/1.1" 200 130 0.003981
    235 2011-04-26 06:08:26 DEBUG [routes.middleware] Matched GET /images
    236 2011-04-26 06:08:26 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    237 2011-04-26 06:08:26 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    238 2011-04-26 06:08:26 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    239 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    240 WHERE images.deleted = ? AND images.is_public = ?
    241 2011-04-26 06:08:26 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    242 2011-04-26 06:08:26 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    243 2011-04-26 06:08:26 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:26] "GET /images HTTP/1.1" 200 130 0.004491
    244 2011-04-26 06:08:27 DEBUG [routes.middleware] Matched GET /images
    245 2011-04-26 06:08:27 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    246 2011-04-26 06:08:27 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    247 2011-04-26 06:08:27 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    248 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    249 WHERE images.deleted = ? AND images.is_public = ?
    250 2011-04-26 06:08:27 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    251 2011-04-26 06:08:27 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    252 2011-04-26 06:08:27 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:27] "GET /images HTTP/1.1" 200 130 0.004067
    253 2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
    254 2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    255 2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    256 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    257 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    258 WHERE images.deleted = ? AND images.is_public = ?
    259 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    260 2011-04-26 06:08:29 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    261 2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.004063
    262 2011-04-26 06:08:29 DEBUG [routes.middleware] Matched GET /images
    263 2011-04-26 06:08:29 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    264 2011-04-26 06:08:29 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x2bb1e10>}
    265 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    266 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    267 WHERE images.deleted = ? AND images.is_public = ?
    268 2011-04-26 06:08:29 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    269 2011-04-26 06:08:29 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    270 2011-04-26 06:08:29 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:08:29] "GET /images HTTP/1.1" 200 130 0.004499
    271 2011-04-26 06:09:00 DEBUG [glance-registry] ********************************************************************************
    272 2011-04-26 06:09:00 DEBUG [glance-registry] Configuration options gathered from config file:
    273 2011-04-26 06:09:00 DEBUG [glance-registry] /usr/etc/glance.conf
    274 2011-04-26 06:09:00 DEBUG [glance-registry] ================================================
    275 2011-04-26 06:09:00 DEBUG [glance-registry] bind_host 0.0.0.0
    276 2011-04-26 06:09:00 DEBUG [glance-registry] bind_port 9191
    277 2011-04-26 06:09:00 DEBUG [glance-registry] debug True
    278 2011-04-26 06:09:00 DEBUG [glance-registry] log_file /var/log/glance/registry.log
    279 2011-04-26 06:09:00 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    280 2011-04-26 06:09:00 DEBUG [glance-registry] sql_idle_timeout 3600
    281 2011-04-26 06:09:00 DEBUG [glance-registry] verbose True
    282 2011-04-26 06:09:00 DEBUG [glance-registry] ********************************************************************************
    283 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    284 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] ()
    285 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    286 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    287 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    288 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    289 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    290 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    291 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'name', u'VARCHAR(255)', 0, None, 0)
    292 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'disk_format', u'VARCHAR(20)', 0, None, 0)
    293 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'container_format', u'VARCHAR(20)', 0, None, 0)
    294 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (8, u'size', u'BIGINT', 0, None, 0)
    295 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (9, u'status', u'VARCHAR(30)', 1, None, 0)
    296 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (10, u'is_public', u'BOOLEAN', 1, None, 0)
    297 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (11, u'location', u'TEXT', 0, None, 0)
    298 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (12, u'checksum', u'VARCHAR(32)', 0, None, 0)
    299 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    300 2011-04-26 06:09:00 INFO [sqlalchemy.engine.base.Engine] ()
    301 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    302 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    303 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    304 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    305 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    306 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    307 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'image_id', u'INTEGER', 1, None, 0)
    308 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'name', u'VARCHAR(255)', 1, None, 0)
    309 2011-04-26 06:09:00 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'value', u'TEXT', 0, None, 0)
    310 2011-04-26 06:09:00 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    311 2011-04-26 06:09:00 DEBUG [eventlet.wsgi.server] (2063) wsgi starting up on http://0.0.0.0:9191/
    312 2011-04-26 06:09:05 DEBUG [routes.middleware] Matched GET /images
    313 2011-04-26 06:09:05 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    314 2011-04-26 06:09:05 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    315 2011-04-26 06:09:05 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    316 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    317 WHERE images.deleted = ? AND images.is_public = ?
    318 2011-04-26 06:09:05 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    319 2011-04-26 06:09:05 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    320 2011-04-26 06:09:05 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:05] "GET /images HTTP/1.1" 200 130 0.010245
    321 2011-04-26 06:09:22 DEBUG [routes.middleware] Matched GET /images
    322 2011-04-26 06:09:22 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    323 2011-04-26 06:09:22 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    324 2011-04-26 06:09:22 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    325 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    326 WHERE images.deleted = ? AND images.is_public = ?
    327 2011-04-26 06:09:22 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    328 2011-04-26 06:09:22 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    329 2011-04-26 06:09:22 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:09:22] "GET /images HTTP/1.1" 200 130 0.004139
    330 2011-04-26 06:10:30 DEBUG [routes.middleware] Matched GET /images
    331 2011-04-26 06:10:30 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    332 2011-04-26 06:10:30 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x18c5e10>}
    333 2011-04-26 06:10:30 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    334 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    335 WHERE images.deleted = ? AND images.is_public = ?
    336 2011-04-26 06:10:30 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    337 2011-04-26 06:10:30 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    338 2011-04-26 06:10:30 DEBUG [eventlet.wsgi.server] 127.0.0.1 - - [26/Apr/2011 06:10:30] "GET /images HTTP/1.1" 200 130 0.004215
    339 2011-04-26 06:19:04 DEBUG [glance-registry] ********************************************************************************
    340 2011-04-26 06:19:04 DEBUG [glance-registry] Configuration options gathered from config file:
    341 2011-04-26 06:19:04 DEBUG [glance-registry] /usr/etc/glance.conf
    342 2011-04-26 06:19:04 DEBUG [glance-registry] ================================================
    343 2011-04-26 06:19:04 DEBUG [glance-registry] bind_host 10.3.40.22
    344 2011-04-26 06:19:04 DEBUG [glance-registry] bind_port 9191
    345 2011-04-26 06:19:04 DEBUG [glance-registry] debug True
    346 2011-04-26 06:19:04 DEBUG [glance-registry] log_file /var/log/glance/registry.log
    347 2011-04-26 06:19:04 DEBUG [glance-registry] sql_connection sqlite:///glance.sqlite
    348 2011-04-26 06:19:04 DEBUG [glance-registry] sql_idle_timeout 3600
    349 2011-04-26 06:19:04 DEBUG [glance-registry] verbose True
    350 2011-04-26 06:19:04 DEBUG [glance-registry] ********************************************************************************
    351 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("images")
    352 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] ()
    353 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    354 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    355 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    356 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    357 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    358 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    359 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'name', u'VARCHAR(255)', 0, None, 0)
    360 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'disk_format', u'VARCHAR(20)', 0, None, 0)
    361 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'container_format', u'VARCHAR(20)', 0, None, 0)
    362 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (8, u'size', u'BIGINT', 0, None, 0)
    363 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (9, u'status', u'VARCHAR(30)', 1, None, 0)
    364 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (10, u'is_public', u'BOOLEAN', 1, None, 0)
    365 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (11, u'location', u'TEXT', 0, None, 0)
    366 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (12, u'checksum', u'VARCHAR(32)', 0, None, 0)
    367 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] PRAGMA table_info("image_properties")
    368 2011-04-26 06:19:04 INFO [sqlalchemy.engine.base.Engine] ()
    369 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Col ('cid', 'name', 'type', 'notnull', 'dflt_value', 'pk')
    370 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (0, u'created_at', u'DATETIME', 1, None, 0)
    371 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (1, u'updated_at', u'DATETIME', 0, None, 0)
    372 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (2, u'deleted_at', u'DATETIME', 0, None, 0)
    373 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (3, u'deleted', u'BOOLEAN', 1, None, 0)
    374 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (4, u'id', u'INTEGER', 1, None, 1)
    375 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (5, u'image_id', u'INTEGER', 1, None, 0)
    376 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (6, u'name', u'VARCHAR(255)', 1, None, 0)
    377 2011-04-26 06:19:04 DEBUG [sqlalchemy.engine.base.Engine] Row (7, u'value', u'TEXT', 0, None, 0)
    378 2011-04-26 06:19:04 DEBUG [routes.middleware] Initialized with method overriding = True, and path info altering = True
    379 2011-04-26 06:19:05 DEBUG [eventlet.wsgi.server] (1729) wsgi starting up on http://10.3.40.22:9191/
    380 2011-04-26 06:19:23 DEBUG [routes.middleware] Matched GET /images
    381 2011-04-26 06:19:23 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    382 2011-04-26 06:19:23 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    383 2011-04-26 06:19:23 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    384 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    385 WHERE images.deleted = ? AND images.is_public = ?
    386 2011-04-26 06:19:23 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    387 2011-04-26 06:19:23 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    388 2011-04-26 06:19:23 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    389 2011-04-26 06:19:23 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:23] "GET /images HTTP/1.1" 200 274 0.015262
    390 2011-04-26 06:19:55 DEBUG [routes.middleware] Matched GET /images
    391 2011-04-26 06:19:55 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    392 2011-04-26 06:19:55 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    393 2011-04-26 06:19:55 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    394 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    395 WHERE images.deleted = ? AND images.is_public = ?
    396 2011-04-26 06:19:55 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    397 2011-04-26 06:19:55 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    398 2011-04-26 06:19:55 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    399 2011-04-26 06:19:55 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:19:55] "GET /images HTTP/1.1" 200 274 0.004812
    400 2011-04-26 06:25:49 DEBUG [routes.middleware] Matched GET /images
    401 2011-04-26 06:25:49 DEBUG [routes.middleware] Route path: '/images', defaults: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    402 2011-04-26 06:25:49 DEBUG [routes.middleware] Match dict: {'action': u'index', 'controller': <glance.registry.server.Controller object at 0x1a22dd0>}
    403 2011-04-26 06:25:49 INFO [sqlalchemy.engine.base.Engine] SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images _deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_ container_format, images.size AS images_size, images.status AS images_status, images.is_public AS images_is_public, images.location AS images_location, images.checksum AS imag es_checksum, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS i mage_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_pr operties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value
    404 FROM images LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id
    405 WHERE images.deleted = ? AND images.is_public = ?
    406 2011-04-26 06:25:49 INFO [sqlalchemy.engine.base.Engine] (0, 1)
    407 2011-04-26 06:25:49 DEBUG [sqlalchemy.engine.base.Engine] Col ('images_created_at', 'images_updated_at', 'images_deleted_at', 'images_deleted', 'images_id', 'images_name', 'images_disk_format', 'images_container_format', 'images_size', 'images_status', 'images_is_public', 'images_location', 'images_checksum', 'image_properties_1_created_at', 'im age_properties_1_updated_at', 'image_properties_1_deleted_at', 'image_properties_1_deleted', 'image_properties_1_id', 'image_properties_1_image_id', 'image_properties_1_name', 'image_properties_1_value')
    408 2011-04-26 06:25:49 DEBUG [sqlalchemy.engine.base.Engine] Row (u'2011-04-24 09:12:33.709044', u'2011-04-24 09:12:33.929736', None, 0, 1, u'my image', u'raw', u'ovf', 184453 2, u'active', 1, u'file:///var/lib/glance/images/1', u'b4dcd85b7a3490507fe1e30deda4bf8d', None, None, None, None, None, None, None, None)
    409 2011-04-26 06:25:49 DEBUG [eventlet.wsgi.server] 10.3.40.22 - - [26/Apr/2011 06:25:49] "GET /images HTTP/1.1" 200 274 0.004863

steve chu (steve-chu) said : #4

Hi Jay,

I am sorry for adding the above two lengthy log files. One is api.log and the other one is registry.log file.
The following URL does not return me any thing, "http://10.3.40.22/images/". Instead, it gives me "Connection timeout" error!

The RESTful interface is critical for our application.
Please help!

Steve

Jay Pipes (jaypipes) said : #5

Hi!

Everything looks fine with your setup. It looks like you may have added the image as a non-public image?

Could you post the glance add command you executed? BTW, Does http://10.3.40.22/images/1 give anything?

-jay

steve chu (steve-chu) said : #6

Add command syntax :
sudo glance add -v name="My Image 1" is_public=true < /tmp/glance-2011.2.tar.gz --host=10.3.40.22

Index command syntax :
sudo glance index --host=10.3.40.22

Index command output :
Found 2 public images...
ID Name Disk Format Container Format Size
---------------- ------------------------------ -------------------- -------------------- --------------
1 my image raw ovf 1844532
6 My Image 1 raw ovf 120313

http://10.3.40.22/images/6 give the following error.
The connection has timed out
The server at 10.3.40.22 is taking too long to respond.

Jay Pipes (jaypipes) said : #7

If you do:

glance show 6

do you get output?

-jay

steve chu (steve-chu) said : #8

Add command syntax :
sudo glance add -v name="My Image 1" is_public=true < /tmp/glance-2011.2.tar.gz --host=10.3.40.22

Index command syntax :
sudo glance index --host=10.3.40.22

Index command output :
Found 2 public images...
ID Name Disk Format Container Format Size
---------------- ------------------------------ -------------------- -------------------- --------------
1 my image raw ovf 1844532
6 My Image 1 raw ovf 120313

http://10.3.40.22/images/6 give the following error.
The connection has timed out
The server at 10.3.40.22 is taking too long to respond.

steve chu (steve-chu) said : #9

In the folder where the image is stored, I can see only one image file as the following:
-rw-r--r--. 1 root root 120313 2011-04-26 08:07 1
-rw-r--r--. 1 root root 7168 2011-04-26 08:07 glance.sqlite

but "sudo glance index --host=10.3.40.22" shows two images as the following.
Found 2 public images...
ID Name Disk Format Container Format Size
---------------- ------------------------------ -------------------- -------------------- --------------
1 my image raw ovf 1844532
6 My Image 1 raw ovf 120313

Command "sudo glance show 6 --host=10.3.40.22" shows image 6 as the following:
URI: http://10.3.40.22/images/6
Id: 6
Public: Yes
Name: My Image 1
Size: 120313
Location: file:///var/lib/glance/images/6
Disk format: raw
Container format: ovf

steve chu (steve-chu) said : #10

The image mata data is out of sych with image files. This is not the real problem. The real problem is that the RESTful interface is not consumable. Please help!

Steve Chu

Jay Pipes (jaypipes) said : #11

Hi Steve,

OK, so two things we can try... regarding the out-of-sync metadata, would you be able to upgrade to the latest bzr trunk and retry the above commands? There was a bug that was recently fixed that looks like you may be running into (glance show <ID> wasn't showing the image's *status* properly, and inactive images were improperly displayed in glance index; see https://bugs.launchpad.net/glance/+bug/768969).

Secondly, I'm a bit confused by your statement that the RESTful interface is "not consumable". Could you elaborate on what you mean by that?

Thanks!
jay

steve chu (steve-chu) said : #12

Hi Jay,

Thank you for your response.
I can synch up image meta data with image by removing the database file
and restart api and registry servers.
That is not the problem.

The problem is that the RESTful service interface. The line "
http://10.2.40.22/images/" from browser window does not return any thing.
I specified all details in my earlier emails. This is the basic GET
request of RESTful interface. It does not work. That is what I meant this
RESTful interface "is not consumable".

The RESTful interface is the main reason we are looking for from OpanStack
Glance. We have to make it work in order to move forward.

Best regard!

Steve Chu

Cloud Development Team
SunGard Availability Services
2481 Deerwood Drive
San Ramon, CA 94583-1540

Office : 925-831-7734
Cell : 408-674-4018

Jay Pipes <email address hidden>
Sent by: <email address hidden>
04/27/2011 07:41 AM
Please respond to
<email address hidden>

To
<email address hidden>
cc

Subject
Re: [Question #154235]: can not get Glance RESTful to work.

Your question #154235 on Glance changed:
https://answers.launchpad.net/glance/+question/154235

    Status: Open => Needs information

Jay Pipes requested more information:
Hi Steve,

OK, so two things we can try... regarding the out-of-sync metadata,
would you be able to upgrade to the latest bzr trunk and retry the above
commands? There was a bug that was recently fixed that looks like you
may be running into (glance show <ID> wasn't showing the image's
*status* properly, and inactive images were improperly displayed in
glance index; see https://bugs.launchpad.net/glance/+bug/768969).

Secondly, I'm a bit confused by your statement that the RESTful
interface is "not consumable". Could you elaborate on what you mean by
that?

Thanks!
jay

--
To answer this request for more information, you can either reply to
this email or enter your reply at the following page:
https://answers.launchpad.net/glance/+question/154235

You received this question notification because you are a direct
subscriber of the question.

Jay Pipes (jaypipes) said : #13

Steve,

OK, I'm trying to narrow down what the problem might be.

When you have both servers running, can you do the following?

curl -g -f http://<HOST>:<PORT>/images

Replace <HOST> and <PORT> with the relevant information for the API server. Let me know if a) that cURL request completes and b) what the output of the above is.

Thanks!
jay

Jay Pipes (jaypipes) said : #14

Also, Steve, I notice you are in San Ramon. Any chance you can come down to Santa Clara and meet us at the OpenStack conference?

-jay

steve chu (steve-chu) said : #15

Hi Jay,
Thank you for your response.

Here is the command and its output.

curl -g -f http://10.3.40.22:9292/images
{"images": [{"name": "My Image", "container_format": "ovf", "disk_format":
"raw", "checksum": "780939ee6b6bc1132a7a203d72a0a210", "id": 1, "size":
120313}]}

Steve Chu

Cloud Development Team
SunGard Availability Services
2481 Deerwood Drive
San Ramon, CA 94583-1540

Office : 925-831-7734
Cell : 408-674-4018

Jay Pipes <email address hidden>
Sent by: <email address hidden>
04/27/2011 08:10 AM
Please respond to
<email address hidden>

To
<email address hidden>
cc

Subject
Re: [Question #154235]: can not get Glance RESTful to work.

Your question #154235 on Glance changed:
https://answers.launchpad.net/glance/+question/154235

    Status: Open => Needs information

Jay Pipes requested more information:
Steve,

OK, I'm trying to narrow down what the problem might be.

When you have both servers running, can you do the following?

curl -g -f http://<HOST>:<PORT>/images

Replace <HOST> and <PORT> with the relevant information for the API
server. Let me know if a) that cURL request completes and b) what the
output of the above is.

Thanks!
jay

--
To answer this request for more information, you can either reply to
this email or enter your reply at the following page:
https://answers.launchpad.net/glance/+question/154235

You received this question notification because you are a direct
subscriber of the question.

steve chu (steve-chu) said : #16

curl -g -f http://10.3.40.22:9292/images

{"images": [{"name": "My Image", "container_format": "ovf", "disk_format":
"raw", "checksum": "780939ee6b6bc1132a7a203d72a0a210", "id": 1, "size":
120313}]}

Jay Pipes (jaypipes) said : #17

Hmm, well I'm a bit stumped. Everything seems to be working properly, Steven. The only thing I can think of is that when you point your browser to Glance, perhaps you aren't specifying the port in the URL?

steve chu (steve-chu) said : #18

Hi Jay, the port 9292 on my host was blocked. It was the problem.
Now the problem has been resolved.