
Ok guys I ran into another snag here. We now have two mysql databases up and running, one is Mysql 3 and we just installed mysql 5 a week or so ago. We are in the process of merging our data and scripts from mysql 3 to mysql 5. We are trying to setup OTRS onto the mysql 5 database. Unfortunatly, in order to talk to the MySQL 5 database we have to tell whatever web program we were using to use /opt/mysql5/tmp/mysql.sock (in PHP this was done by telling it to connect to localhost:/opt/mysql5/tmp/mysql.sock). Unfortunatly, this doesn't work in perl (or something) as OTRS keeps trying to connect to the old MySQL server. Anyone know how to give perl (or OTRS) the mysql 5 socket? So far I have tried the PHP method (giving the DB HOST localhost:/opt/mysql5/tmp/mysql.sock) and have also tried changing the dtatabase command to $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{Da tabaseHost};port=/opt/mysql5/tmp/mysql.sock;"; That didn't work either. Anyone else have any suggestions? --Matthew Shapiro