[TYPO3] Typo3 and connection to mysql on non standard port

Marco Antonioli antonioli at gammsystem.com
Tue Oct 16 09:16:37 CEST 2007


Hi Robert,

thanks , but seems that doesn't works.
I tried also with 127.0.0.1:/path/to/sock but it's the same.

I checked again db permission but are correct and I can connect with it 
with various tools.

@mauro : maybe dbal is a solution. I can consider it if no direct 
solutions comes from typo3 core..

More suggests accepted ;D

Thanks again
Marco


Robert von Hackwitz ha scritto:
> On Mon, 2007-10-15 at 18:09 +0200, Marco Antonioli wrote:
>> Hi all,
>>
>> I have a mysql version 4.1 installed on port 3306 (linux OS).
>> For testing poupose I have installed mysql 5.0 on the same machine but 
>> on port 3307 (and a different sock location), and this works fine.
>>
>> Now I want to configure a Typo3 with a 4.1.2 version site (all sites on 
>> that machine uses typo 4.1.1) to use mysql 5 db.
>>
>> (User used to connect have right permission on db. The db is created 
>> empty manually)
>>
>> With the Install tool (and so in localconf.php) I have:
>>
>> $typo_db_host='localhost:3307' //but doesn't works
>>
>> I tried also mysql sock connection
>>
>> $typo_db_host='localhost:/path/to/mysql.sock' //but doesn't works
>>
>> Has anyone experience with nonstandard port connection on Typo3?
>>
>> Thanks a lot in advance
>>
>> Marco
> 
> Hi Marco,
> 
> try: $typo_db_host = '127.0.0.1:3307';
> 
> When you set "localhost" or "localhost:port" php always tries to connect
> to a local socket, so $typo_db_host='localhost:3307' doesn't affects
> mysql connection.
> (http://www.php.net/manual/en/function.mysql-connect.php)
> Bye
> --
> Robert von Hackwitz
> robertvonhackwitz at gmail.com
> 


More information about the TYPO3-english mailing list