Installation woes - mysql connection fails

[sgaucho]

Hi,

I am installing OTRS 3.1.12 on a server which already has a mysql server. I shutdown the old mysql server before executing the webinstaller for OTRS.

Currently I am stuck in the 2nd step of the webinstaller (http://localhost/otrs/installer.pl) which is for database creation. I left the password field blank and when I click on Verify db definition, I get a "Can't connect to database, read comment!" message.

What is happening is that OTRS is starting the old Mysql server instead of the mysql server which comes packed in the installation. How do I force OTRS to not use the existing mysql server?

I do not have the root password for the old server and tried resetting the root password in vain..

Any help please?

thanks,
sg

[jojo]

what about deinstallation of the pold stuff before you do an installation of OTRS. Or much better, use a new machine for OTRS. Or switch to Linux ...

[sgaucho]

Hi,

I cant uninstall the old server since there are some dbs which cannot be deleted. Anyway, I found a way to update the root password. But now I have a new problem.

I get the following message when creating the otrs database:

Creating database "otrs"
Done
Creating tables 'otrs-schema.mysql.sql'
Failed
---==> Can't create table '.\otrs1\virtual_fs.frm' (errno: 139)


How do I deal with this problem now!?

tx

[jojo]

this is an mysql error (and seems to be related to an old an known mysql bug). So I suggest to setup otrs on a fresh machine or have someone updating your database to the latest version

[sgaucho]

Hello,

I only have this server available to me. I can probably backup the databases in the old server and uninstall it. But will this resolve my problem? i.e, if I uninstall the old server instance will OTRS use the embedded mysql server?

thanks,
sg

[jojo]

if you use the installer, the installer will install mysql. For your setup you should switch to a manual installation

[sgaucho]

hmm ok. But I have already run the installer otrs-3.1.12-win-installer-2.4.5.exe and it has installed quite a few components.

Do I have to run any uninstaller before executing a manual setup?

thanks,
sg