Hi Christian, On Mon, Oct 20, 2003 at 11:02:16AM +0200, Christian Junk wrote:
We are using a MSSQL Server for our customer user database, too. OTRS itself resides on a separate MySQL server.
I installed OTRS from the current CVS tree and made the necessary changes in Config.pm - i added the following lines: [...] get the following error-message in /var/log/httpd/error.log:
[Mon Oct 20 10:18:21 2003] null: DBD::mysql::st execute failed: Table 'otrs.customer_user' doesn't exist at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 265. ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon Oct 20 12:18:21 2003
Message: Table 'otrs.customer_user' doesn't exist, SQL: 'SELECT pw, login FROM customer_user WHERE valid_id in ( 1 ) AND login = 'junkc''
Traceback (2568): Module: Kernel::System::CustomerAuth::DB::Auth (v1.7) Line: 88 Module: Kernel::System::CustomerAuth::Auth (v1.4) Line: 53 Module: Apache::ROOT::otrs::customer_2epl::handler (v1.21) Line: 178 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149
[Mon Oct 20 12:18:21 2003] null: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 287.
Who can help?
You configured the customer-info backend successfully. But if you want to use the customer panel you also need to configure the customer auth module. E. g. agains the otrs customer table or an LDAP directory (or maybe with an own customer auth module). In your case you try to use the Kernel::System::CustomerAuth::DB module (agains otrs.customer_user table) for customer authentication. This will not work.
Christian
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- esanta: 12:23am an 61 Tage 1:40, 10 Benutzer, Durchschnittslast: 0,08, 0,27, 0,20