MYSQL phpMyAdmin 2.7.0-pl2 Solaris 8.1

Problems with the Solaris version of XAMPP, questions, comments, and anything related.

MYSQL phpMyAdmin 2.7.0-pl2 Solaris 8.1

Postby steves » 28. July 2006 19:02

I can get to the SQLLite, but I can not get to phpMyAdmin for MySql. The xampp is not installed as root. I see in the ststus link that MySQLDatabase is deactivated.
I have enterd the default_host in the php.ini / config.inc.php

getting

#1130 - Host 'wsqeai05' is not allowed to connect to this MySQL server
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 19:03

I have enterd the default_host in the php.ini / config.inc.php

Why?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 19:20

Wiedmann wrote:
I have enterd the default_host in the php.ini / config.inc.php

Why?


It was not finding MySql and I thought I needed to define the host
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 19:23

and I thought I needed to define the host

No.

It was not finding MySql

Is MySQL running?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 19:26

Wiedmann wrote:
and I thought I needed to define the host

No.

It was not finding MySql

Is MySQL running?

No it saya that it is deactivated in the status window, but on xampp start it says it started
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby steves » 28. July 2006 19:33

Wiedmann wrote:
and I thought I needed to define the host

No.

It was not finding MySql

Is MySQL running?


When I take all that out and restart xampp and try phpMyAdmin I get

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 19:34

but on xampp start it says it started

Make a "ps -axf" and look is MySQL really running.

Maybe a:
/opt/xampp/bin/mysqladmin ping
also work for the test.

Is there a log file for MySQL somewhere?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 19:44

Wiedmann wrote:
but on xampp start it says it started

Make a "ps -axf" and look is MySQL really running.

Maybe a:
/opt/xampp/bin/mysqladmin ping
also work for the test.

Is there a log file for MySQL somewhere?



hawk 13553 0.0 0.0 1104 928 pts/10 S 14:38:37 0:00 /bin/sh /opt/app/wsqeai05c01/atlas/xampp/bin/mysqld_safe --defaults-file=/opt/app/wsqeai05c01/atlas/xampp/etc/my.cnf --datadir=/opt/app/wsqeai05c01/atlas/xampp/var/mysql --pid-file=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/wsqeai05.pid
hawk 13573 0.0 0.126168 7752 pts/10 S 14:38:37 0:00 /opt/app/wsqeai05c01/atlas/xampp/sbin/mysqld --defaults-file=/opt/app/wsqeai05c01/atlas/xampp/etc/my.cnf --basedir=/opt/app/wsqeai05c01/atlas/xampp --datadir=/opt/app/wsqeai05c01/atlas/xampp/var/mysql --pid-file=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/wsqeai05.pid --port=3306 --socket=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 19:48

Ok.

a
Code: Select all
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin ping

also works?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 19:54

Wiedmann wrote:Ok.

a
Code: Select all
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin ping

also works?


no

/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin ping
ld.so.1: mysqladmin: fatal: libmysqlclient.so.15: open failed: No such file or directory
Killed
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 20:02

Can you make a:
Code: Select all
cd /opt/app/wsqeai05c01/atlas/xampp
find . -name "libmysqlclient.so.15"
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 20:05

Wiedmann wrote:Can you make a:
Code: Select all
cd /opt/app/wsqeai05c01/atlas/xampp
find . -name "libmysqlclient.so.15"



Yup

hawk@wsqeai05-> find . -name "libmysqlclient.so.15"
./lib/mysql/libmysqlclient.so.15
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 20:11

Code: Select all
cd /opt/app/wsqeai05c01/atlas/xampp/lib
ln -s mysql/libmysqlclient.so.15


and then try
Code: Select all
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin ping

once more.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby steves » 28. July 2006 20:16

Wiedmann wrote:
Code: Select all
cd /opt/app/wsqeai05c01/atlas/xampp/lib
ln -s mysql/libmysqlclient.so.15


and then try
Code: Select all
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin ping

once more.


Ok I added the lib to my LD_LIBRARY_PATH

hawk@wsqeai05-> mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/xampp/var/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/xampp/var/mysql/mysql.sock' exists!
hawk@wsqeai05-> lsof | grep 3306
mysqld 14512 hawk 3u IPv4 0x30016119b30 0t0 TCP *:3306 (LISTEN)
steves
 
Posts: 23
Joined: 26. July 2006 21:59

Postby Wiedmann » 28. July 2006 20:26

Well, the main problem is your install path.
Try:
Code: Select all
/opt/app/wsqeai05c01/atlas/xampp/bin/mysqladmin --socket=/opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock ping

(one line)

For PHP you can config the socket in "php.ini":
Code: Select all
[MySQL]
mysql.default_socket = /opt/app/wsqeai05c01/atlas/xampp/var/mysql/mysql.sock
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Next

Return to XAMPP for Solaris

Who is online

Users browsing this forum: No registered users and 2 guests