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.