[postfixadmin:bugs] #300 Unable to connect on remote Mysql

[Erik <er...@us...>]

I think another solution could be to change following line in functions.inc.php (Version 3.1)

1274c1274
<             $link = @mysqli_connect ($CONF['database_host'], $CONF['database_user'], $CONF['database_password'], $CONF['database_name'], $CONF['database_port']) or $error_text .= ("<p />DEBUG INFORMATION:<br />Connect: " .  mysqli_connect_error () . "$DEBUG_TEXT");
---
>             $link = @mysqli_connect ($CONF['database_host'], $CONF['database_user'], $CONF['database_password']) or $error_text .= ("<p />DEBUG INFORMATION:<br />Connect: " .  mysqli_connect_error () . "$DEBUG_TEXT");

and use 

$CONF['database_type'] = 'mysqli';
$CONF['database_host'] = '127.0.0.1';
$CONF['database_port'] = '3308';

instead.


---

** [bugs:#300] Unable to connect on remote Mysql**

**Status:** open
**Group:** v2.3.6
**Created:** Mon Aug 05, 2013 06:31 PM UTC by Debux
**Last Updated:** Sat Aug 23, 2014 02:26 PM UTC
**Owner:** nobody


Hi everyone,

I try to connect postfixadmin on remote Mysql, but this error appears:

Error: Can't connect to database
Please edit the $CONF['database_*] parameters in config.inc.php

DEBUG INFORMATION:
Connect: Unknown MySQL server host '10.0.0.40:3308' (2) 

My config.inc.php:

$CONF['database_type'] = 'mysqli';
$CONF['database_host'] = '10.0.0.40:3308';
$CONF['database_user'] = 'postfixadmin';
$CONF['database_password'] = 'password';
$CONF['database_name'] = 'postfix';

When i try on shell with mysql command (mysql -h 10.0.0.40 -u postfixadmin -ppassword -D postfix -P 3308) the access works, someone know what might be happening?


---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.