[Koha] Web Installer Authentication

[Sabine Grabner]

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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100727/18267f29/attachment.htm