Mailinglist Archive: opensuse (4288 mails)

[Geek Boi <chutchin@xxxxxxxxxxxxx>]

Has anyone else attempted to setup OpenTRS?  I have followed the 
README.webserver and README.database files. Both mysql and apache are 
configured according to these two files.  The database is setup and populated 
with the tables that the 
/usr/share/doc/packages/otrs/install/database/initial_insert.sql file 
contains.  But when I attempt to logon to http://localhost/otrs/index.pl, I 
get the following error.....

Can't call method "prepare" on an undefined value at 
/opt/OpenTRS//Kernel/System/DB.pm line 139.

If I run the file /opt/OpenTRS/scripts/suse-rcotrs restart I get the following 
error.....

Checking database connect...(DBI->connect(database=otrs;host=localhost;:otrs)
failed: Access denied for user: 'otrs@localhost' (Using password: YES) at 
/opt/OpenTRS//Kernel/System/DB.pm line 61
Can't call method "prepare" on an undefined value at 
/opt/OpenTRS//Kernel/System/DB.pm line 139.
	(in cleanup) Can't call method "disconnect" on an undefined value at 
/opt/OpenTRS//Kernel/System/DB.pm line 78.
) Error!!
-----------------------------------------------------------------------------------------
May the database isn't configured yet? Try http://yourhost/otrs/installer.pl
		or configure your database with README.database
-----------------------------------------------------------------------------------------


If I go in and delete the database and the otrs users from mysql and try and 
connect to http://localhost/orts/installer.pl I get the form to create the 
database and otrs user accounts but when I attempt to hit apply I get the 
following error which makes no sense for I can easily login to mysql with the 
same login and password from the command prompt.

CMD: mysql -u root -p mypasswordhere -h localhost -e 'create database otrs'
Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using 
password: NO) false.

Now I know root@localhost is very capable of logining into mysql and creating 
databases and tables and users.  I even installed webmin and attempted to 
create the database, tables and user from there with no luck.  

The "troubleshooting" section of the documentation is "sparse" to put it 
mildly.  They point you to the otrs website which only has the same version 
of the documentation to go by.....kind of a circular reference that gets you 
nowhere fast.

The software was installed from the SuSE 8.0 CD with the initial installation 
on the computers.  No dependencies have been left un-resolved in yast2 and 
there appears to be no updates in YOU for otrs or mysql as of this afternoon.  
The machine was patched with YOU minutes after getting the network card 
setup.

Any ideas?  Any better documentation?  Any spare home lobotomy kits for short 
term loan?

Charles Hutchinson