Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   Fedora Packaging (http://www.linux-archive.org/fedora-packaging/)
-   -   koji build server install - DatabaseError: error 'ERROR: relation "sessions_id_seq" does not exist (http://www.linux-archive.org/fedora-packaging/448647-koji-build-server-install-databaseerror-error-error-relation-sessions_id_seq-does-not-exist.html)

11-05-2010 03:41 PM

koji build server install - DatabaseError: error 'ERROR: relation "sessions_id_seq" does not exist
 
Hey there.

I'm trying to build my own koji build server and following along with the
instructions here: http://fedoraproject.org/wiki/Koji/ServerHowTo

I got past the postgres authentication stuff and the SSL cert stuff, and
now I'm trying to get basic functionality working with koji-hub and
running into a bit of a sticky issue that I can't resolve on my own.

The 'list-hosts' command seems to work ok:

[kojiadmin@bpkojipoc001 ~]$ koji list-hosts
Hostname Enb Rdy Load/Cap Arches Last Update

But the "add-user" command gives me a:

File "/usr/share/koji-hub/kojixmlrpc.py", line 191, in _marshaled_dispatch
response = self._dispatch(method, params)
File "/usr/share/koji-hub/kojixmlrpc.py", line 253, in _dispatch
ret = func(*params,**opts)
File "/usr/lib/python2.6/site-packages/koji/auth.py", line 649, in sslLogin
return context.session.sslLogin(*args, **opts)
File "/usr/lib/python2.6/site-packages/koji/auth.py", line 394, in sslLogin
sinfo = self.createSession(user_id, hostip, koji.AUTHTYPE_SSL)
File "/usr/lib/python2.6/site-packages/koji/auth.py", line 480, in createSession
c.execute(q, {})
File "/usr/lib/python2.6/site-packages/koji/db.py", line 95, in execute
ret = self.cursor.execute(operation, parameters)
File "/usr/lib64/python2.6/site-packages/pgdb.py", line 174, in execute
self.executemany(operation, (params,))
File "/usr/lib64/python2.6/site-packages/pgdb.py", line 195, in executemany
raise DatabaseError, "error '%s' in '%s'" % ( msg, sql )
DatabaseError: error 'ERROR: relation "sessions_id_seq" does not exist
LINE 1: SELECT nextval('sessions_id_seq')
^
' in 'SELECT nextval('sessions_id_seq')'

I checked out the DB schema and didn't see a 'sessions_id_seq' anywhere,
and the only place that I could find it was in auth.py in the koji python
utilities scripts (which is where it's failing, I believe).

Can someone explain to me how this is being used and/or how to fix this
issue? If this is not the correct place for this question, can someone
please point me to a more koji-oriented mailing list?

Thanks in advance.

- Steve Webb

--
Steve Webb | System Administrator
Beatport | Music for DJ's
------------------------------------------
2399 Blake Street, Suite 170
Denver, Colorado USA 80205
tel: +1.720.932.9103
fax: +1.720.932.9104
noc: +1.303.565.2710
mobile: +1.303.564.4269
--
packaging mailing list
packaging@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/packaging

11-05-2010 03:50 PM

koji build server install - DatabaseError: error 'ERROR: relation "sessions_id_seq" does not exist
 
Thanks. I will. Sorry for the spam.

- Steve

On Fri, 5 Nov 2010, Jason L Tibbitts III wrote:

>>>>>> "sw" == steve webb <steve.webb@beatport.com> writes:
>
> sw> Hey there. I'm trying to build my own koji build server and
> sw> following along with the instructions here:
> sw> http://fedoraproject.org/wiki/Koji/ServerHowTo
>
> Perhaps you want the buildsys list instead? There's not much
> packaging-related content in your message.
>
> - J<
> --
> packaging mailing list
> packaging@lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/packaging
>

--
Steve Webb | System Administrator
Beatport | Music for DJ's
------------------------------------------
2399 Blake Street, Suite 170
Denver, Colorado USA 80205
tel: +1.720.932.9103
fax: +1.720.932.9104
noc: +1.303.565.2710
mobile: +1.303.564.4269
--
packaging mailing list
packaging@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/packaging


All times are GMT. The time now is 08:25 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.