Всем доброе время суток. Решил поставить sams в качестве системы управления доступом через squid. Следовал настройкам, описаным в 1) http://sams.perm.ru/doc/ru/
2) http://sams.nixdev.net/wiki/debian4.0
Вроде все настроил, но когда в браузере набрал http://127.0.0.1/sams, то обнаружил большое кол-во сообщений следующего вида:
=========================================================================================
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 289
Access denied for user sams@localhost to MySQL
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 296
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 296
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 303
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 303
SAMS databases not connected
The base squidlog not created or the user sams has no rights to connection to it
The base squidctrl not created or the user sams has no rights to connection to it
SAMS documentation
english
russian
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 234
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 234
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/share/sams/mysqltools.php on line 235
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 247
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 247
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/share/sams/mysqltools.php on line 248
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 264
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 264
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/share/sams/mysqltools.php on line 265
Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/local/share/sams/mysqltools.php on line 274
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /usr/local/share/sams/mysqltools.php on line 274
Warning: require() [function.require]: Unable to access ./lang/lang. in /usr/local/share/sams/main.php on line 166
Warning: require(./lang/lang.) [function.require]: failed to open stream: No such file or directory in /usr/local/share/sams/main.php on line 166
Fatal error: require() [function.require]: Failed opening required './lang/lang.' (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/share/sams/main.php on line 166
=========================================================================================
Вот содержимое sams.conf:
[client]
SQUID_DB=squidlog
SAMS_DB=squidctrl
MYSQLHOSTNAME=localhost
MYSQLUSER=root // имя администратора mysql,
MYSQLPASSWORD= // пароля нет, по умолчанию после установки не менял
MYSQLVERSION=4.0
SQUIDCACHEFILE=access.log
SQUIDROOTDIR=/etc/squid3
SQUIDLOGDIR=/var/log/squid3
SQUIDCACHEDIR=/var/l/squid3
SAMSPATH=/usr/local/bin
SQUIDPATH=/usr/sbin
SQUIDGUARDLOGPATH=/var/log/squid3
SQUIDGUARDDBPATH=/etc/squid3
RECODECOMMAND=iconv -f KOI8-R -t 866 %finp > %fout
LDAPSERVER=servername_or_ipadress
LDAPBASEDN=your.domain
LDAPUSER=DomainAdministrator
LDAPUSERPASSWD=passwd
LDAPUSERSGROUP=Users
REJIKPATH=/usr/local/rejik
SHUTDOWNCOMMAND=shutdown -h now
CACHENUM=0
========================================================================================
Данные о системе:
ОС Debian etch 4.0
php5
apache 2.2
squid 3
В sams.conf менял MYSQLUSER на sams, пароль так же оставлял пустым, т.к. при настройке выполнял команды:
GRANT ALL ON squidctrl.* TO sams@localhost IDENTIFIED BY ""; // пароль оставил пустым
GRANT ALL ON squidlog.* TO sams@localhost IDENTIFIED BY ""; // пароль оставил пустым
Ничего не помогло.