Witam
Mam problem z uruchomieniem LMS. Zainstalowalem wszystko: php 5.0.5, apache 2.0.54, MySQL 4.1.14 i nie moge sie połaczyc z baza danych. Apache nie zwraca zadnego bledu, zas MySQL:
050928 0:56:09 1 Connect mysql@localhost as anonymous on 1 Init DB Access denied for user ''@'localhost' to database 'lms' 1 Query SELECT keyvalue FROM dbinfo WHERE keytype = 'dbversion' 1 Query SELECT section, var, value FROM uiconfig WHERE disabled=0 1 Query SELECT id FROM sessions WHERE id = 'b7f0252130eeff5d12954cafea064f5604339cd3d015ef50' 1 Query INSERT INTO sessions (id, ctime, mtime, atime, vdata, content) VALUES ('0e2c76c5ffc735b69935d78f6a7aae2904339ce0907c3922', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 'a:4:{s:11:"REMOTE_ADDR";s:13:"192.168.0.101";s:15:"HTTP_USER_AGENT";s:87:"Mozilla/5.0 (Windows; U; Windows NT 5.1; pl-PL; rv:1.7.12) Gecko/20050919 Firefox/1.0.7";s:11:"SERVER_NAME";s:12:"192.168.0.21";s:11:"SERVER_PORT";s:2:"80";}', 'a:0:{}') 1 Query SELECT COUNT(id) FROM admins 1 Query SELECT rights FROM admins WHERE id=NULL 1 Query UPDATE sessions SET content = 'a:1:{s:10:"lastmodule";s:8:"adminadd";}', mtime = UNIX_TIMESTAMP() WHERE id = '0e2c76c5ffc735b69935d78f6a7aae2904339ce0907c3922' 1 Quit
Wyglada jakby nie czytal z pliku lms.ini ustawien o userach do bazy danych tylko korzytal z jakis domyslnych ustawien. Plik php.ini skopiowalem do workdir i do etc/lms/lms.ini wraz z plikiem lms-mgc.ini. W pliku lms.ini wsyztsko pozamienialem wg instrukcji. Kawalek pliki lms.ini odnosnie bazy danych:
[database]
; Database type. Actually in 100% supported is 'mysql', but for the time being isn't ; seen problems with 'postgres'. Default: mysql ; type = mysql ; Host where database is installed. Most often, localhost, but can here set ; anything (IP, domain, path to socket in format 'localhost:/path/to/socket'). ; Default: localhost ; host = localhost ; Name of database user account. In many cases (if you've go by documentation) ; that will be 'lms'. When you'll want to use privileged account, probably you'll ; enter 'root' (MySQL on most of *nixes), 'mysql' (on PLD) or 'postgres' (PostgreSQL). ; Default: mysql ; user = lms ; Database password. Default: empty ; password = haslo ; Name of database. Default: lms ; database = lms ; Database encoding. Use it if your database is encoded in different than ; default, e.g. when you use database created with LMS versions earlier ; than 1.5.4. Default: unicode ; server_encoding = 'latin1'
Udalo mi sie odpalic to jak w bazie danych dalem dostep dowolnemu uzytkownikowi i mozliwosc wykonywania wszystkich polecen.
Michal B.
Moze to dlatego ze nie skasowales ; ? Pisalo w dokumentacji zeby usuwac ;.
-