Всем доброе время суток. Решил поставить 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 MySQLWarning: 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 itSAMS documentation
english
russianWarning: 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 ""; // пароль оставил пустымНичего не помогло.
в мускуле flush privileges делали?
или рестарт мускула
Выполнил flush privileges в MySQL. Перезагрузил на всякий случай еще и apache и squid. Не помогло.
>Выполнил flush privileges в MySQL. Перезагрузил на всякий случай еще и apache
>и squid. Не помогло.такая же проблема была, решил:
оказывается был у меня еще 1 sams.conf, в "/etc/sams.conf" помимо того что в папке sams'a лежит. Пупо исправил на нужные мне значения Все заработало.
>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Проблемы с доступом к MySQL. Нужно посмотреть, что в таблицах db и user есть соответствующие записи, разрешающие доступ пользователям www-data и sams доступ к базе.
Нужно свериться ещё раз с инструкцией...