Peter,
config.pm: it looks like a default otrs/mysql installation
as you cannot find the otrs db in mssql: is it possible that a mysql server
is running on this machine?
I presume you mean "is it possible that it is NOT running on this machine".
Based on this Config.pm file presented the simple answer is no. The
localhost remark indicates that the db is sourced locally.
However as I noted yesterday... you may have multiple instances of MS-SQL
installed and OTRS isn't on the default instance. In addition, the database
could have been loaded on a different engine. Is mySQL installed on the box?
I was also thinking that the Config.pm file isn't the 'Active' file. A
back-up of the defaults or similar but the actual OTRS files are elsewhere
on the machine. Is there another Config.pm on the system?
LQ
ps - you should be careful publishing passwords to public lists. If your DB
is not secured properly or if you have a mischievous user internally...
you've provided the username and password to the database. Once you get
this back together change that password (hopefully to something better than
hot
_____
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Peter van Beugen
Sent: Sunday, February 10, 2008 8:53 AM
To: User questions and discussions about OTRS.org
Subject: RE: [Spam] Re: [otrs] I lost all admin power into OTRS!!!
config.pm: it looks like a default otrs/mysql installation
as you cannot find the otrs db in mssql: is it possible that a mysql server
is running on this machine?
regards,
Peter
_____
Van: otrs-bounces@otrs.org namens BCWINFO
Verzonden: za 9-2-2008 20:47
Aan: User questions and discussions about OTRS.org
Onderwerp: Re: [Spam] Re: [otrs] I lost all admin power into OTRS!!!
Ok LQ.
I have edited Config.pm:
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{'DatabaseHost'} = 'localhost';
# Database
# (The database name.)
$Self->{'Database'} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{'DatabaseUser'} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/CryptPassword.pl
# for crypted passwords.)
$Self->{'DatabasePw'} = 'hot';
# DatabaseDSN
I think that this tells me that the name of my database is really OTRS as I
thought. Right?
However, unhappily, I still could not find it into SQL Querry Analizer.
What a hell!
On Feb 9, 2008 3:39 AM, LQ Marshall