[Koha] Authorization problems between Koha and Mysql

[csg7142 at students.kennesaw.edu]

My apologies if this issue has been addressed previously, I didn’t find it in
the archives.   

After logging into Koha the login screen keeps appearing again after clicking on
a new link.  We where able to add a branch but no books or new users. The Mysql
Koha tables are empty.

Any help would be beneficial.   

We are running:

http://localhost:8080/cgi-bin/koha/about.pl
Koha version:  	2.0.1RC1
OS version (from 'uname -a'): 	OpenBSD 3.4 GENERIC#18 i386
Perl version: 	5.008
MySQL version: 	3.23.58
Apache version: Apache/1.3.28 (Unix) mod_ssl/2.8.15 OpenSSL/0.9.7b


bash-2.05b# less /usr/local/koha/log/koha-error_log
 
[Thu Oct 28 00:08:20 2004] [error] [client ###.###.###.###] File does not exist:
/usr/local/koha/intranet/htdocs/favicon.ico
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 351.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 353.
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 359.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 361.
DBD::mysql::db selectrow_array failed: Table 'Koha.sessions' doesn't exist at
/usr/local/koha/intranet/modules/C4/Auth.pm line 224.
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 351.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 353.
DBD::mysql::st execute failed: Unknown column 'password' in 'field list' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 359.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 361.
DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at
/usr/local/koha/intranet/modules/C4/Auth.pm line 281.
DBD::mysql::db do failed: Table 'Koha.sessions' doesn't exist at
/usr/local/koha/intranet/modules/C4/Auth.pm line 283.
DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 400.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 401.
DBD::mysql::st execute failed: Unknown column 'flags' in 'field list' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 385.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 386.
DBD::mysql::st execute failed: Table 'Koha.userflags' doesn't exist at
/usr/local/koha/intranet/modules/C4/Auth.pm line 388.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 389.
DBD::mysql::st execute failed: Unknown column 'userid' in 'where clause' at
/usr/local/koha/intranet/modules/C4/Auth.pm line 426.
DBD::mysql::st fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/modules/C4/Auth.pm line 428.

=-=-=-=-=-=-=
Chris Gilbert
Kennesaw State University


-------------------------------------------------