Web Installer Authentication
Hello, I have installed and started koha-3.00.06 on ubuntu-10.04. However, when authenticating at http://127.0.1.1:8080/ the login screen is reissued without any error messages. Though, looking at the apache error.log, it looks like something has not been configured quite right yet. Was I missing something during the installation procedure? Your help is very much appreciated. Thank you, Sabine From the apache2/error.log [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.auth_types' doesn't exist at /usr/share/koha/lib/C4/ Koha.pm line 344. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Koha.pm line 345. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_subtag_registry' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 173. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 174. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_subtag_registry' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 173. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 174. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 326. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 327. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.language_descriptions' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 332. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/ lib/C4/Languages.pm line 333. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/ koha/lib/C4/Context.pm line 485. [Tue Jul 27 00:36:04 2010] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 459. [Tue Jul 27 00:36:04 2010] install.pl: DBD::mysql::st execute failed: Table 'koha.language_subtag_registry' doesn't exist at /usr/share/koha/ lib/C4/Languages.pm line 173. [Tue Jul 27 00:36:04 2010] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/ Languages.pm line 174. ---------------------------------------- Sabine Grabner Software Developer Information Services University of Applied Sciences Hochschulstr. 1 6850 Dornbirn, Austria voice +43 (0) 5572 792 2212 AIM sabine.grabner at gmail.com skype sabsigoessb www.fhv.at GmbH, FN 1654154, LG Feldkirch
[Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.auth_types' doesn't exist at /usr/share/koha/lib/C4/Koha.pm line 344.
It means that the web installer can't find tables in your Koha DB. The first step of the web installer is supposed to build de DB structure: ie create all tables. If it can't it implies that the web installer hasn't permissions to access your defined Koha DB. Take a look at your koha-conf.xml. Try to access you MySQL DB with user/password defined in koha-conf.xml. Re-read carefully INSTALL.ubuntu section related to MySQL. -- Frédéric
Hi Frederic, DB priviledges was my guess too, but the configured dbuser can create tables, see below. No matter what I enter into the authentication form, I don't receive a message about invalid credentials, and the log entry stays the same for invalid credentials. from /etc/koha/koha-conf.xml: <config> <db_scheme>mysql</db_scheme> <database>koha</database> <hostname>localhost</hostname> <port>3306</port> <user>kohaadmin</user> <pass>****</pass> .... </config> accessing with above credentials and creating a table works fine: grsa@grsa-koha3:/$ mysql -ukohaadmin -hlocalhost -p**** -Dkoha Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 170 Server version: 5.1.41-3ubuntu12.3 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create table test (name char(50)); Query OK, 0 rows affected (0.00 sec) mysql> select * from test; Empty set (0.00 sec) mysql> drop table test; Query OK, 0 rows affected (0.00 sec) mysql> Thanks, Sabine On 27.07.2010, at 10:07, Frederic Demians wrote:
[Tue Jul 27 00:36:04 2010] mainpage.pl: DBD::mysql::st execute failed: Table 'koha.auth_types' doesn't exist at /usr/share/koha/lib/C4/Koha.pm line 344.
It means that the web installer can't find tables in your Koha DB. The first step of the web installer is supposed to build de DB structure: ie create all tables. If it can't it implies that the web installer hasn't permissions to access your defined Koha DB. Take a look at your koha-conf.xml. Try to access you MySQL DB with user/password defined in koha-conf.xml. Re-read carefully INSTALL.ubuntu section related to MySQL.
-- Frédéric
---------------------------------------- Sabine Grabner Software Developer Information Services University of Applied Sciences Hochschulstr. 1 6850 Dornbirn, Austria voice +43 (0) 5572 792 2212 AIM sabine.grabner at gmail.com skype sabsigoessb www.fhv.at GmbH, FN 1654154, LG Feldkirch
accessing with above credentials and creating a table works fine:
grsa@grsa-koha3:/$ mysql -ukohaadmin -hlocalhost -p**** -Dkoha Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 170 Server version: 5.1.41-3ubuntu12.3 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create table test (name char(50)); Query OK, 0 rows affected (0.00 sec)
mysql> select * from test; Empty set (0.00 sec)
mysql> drop table test; Query OK, 0 rows affected (0.00 sec)
You may try to create all tables by hand and see if web installer can go to the next step. Find in your Koha directory a file named kohastructure.sql. Use it to build your Koha DB schema: cat kohastructure.sql | mysql -ukohaadmin -p*** koha Tell us it it helps. -- Frédéric
I created the database structure successfully, and the apache error log narrowed down to this line: [Tue Jul 27 03:33:03 2010] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 459. Regardless of the credentials I enter, I keep getting the authentication form without any sort of feedback. Thank you, Sabine On 27.07.2010, at 12:23, Frederic Demians wrote:
accessing with above credentials and creating a table works fine:
grsa@grsa-koha3:/$ mysql -ukohaadmin -hlocalhost -p**** -Dkoha Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 170 Server version: 5.1.41-3ubuntu12.3 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create table test (name char(50)); Query OK, 0 rows affected (0.00 sec)
mysql> select * from test; Empty set (0.00 sec)
mysql> drop table test; Query OK, 0 rows affected (0.00 sec)
You may try to create all tables by hand and see if web installer can go to the next step. Find in your Koha directory a file named kohastructure.sql. Use it to build your Koha DB schema:
cat kohastructure.sql | mysql -ukohaadmin -p*** koha
Tell us it it helps. -- Frédéric
---------------------------------------- Sabine Grabner Software Developer Information Services University of Applied Sciences Hochschulstr. 1 6850 Dornbirn, Austria voice +43 (0) 5572 792 2212 AIM sabine.grabner at gmail.com skype sabsigoessb www.fhv.at GmbH, FN 1654154, LG Feldkirch
2010/7/27 Sabine Grabner <sabine.grabner@fhv.at>:
I created the database structure successfully, and the apache error log narrowed down to this line: [Tue Jul 27 03:33:03 2010] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 459. Regardless of the credentials I enter, I keep getting the authentication form without any sort of feedback. Thank you,
Asking a silly question, the user you are authenticating as is the same one as you have in your koha-conf.xml file right? Chris
I created the database structure successfully, and the apache error log narrowed down to this line:
[Tue Jul 27 03:33:03 2010] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 459.
Regardless of the credentials I enter, I keep getting the authentication form without any sort of feedback.
You fail when trying to do a redirection to this page which is the web installer: /cgi-bin/koha/installer/install.pl Can you load directly this page? http://<your-server-address>/cgi-bin/koha/installer/install.pl You should have a web page displaying this title: "Welcome to the Koha Web Installer". You may need to view your Apache log file rather than the Koha log. Something is probably wrong in your apache conf file, generally koha-httpd.conf. -- Frédéric
The direct link helped! Though http://127.0.1.1:8080/cgi-bin/koha/installer/install.pl provided the same login form as before, I could step through the Web Installer after submitting my credentials. I will try to resolve httpd configuration issues with our sys admins, but if anybody has an idea right away, please let me know. Thank you for your help, Frederic! Sabine
On 27.07.2010, at 12:53, Frederic Demians wrote:
I created the database structure successfully, and the apache error log narrowed down to this line:
[Tue Jul 27 03:33:03 2010] mainpage.pl: Install required, redirecting to Installer at /usr/share/koha/lib/C4/Auth.pm line 459.
Regardless of the credentials I enter, I keep getting the authentication form without any sort of feedback.
You fail when trying to do a redirection to this page which is the web installer:
/cgi-bin/koha/installer/install.pl
Can you load directly this page?
http://<your-server-address>/cgi-bin/koha/installer/install.pl
You should have a web page displaying this title: "Welcome to the Koha Web Installer".
You may need to view your Apache log file rather than the Koha log. Something is probably wrong in your apache conf file, generally koha-httpd.conf.
-- Frédéric
---------------------------------------- Sabine Grabner Software Developer Information Services University of Applied Sciences Hochschulstr. 1 6850 Dornbirn, Austria voice +43 (0) 5572 792 2212 AIM sabine.grabner at gmail.com skype sabsigoessb www.fhv.at GmbH, FN 1654154, LG Feldkirch
participants (3)
-
Chris Cormack -
Frederic Demians -
Sabine Grabner