Re: Setting up Koji question - postgres
On 06/02/2012 03:38 PM, Tom Lane wrote: Mathieu Bridon 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
Re: Setting up Koji question - postgres
Mathieu Bridon 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 -- devel mailing list devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/devel
Re: Setting up Koji question - postgres
Mathieu Bridon píše v So 02. 06. 2012 v 19:34 +0800: > On Sat, 2012-06-02 at 10:14 +0200, 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 > > 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 ah, then I was blind or I don't know what I was looking for, sorry :-) Dan -- devel mailing list devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/devel
Re: Setting up Koji question - postgres
On Sat, 2012-06-02 at 10:14 +0200, 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 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 -- Mathieu -- devel mailing list devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/devel
Re: Setting up Koji question - postgres
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 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
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 -- devel mailing list devel@lists.fedoraproject.org https://admin.fedoraproject.org/mailman/listinfo/devel
Setting up Koji question - postgres
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