Witam, mecze od wczoraj php, mysql i lms.
Wszytsko ladnie sie skompilowalo, mysql dziala, moge tworzyc bazy itd, lms
odpala, php dziala, ale lms wyslwietla komunikat taki:
" Napotkano błędy w bazie danych!
Zapytanie: database connect
Błąd: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
Zapytanie: SELECT keyvalue FROM dbinfo WHERE keytype = 'dbversion'
Błąd: We're not connected!
Zapytanie: SELECT section, var, value FROM uiconfig WHERE disabled=0
Błąd: We're not connected!
Zapytanie: INSERT INTO sessions (id, ctime, mtime, atime, vdata, content) VALUES
('f4345ad120174c2f550bbca9f862b2df0433ffb55095bb54', UNIX_TIMESTAMP(),
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(),
'a:4:{s:11:"REMOTE_ADDR";s:13:"83.16.105.XXX";s:15:"HTTP_USER_AGENT";s:87:"Mozilla/5.0
(Windows; U; Windows NT 5.2; en-US; rv:1.7.12) Gecko/20050915
Firefox/1.0.7";s:11:"SERVER_NAME";s:26:"XXX.internetdsl.tpnet.pl";s:11:"SERVER_PORT";s:2:"80";}',
'a:0:{}')
Błąd: We're not connected!
Zapytanie: DELETE FROM sessions WHERE atime < UNIX_TIMESTAMP() - '600' AND mtime
< UNIX_TIMESTAMP() - '600'
Błąd: We're not connected!
Zapytanie: SELECT COUNT(id) FROM admins
Błąd: We're not connected!
Zapytanie: SELECT rights FROM admins WHERE id=NULL
Błąd: We're not connected!"
/var/lib/mysql/mysql.sock znajduje sie na swoim miejscu,
"root@xxx:~# ls -la /var/lib/mysql
total 20735
drwxrwx--- 5 mysql mysql 368 2005-10-02 14:24 ./
drwxr-xr-x 8 root root 200 2005-10-02 10:54 ../
-rw-rw---- 1 mysql mysql 5242880 2005-10-02 14:22 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2005-10-02 14:22 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 2005-10-02 14:22 ibdata1
drwx------ 2 mysql mysql 3336 2005-10-02 14:26 lms/
drwx------ 2 mysql mysql 1584 2005-10-02 14:18 mysql/
srwxrwxrwx 1 mysql mysql 0 2005-10-02 14:22 mysql.sock=
drwx------ 2 mysql mysql 48 2005-10-02 14:18 test/
-rw-rw---- 1 mysql mysql 10059 2005-10-02 14:18 xxx-bin.000001
-rw-rw---- 1 mysql mysql 214579 2005-10-02 14:18 xxx-bin.000002
-rw-rw---- 1 mysql mysql 17141 2005-10-02 14:26 xxx-bin.000003
-rw-rw---- 1 mysql mysql 57 2005-10-02 14:22 xxx-bin.index"
Wersje:
Slackware 10.0, kerenel 2.4.29.(wiem, stary troche)
LMS 1.6.4 Mala
(1.669.2.15/1.7.2.4)
DB: 2005042400
MySQL: Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 4.3
PHP: PHP 4.4.0 (cli) (built: Oct 2 2005 14:38:01)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
Apache 1.3.31.
phpMyAdmin wywala komunikat taki:
" MySQL zwrócił komunikat: Dokumentacja
#2002 - Serwer nie odpowiada (lub gniazdo lokalnego serwera MySQL server's nie
jest skonfigurowane poprawnie)"
Php konfigureowane z takimi opcjami:
"'./configure' '--prefix=/usr' '--with-layout=GNU' '--with-apxs=/usr/sbin/apxs'
'--with-config-file-path=/etc/apache' '--with-exec-dir=/usr/bin'
'--with-openssl' '--with-zlib' '--with-bz2' '--with-gd' '--with-png'
'--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-ttf'
'--with-freetype-dir=/usr/local' '--with-curl=/usr/local'
'--with-cpdflib=/usr/local' '--with-expat-dir=/usr' '--with-gmp'
'--with-iconv=/usr/local' '--with-xml' '--with-mysql=shared,/usr/local'
'--with-mysql-sock=/var/lib/mysql/mysql.sock' '--disable-debug'
'--enable-posix' '--disable-rpath' '--enable-safe-mode' '--enable-magic-quotes'
'--disable-dmalloc' '--enable-bcmath' '--enable-dio' '--enable-gd-native-ttf'
'--enable-sysvsem' '--enable-sysvshm' '--enable-wddx' '--enable-versioning'
'--enable-pic' '--enable-inline-optimization' '--enable-memory-limit'
'--with-xml' '--with-ftp"
PHPINFO.php zwraca takie dane o mysql:
"mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.14
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/local/include/mysql
MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host localhost localhost
mysql.default_password no value no value
mysql.default_port 3306 3306
mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysql.default_user root root
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off"
Zalamuje juz rece, rekompilowalem i mysqla i php juz wielkrotnie od wczoraj,
poszedlem spac po 4 rano a dzis od rana dalej walka z tym.
Moze mial ktos cos takeigo albo podpowie co moge byc nie tak?
BTW. NIe ma dostepu do archiwum listy mailingowej. Wyszukiwanie w lms.rulez.pl
tez nie daje efektow.
Bede wdzieczny za kazda sugestie mogaca doprowadzic do dzialania php+mysql.
AeoN
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.