[Решено {config}] проблема с переносом между хостингами

[nflow]

Добрый день. Прошу помочь с проблемой, возникшей при переносе OcStore 2.1.0.2.1

 

Переношу сайт с одного (тестового) хостинга на другой

 

На другом хостинге уже есть сайт, к нему подключен домен. Задача в том, чтобы по домену открывался новый сайт в новой папке на сервере (замена сайта, если проще). Делаю следующее:

- заливаю папку с сайтом через winscp

- через putty создаю и импортирую дамп бд, проверяю - все есть

- редактирую оба файла config.php, сверяю и проверяю - все пути и настройки бд верно стоят

- в конфигах nginx выставляю рут к новой папке

 

Результат на скринах - на главной отображается хэдер и еще несколько элементов, страница админки открывается, но не пропускает с верными доступами

 

Подскажите, пожалуйста, в чем может быть причина

 

 

[nflow]

не может залогиниться к базе.

 

А с чем это может быть связано? Пароль, пользователя, имя бд перепроверил. Драйвер указан mysql, порт 3306

 

Может такое быть из-за настроек вебсервера?

[nflow]

смотреть в логи хотя бы

В логах самого опенкарта пусто - последние записи там давно

 

Из остальных, хоть что-либо подходящее к моменту нашел в в mariadb.log:

 

160721 16:03:35 [Note] /usr/libexec/mysqld: Normal shutdown

 

160721 16:03:35 [Note] Event Scheduler: Purging the queue. 0 events

160721 16:03:35  InnoDB: Starting shutdown...

160721 16:03:36  InnoDB: Shutdown completed; log sequence number 1619823

160721 16:03:36 [Note] /usr/libexec/mysqld: Shutdown complete

 

160721 16:03:36 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

160721 16:05:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

160721 16:05:12 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 949 ...

160721 16:05:12 InnoDB: The InnoDB memory heap is disabled

160721 16:05:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins

160721 16:05:12 InnoDB: Compressed tables use zlib 1.2.7

160721 16:05:12 InnoDB: Using Linux native AIO

160721 16:05:12 InnoDB: Initializing buffer pool, size = 128.0M

160721 16:05:12 InnoDB: Completed initialization of buffer pool

160721 16:05:12 InnoDB: highest supported file format is Barracuda.

160721 16:05:12  InnoDB: Waiting for the background threads to start

160721 16:05:13 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 1619823

160721 16:05:13 [Note] Plugin 'FEEDBACK' is disabled.

160721 16:05:13 [Note] Server socket created on IP: '0.0.0.0'.

160721 16:05:13 [Note] Event Scheduler: Loaded 0 events

160721 16:05:13 [Note] /usr/libexec/mysqld: ready for connections.

Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

 

и в php-fpm error.log

 

[21-Jul-2016 16:01:47] NOTICE: Terminating ...

[21-Jul-2016 16:01:47] NOTICE: exiting, bye-bye!

[21-Jul-2016 16:03:03] NOTICE: fpm is running, pid 730

[21-Jul-2016 16:03:03] NOTICE: ready to handle connections

[21-Jul-2016 16:03:03] NOTICE: systemd monitor interval set to 10000ms

[21-Jul-2016 16:03:35] NOTICE: Terminating ...

[21-Jul-2016 16:03:35] NOTICE: exiting, bye-bye!

[21-Jul-2016 16:05:12] NOTICE: fpm is running, pid 728

[21-Jul-2016 16:05:12] NOTICE: ready to handle connections

[21-Jul-2016 16:05:12] NOTICE: systemd monitor interval set to 10000ms

 

и firewalld

 

2016-07-21 16:04:58 ERROR: ebtables not usable, disabling ethernet bridge firewall.

 

Я в них ничего, что помогло бы, не увидел, может у вас получится? 

[nflow]

это не те логи.

 

А какие именно логи нужны, логи чего?

 

В /system/storage/logs опенкарта записей уже дней 10 нет

[nflow]

это не те логи.

 

Проблема актуальна. Вот error.log

Ошибок тут много, не могу разобраться, за какую цепляться. mysql перезагружал.

 

2016/07/22 11:19:41 [error] 935#0: *1 FastCGI sent in stderr: "PHP message: PHP Warning:  mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 7

PHP message: PHP Notice:  Error: Could not make a database link using legat@localhost in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 8" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx"

2016/07/22 11:19:43 [error] 935#0: *1 FastCGI sent in stderr: "PHP message: PHP Notice:  Error: Table 'buddy.store' doesn't exist<br />Error No: 1146<br /> Error in: <b>/srv/www/new/index.php</b> line <b>39</b><br />SELECT * FROM store WHERE REPLACE(`url`, 'www.', '') = 'http://xxxxx.xx/' in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 58

PHP message: PHP Notice:  Trying to get property of non-object in /srv/www/new/index.php on line 42

PHP message: PHP Notice:  Error: Table 'buddy.setting' doesn't exist<br />Error No: 1146<br /> Error in: <b>/srv/www/new/index.php</b> line <b>49</b><br />SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 58

