|
|
Posted by Pugi! on 04/10/07 12:10
Maybe I should emphasize that there is no local mysql on the webserver
with phpMyAdmin. I just want to connect to remote databases. From
webservers with a local mysql it is possible to connect to the remote
mysql-server with phpmyadmin.
Pugi!
On 10 apr, 11:31, "Pugi!" <pugin...@gmail.com> wrote:
> At my company we want a new configuration for our webservers. Two
> loadbalanced webservers (linux and apache) and one database and (nfs)
> fileserver. MySQL is only installed on db server. Apache is only
> installed on webservers. (Even the websites (files) are on the dbnfs
> server, mounted with an nfs mount to the webservers).
> When I want to use phpmyadmin to connect to the database I get
> #2002 - The server is not responding (or the local MySQL server's
> socket is not correctly configured)
>
> I already made changes to php.ini and config.inc.php (phpmyadmin) but
> keep getting same error message. There is no local socket. MySQL is
> not installed on the webserver. I did install apache with mysql
> support.
>
> I have no problem making a connection with a php-script
> (mysql_connect('192.168.6.3', 'username', 'password')), selecting
> database and executing a query. So I guess the settings in the php.ini
> are correct.
>
> Info from phpinfo();
> mysql
> MySQL Support enabled
> Active Persistent Links 0
> Active Links 0
> Client API version 4.1.20
> MYSQL_MODULE_TYPE external
> MYSQL_SOCKET /var/lib/mysql/mysql.sock
> MYSQL_INCLUDE -I/usr/include/mysql
> MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
>
> Directive Local Value Master Value
> mysql.allow_persistent On On
> mysql.connect_timeout 60 60
> mysql.default_host 192.168.6.3 192.168.6.3
> mysql.default_password no value no value
> mysql.default_port 3306 3306
> mysql.default_socket 192.168.6.3:/var/lib/mysql/mysql.sock
> 192.168.6.3:/var/lib/mysql/mysql.sock
> mysql.default_user no value no value
> mysql.max_links Unlimited Unlimited
> mysql.max_persistent Unlimited Unlimited
> mysql.trace_mode Off Off
>
> conf.inc.php (phpmyadmin)
> $i++;
>
> /* Authentication type */
>
> $cfg['Servers'][$i]['auth_type'] = 'cookie';
>
> /* Server parameters */
>
> $cfg['Servers'][$i]['host'] = '192.168.6.3:3306';
>
> $cfg['Servers'][$i]['connect_type'] = 'tcp';
>
> $cfg['Servers'][$i]['compress'] = false;
>
> /* Select mysqli if your server has it */
>
> $cfg['Servers'][$i]['extension'] = 'mysql';
>
> php.ini
> [MySQL]
> ; Allow or prevent persistent links.
> mysql.allow_persistent = On
>
> ; Maximum number of persistent links. -1 means no limit.
> mysql.max_persistent = -1
>
> ; Maximum number of links (persistent + non-persistent). -1 means no
> limit.
> mysql.max_links = -1
>
> ; Default port number for mysql_connect(). If unset, mysql_connect()
> will use
> ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
> ; compile-time value defined MYSQL_PORT (in that order). Win32 will
> only look
> ; at MYSQL_PORT.
> mysql.default_port = 3306
>
> ; Default socket name for local MySQL connects. If empty, uses the
> built-in
> ; MySQL defaults.
> mysql.default_socket = /var/lib/mysql/mysql.sock
>
> ; Default host for mysql_connect() (doesn't apply in safe mode).
> mysql.default_host = 192.168.6.3
>
> ; Default user for mysql_connect() (doesn't apply in safe mode).
> mysql.default_user =
>
> ; Default password for mysql_connect() (doesn't apply in safe mode).
> ; Note that this is generally a *bad* idea to store passwords in this
> file.
> ; *Any* user with PHP access can run 'echo
> get_cfg_var("mysql.default_password")
> ; and reveal this password! And of course, any users with read access
> to this
> ; file will be able to reveal the password as well.
> mysql.default_password =
>
> ; Maximum time (in seconds) for connect timeout. -1 means no limit
> mysql.connect_timeout = 60
>
> ; Trace mode. When trace_mode is active (=On), warnings for table/
> index scans and
> ; SQL-Errors will be displayed.
> mysql.trace_mode = Off
Navigation:
[Reply to this message]
|