Форум системных администраторов

Как говорится грабли на граблях )))))
Сведения о системе и пакетах

uname -a
FreeBSD unknowns 10.0-RELEASE FreeBSD 10.0-RELEASE 
php53-5.3.28_3                 PHP Scripting Language
php53-ctype-5.3.28_3           The ctype shared extension for php
php53-curl-5.3.28_3            The curl shared extension for php
php53-dom-5.3.28_3             The dom shared extension for php
php53-extensions-1.6           "meta-port" to install PHP extensions
php53-gd-5.3.28_3              The gd shared extension for php
php53-gettext-5.3.28_3         The gettext shared extension for php
php53-hash-5.3.28_3            The hash shared extension for php
php53-iconv-5.3.28_1           The iconv shared extension for php
php53-json-5.3.28_3            The json shared extension for php
php53-mysql-5.3.28_3           The mysql shared extension for php
php53-mysqli-5.3.28_3          The mysqli shared extension for php
php53-pdo-5.3.28_3             The pdo shared extension for php
php53-pdo_sqlite-5.3.28_3      The pdo_sqlite shared extension for php
php53-posix-5.3.28_3           The posix shared extension for php
php53-session-5.3.28_3         The session shared extension for php
php53-simplexml-5.3.28_3       The simplexml shared extension for php
php53-sqlite-5.3.28_3          The sqlite shared extension for php
php53-sqlite3-5.3.28_3         The sqlite3 shared extension for php
php53-tokenizer-5.3.28_3       The tokenizer shared extension for php
php53-xml-5.3.28_3             The xml shared extension for php
php53-xmlreader-5.3.28_3       The xmlreader shared extension for php
php53-xmlwriter-5.3.28_3       The xmlwriter shared extension for php
php53-zip-5.3.28_3             The zip shared extension for php
php53-zlib-5.3.28_3            The zlib shared extension for php

mysql55-client-5.5.39          Multithreaded SQL database (client)
mysql55-server-5.5.39          Multithreaded SQL database (server)

squid-2.7.9_5                  HTTP Caching Proxy

sams-1.0.5_6,1                 Squid 2.x Accounting Management System

apache22-2.2.27_6              Version 2.2.x of Apache web server with prefork MPM.

Что выходит в вебморде самса

Код: Выделить всё

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_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 235

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 248

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 265

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/local/share/pear') in /usr/local/share/sams/main.php on line 166

http-error.log

Код: Выделить всё

[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Notice:  Undefined variable: function in /usr/local/share/sams/mysqltools.php on line 316, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 235, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 248, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 265, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  require() [<a href='function.require'>function.require</a>]: Unable to access ./lang/lang. in /usr/local/share/sams/lframe.php on line 38, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  require(./lang/lang.) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /usr/local/share/sams/lframe.php on line 38, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required './lang/lang.' (include_path='.:/usr/local/share/pear') in /usr/local/share/sams/lframe.php on line 38, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 235, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 248, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 265, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  require() [<a href='function.require'>function.require</a>]: Unable to access ./lang/lang. in /usr/local/share/sams/main.php on line 166, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  require(./lang/lang.) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /usr/local/share/sams/main.php on line 166, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required './lang/lang.' (include_path='.:/usr/local/share/pear') in /usr/local/share/sams/main.php on line 166, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 235, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 248, referer: http://192.168.0.254/sams/
[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/share/sams/mysqltools.php on line 265, referer: http://192.168.0.254/sams/

Гугль не помог ((((

kotig
под тем же пользователем к мусе в консоли зацепиться получается? Если да, то может сначала попробовать поменять пароль с секурного на несекурный типа "123" и попробовать снова создать таблицы. Недавно подобная хрень была. Трабл оказался в символе $ в пароле - пых его некорректно передавал.

mysql_fetch_array() уж deprecated;
Пруф http://php.net/manual/ru/function.mysql-fetch-array.php
Юзаем класс PDO;
Боюсь скоро уберут поддержку и придется переписывать SAMS;
А по теме...строки

Код: Выделить всё

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

не смутили?

Смутить то смутили... куда идти???
2 Infernal Flame
логинится получается под пользователем sams...

kotig
правильную вещь Фантом говорит. Старая самса уже, использует давно выпиленные функции из свежих версий пыхов-мускулей. Короче либо переписывать, либо бросать это дело, либо даунгрейдить софт...

Phantom
Infernal Flame
Маны читать надо прежде чем ахинею нести, товарисчи. php-mysql выпилили аж в версии 5,5 а у топикстартера стоит версия 5,3.

kotig
Покаж выхлоп php -m

Код: Выделить всё

root@un:/usr/home/kotig # php -m
PHP Deprecated:  Directive 'safe_mode' is deprecated in PHP 5.3 and greater in Unknown on line 0

Deprecated: Directive 'safe_mode' is deprecated in PHP 5.3 and greater in Unknown on line 0
[PHP Modules]
Core
ctype
curl
date
dom
ereg
gd
gettext
hash
iconv
json
libxml
mhash
mysql
mysqli
mysqlnd
pcre
PDFlib
PDO
pdo_sqlite
posix
Reflection
session
SimpleXML
SPL
SQLite
sqlite3
standard
tokenizer
xml
xmlreader
xmlwriter
zip
zlib

[Zend Modules]

Походу как я понял safe_mode и из php53 убрали... (((((

kotig писал(а):Походу как я понял safe_mode и из php53 убрали... (((((

да, но это не причина для беспокойства. Просто закоменть в конфиге эту строку.

Для начала надо разбираться с ошибками по-порядку, начиная с самых критичных. Вот например

Код: Выделить всё

PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required './lang/lang.' (include_path='.:/usr/local/share/pear') in /usr/local/share/sams/main.php on line 166

такая ошибка может блокировать дальнейшее выполение кода, так что я бы начал бы с ее устранения, а дальше по нисходящей. Ну и по традиции - свети конфигом.

Вот в этой строке я обратил внимание вот на что.

Код: Выделить всё

[Mon Aug 11 19:16:46 2014] [error] [client 192.168.0.253] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required './lang/lang.' (include_path='.:/usr/local/share/pear') in /usr/local/share/sams/lframe.php on line 38, referer: http://192.168.0.254/sams/

Странно вот это http://192.168.0.254/sams/. Я не помню до конца процедуру установки,но в последних версиях уже был sams2. И строка должна была быть http://192.168.0.254/sams2/ как у меня. Может версия у тебя старая? Ну так как предположение.... Просто в старых версиях там рогов много было.

Форум системных администраторов

Sams эхъ....

Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....

Re: Sams эхъ....