PHP message: PHP Notice:  Trying to get property of non-object in /srv/www/new/index.php on line 51

PHP message: PHP Warning:  Invalid argument supplied for foreach() in /srv/www/new/index.php on line 51

PHP message: PHP Notice:  Trying to get property of non-object in /srv/www/new/index.php on line 59

PHP message: PHP Warning:  fopen(/srv/www/new/system/storage/logs/): failed to open stream: Is a directory in /srv/www/new/system/library/log.php on line 6" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx"

2016/07/22 11:19:43 [error] 935#0: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Call to a member function get() on a non-object in /srv/www/new/index.php on line 98" while reading upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx"

2016/07/22 11:19:43 [error] 935#0: *7 open() "/srv/www/new/catalog/view/theme/default/stylesheet/buyoneclick.css" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /catalog/view/theme/default/stylesheet/buyoneclick.css HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/"

2016/07/22 11:19:44 [error] 935#0: *1 open() "/srv/www/new/catalog/view/theme/default/stylesheet/buyoneclick.css" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /catalog/view/theme/default/stylesheet/buyoneclick.css HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/"

2016/07/22 11:19:52 [error] 935#0: *2 FastCGI sent in stderr: "PHP message: PHP Notice:  Error: Table 'buddy.setting' doesn't exist<br />Error No: 1146<br /> Error in: <b>/srv/www/new/admin/index.php</b> line <b>31</b><br />SELECT * FROM setting WHERE store_id = '0' in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 58

PHP message: PHP Notice:  Trying to get property of non-object in /srv/www/new/admin/index.php on line 33

PHP message: PHP Warning:  Invalid argument supplied for foreach() in /srv/www/new/admin/index.php on line 33

PHP message: PHP Warning:  fopen(/srv/www/new/system/storage/logs/): failed to open stream: Is a directory in /srv/www/new/system/library/log.php on line 6

PHP message: PHP Fatal error:  Call to a member function get() on a non-object in /srv/www/new/admin/index.php on line 79" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx"

2016/07/22 11:19:52 [error] 935#0: *3 open() "/srv/www/new/admin/view/javascript/summernote/lang/summernote-lang.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/summernote/lang/summernote-lang.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/"

2016/07/22 11:19:53 [error] 935#0: *5 open() "/srv/www/new/admin/view/javascript/jquery/datetimepicker/locale/code.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/jquery/datetimepicker/locale/code.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/"

2016/07/22 11:19:54 [error] 935#0: *7 open() "/srv/www/new/admin/view/javascript/summernote/lang/summernote-lang.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/summernote/lang/summernote-lang.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/"

2016/07/22 11:19:54 [error] 935#0: *7 open() "/srv/www/new/admin/view/javascript/jquery/datetimepicker/locale/code.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/jquery/datetimepicker/locale/code.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/"

2016/07/22 11:20:12 [error] 935#0: *7 FastCGI sent in stderr: "PHP message: PHP Notice:  Error: Table 'buddy.setting' doesn't exist<br />Error No: 1146<br /> Error in: <b>/srv/www/new/admin/index.php</b> line <b>31</b><br />SELECT * FROM setting WHERE store_id = '0' in /srv/www/new/system/storage/modification/system/library/db/mysql.php on line 58

PHP message: PHP Notice:  Trying to get property of non-object in /srv/www/new/admin/index.php on line 33

PHP message: PHP Warning:  Invalid argument supplied for foreach() in /srv/www/new/admin/index.php on line 33

PHP message: PHP Warning:  fopen(/srv/www/new/system/storage/logs/): failed to open stream: Is a directory in /srv/www/new/system/library/log.php on line 6

PHP message: PHP Fatal error:  Call to a member function get() on a non-object in /srv/www/new/admin/index.php on line 79" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "POST /admin/index.php?route=common/login HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/"

2016/07/22 11:20:12 [error] 935#0: *7 open() "/srv/www/new/admin/view/javascript/summernote/lang/summernote-lang.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/summernote/lang/summernote-lang.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/index.php?route=common/login"

2016/07/22 11:20:12 [error] 935#0: *3 open() "/srv/www/new/admin/view/javascript/jquery/datetimepicker/locale/code.js" failed (2: No such file or directory), client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /admin/view/javascript/jquery/datetimepicker/locale/code.js HTTP/1.1", host: "xxxxx.xx", referrer: "http://xxxxx.xx/admin/index.php?route=common/login"

2016/07/22 12:33:01 [error] 832#0: *55 FastCGI sent in stderr: "PHP message: PHP Warning:  phpinfo(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /srv/www/xxxxx.xx/html/phpinfo.php on line 1" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: localhost, request: "GET /phpinfo.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "xxxxx.xx"

[nflow]

Проблема решена - не смотря на то, что несколько раз проверял оба config.php, упустил важную деталь - префикс стоял 'oc', а должен был быть 'oc_'

 

С префиксом все заработало