Re: Setting up Koji question

2012-06-08 Thread John Maclean

On 21 May 2012, at 07:07, Gregory Hosler ghos...@redhat.com wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Hi all,
 
 I am setting up a Koji server, and following the instructions given on the
 Fedora Koji wiki
 
http://fedoraproject.org/wiki/Koji/ServerHowTo
 
 Part way down, there are directions on
 
Generate a PKCS12 user certificate
 
 This is for web browser. This is only required for user certificates.
 
 The statement to create such a certificate is:
 
openssl pkcs12 -export -inkey certs/${user}.key -in certs/${user}.crt \
-CAfile ${caname}_ca_cert.crt \
-out certs/${user}_browser_cert.p12
 
 
 caname is globally set (in the above documentation) to koji.
 
 My problem is the user variable. There are no clues or hints as to what the
 user variable should be set to.
 
 Has anyone setup Koji before ? Anyone know how this should read ?
 
 Many thanks in advance, and all the best,
 
 - -Greg
 
 - -- 
 +-+
 
 Please also check the log file at /dev/null for additional information.
(from /var/log/Xorg.setup.log)
 
 | Greg Hosler   ghos...@redhat.com|
 +-+
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.12 (GNU/Linux)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
 iEYEARECAAYFAk+524wACgkQ404fl/0CV/RB8gCghP0oYND6xFrHbo2/u8pUNPyk
 nfsAnRlBjLnLDHlqH84VTzKxP1vBLno3
 =MVx9
 -END PGP SIGNATURE-
 -- 
 devel mailing list
 devel@lists.fedoraproject.org
 https://admin.fedoraproject.org/mailman/listinfo/devel



This works for me.   


grep DN /etc/httpd/conf.d/kojihub.conf  /etc/koji-hub/hub.conf 
/etc/httpd/conf.d/kojihub.conf:PythonOption ProxyDNs  
/C=GB/ST=Surrey/O=Xentic/OU=kojiweb/CN=jayeola.zapto.org/emailAddress=jaye...@gmail.com
/etc/koji-hub/hub.conf:DNUsernameComponent = CN
/etc/koji-hub/hub.conf:ProxyDNs = 
/C=GB/ST=Surrey/O=Xentic/OU=kojiweb/CN=jayeola.zapto.org/emailAddress=jaye...@gmail.com-- 
devel mailing list
devel@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/devel

koji servers and the caname

2012-06-05 Thread john maclean

Hi,

When setting up a koji server, does one have to use a caname of koji? 
Surely one should be able to use a server's FDQN?


Thanks  - john

--
devel mailing list
devel@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/devel

Re: Setting up Koji question - postgres

2012-06-02 Thread john maclean

On 06/02/2012 09:14 AM, Dan Horák wrote:

john maclean píše v So 02. 06. 2012 v 06:07 +0100:

Setting up a private koji server. The keys and certs have been set up. Stuck at 
psql stage. This command always bombs.


command
psql koji koji   /usr/share/doc/koji*/docs/schema.sql


first this file is elsewhere

find / -iname '*schema.sql*' 2/dev/null
/usr/share/pgsql/information_schema.sql

you really shouldn't play with information_schema.sql, it's PostgreSQL
internal file

as it seems the koji sql files are not packaged you must get them from
the koji source package


Dan





So it's best to get all of the koji-related packages from git?

Anyways. I installed postgres-devel and that command now seems to work.

Another hurdle now. This system is set up for ssl but it appears that 
it's still looking for a password.




Starting kojid: Traceback (most recent call last):
  File /usr/sbin/kojid, line 2873, in module
session.login()
  File /usr/lib/python2.6/site-packages/koji/__init__.py, line 1564, 
in login
sinfo = self.callMethod('login',self.opts['user'], 
self.opts['password'],opts)

KeyError: 'password'
   [FAILED]



--
devel mailing list
devel@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/devel

Re: Setting up Koji question - postgres

2012-06-02 Thread john maclean

On 06/02/2012 03:38 PM, Tom Lane wrote:

Mathieu Bridonboche...@fedoraproject.org  writes:

On Sat, 2012-06-02 at 10:14 +0200, Dan Horák wrote:

as it seems the koji sql files are not packaged you must get them from
the koji source package

Not packaged?
$ yum whatprovides \*koji\*sql
[... snip ...]
koji-1.6.0-3.fc17.noarch : Build system tools
Repo: fedora
Matched from:
Filename: /usr/share/doc/koji-1.6.0/docs/schema.sql
Filename: /usr/share/doc/koji-1.6.0/docs/schema-upgrade-1.4-1.5.sql
Filename: /usr/share/doc/koji-1.6.0/docs/schema-upgrade-1.3-1.4.sql
Filename: /usr/share/doc/koji-1.6.0/docs/schema-upgrade-1.2-1.3.sql

Why is that sort of thing being kept in %doc?  I always thought that
doc files should be those that aren't required in the operation of
the software, which is surely not the case if these are needed to
set up the database.

Anyway, these are surely unrelated to postgres' information_schema.sql,
which is automatically installed when the database is initialized
(hence the OP was getting a lot of errors from the objects already
existing).

regards, tom lane






It works!

 koji call getLoggedInUser
{'id': 1,
 'krb_principal': None,
 'name': 'kojiadmin',
 'status': 0,
 'usertype': 0}


  ^_^


http://jayeola.zapto.org/koji



-- 
devel mailing list
devel@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/devel

Setting up Koji question - postgres

2012-06-01 Thread john maclean

Setting up a private koji server. The keys and certs have been set up. Stuck at 
psql stage. This command always bombs.


command
psql koji koji  /usr/share/doc/koji*/docs/schema.sql


first this file is elsewhere

find / -iname '*schema.sql*' 2/dev/null
/usr/share/pgsql/information_schema.sql


but that is not a problem, huh?

so  now that I have found what I think is the right file.


psql koji koji  /usr/share/pgsql/information_schema.sql



WARNING:  no privileges were granted for information_schema
GRANT
SET
ERROR:  permission denied for schema information_schema
ERROR:  permission denied for schema information_schema
ERROR:  permission denied for schema information_schema
ERROR:  permission denied for schema information_schema
ERROR:  permission denied for schema information_schema
ERROR:  permission denied for schema information_schema


and on and on

... what can i do about this?
--
devel mailing list
devel@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/devel