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
Hi, On Wednesday, May 01, 2002 at 01:16:03, Geek Boi wrote:
Has anyone else attempted to setup OpenTRS? I have followed the
http://sdb.suse.de/de/sdb/html/ast_otrs.html <- only german. we are a little bit behind of english translations in sdb :( It says please use the update version from http://otrs.org/pages/index.pl?Site=Download or the one form our ftp that comes ASAP. Henne -- Hendrik Vogelsang aka Henne mailto: hvogel<at>hennevogel.de Getting fired is the best thing that could happen to any of us. That way, we'd quit treading water and do something with our lives. # random sigs made with fortune
participants (2)
-
Geek Boi
-
Henne Vogelsang