ZoneMinder Forums

Пишу на русском (переведете в google)
1-Ваша инструкция по ссылке https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way НЕ ВЕРНА
2-Правильно изменять файл /etc/mysql/conf.d/mysql.cnf В этом случае все работает как Вы и указали в своей инструкции
Ниже привожу скриншоты
Для Ваших указаний следует ошибка,показанная ниже на скриншоте-1 Если изменять файл /etc/mysql/conf.d/mysql.cnf , то все работает без ошибок как показано на скриншоте-2 В итоге далее по Вашей инструкции все работает без ошибок и получаем рабочий сервер zoneminder как показано на скриншоте-3 С уважением
Борис

Youve not done the timezone correctly, probably left the ; on the start


Hi guys,

i was wondering how to put my zm install on a subdomain,

I'm trying to change the details in the vhosts but am having trouble, was wondering if anybody had any advice?

Many thanks

The instructions in the WIKI cover the correct time zone entry.

Just followed the instructions because I wanted to move to 16.04 from 14.04 and I noticed that ZM isn't requiring me to log in or authenticate to itself?

diluted wrote:Just followed the instructions because I wanted to move to 16.04 from 14.04 and I noticed that ZM isn't requiring me to log in or authenticate to itself?

If you used the upgrade instructions in the WIKI, they have not been tested with the final release of 16.04. I did a quick review and found a couple of things I'll need to change. Family matters have kept me quite busy the past week...

bb

bbunge wrote:

diluted wrote:Just followed the instructions because I wanted to move to 16.04 from 14.04 and I noticed that ZM isn't requiring me to log in or authenticate to itself?

If you used the upgrade instructions in the WIKI, they have not been tested with the final release of 16.04. I did a quick review and found a couple of things I'll need to change. Family matters have kept me quite busy the past week...

bb

Actually I did a fresh install on a new VM. Not a pressing issue since I still have a 1.28 VM on 14.04 that authenticates. Hope all is well with the family I'm looking forward to 1.29 so I'll stay subscribed to this thread.

Well, you will need to enable authentication from the options menu once ZM is up and running. That is not part of installation but configuration. See the users guide

http://zoneminder.readthedocs.org/en/latest/

Look at https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way where it says PHP timezone. You need to set the timezone for PHP to something like Europe/Berlin.

bbunge wrote:Well, you will need to enable authentication from the options menu once ZM is up and running. That is not part of installation but configuration. See the users guide

http://zoneminder.readthedocs.org/en/latest/

Yea so I feel slightly retarded... I guess I just forgot that I clicked that before.

borism wrote:Пишу на русском (переведете в google)
1-Ваша инструкция по ссылке https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way

Code: Select all

cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf

НЕ ВЕРНА
2-Правильно изменять файл /etc/mysql/conf.d/mysql.cnf

Code: Select all

[mysql]
sql_mode = NO_ENGINE_SUBSTITUTION

В этом случае все работает как Вы и указали в своей инструкции
Ниже привожу скриншоты
skip.
С уважением
Борис

Solution correct for Mysql 5.6.
/home/vladimir# cat /etc/mysql/conf.d/mysql.cnf
[mysql]
sql_mode = NO_ENGINE_SUBSTITUTION

#mysql -u root -p
mysql: [ERROR] unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'


cat /etc/mysql/conf.d/mysql.cnf
[mysql]
# sql_mode = NO_ENGINE_SUBSTITUTION

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.7.12-0ubuntu1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Any ideas ???? Question still open.

Vladimir.Izmalkov wrote:

Code: Select all

#mysql -u root -p
mysql: [ERROR] unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'

Any ideas ???? Question still open.

Yes; there's an error in the wiki instructions. The sql_mode = NO_ENGINE_SUBSTITUTION directive should go in the [mysqld] section (i.e. with a 'd' not without!).

I've edited the wiki to correct this.

MJN wrote:

Vladimir.Izmalkov wrote:

Code: Select all

#mysql -u root -p
mysql: [ERROR] unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'

Any ideas ???? Question still open.

Yes; there's an error in the wiki instructions. The sql_mode = NO_ENGINE_SUBSTITUTION directive should go in the [mysqld] section (i.e. with a 'd' not without!).

I've edited the wiki to correct this.

Good Catch! Thanks.

bb

bbunge wrote:

MJN wrote:

Vladimir.Izmalkov wrote:

Code: Select all

#mysql -u root -p
mysql: [ERROR] unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION'

Any ideas ???? Question still open.

Yes; there's an error in the wiki instructions. The sql_mode = NO_ENGINE_SUBSTITUTION directive should go in the [mysqld] section (i.e. with a 'd' not without!).

I've edited the wiki to correct this.

Good Catch! Thanks.

bb

Thanks a lot !!!

I findout this yesterday at the late evening by myself and test. Now everything work fine !!!

Here is my changes:

cat /etc/mysql/conf.d/mysql.cnf
[mysql]
[mysqld]
sql_mode = 'NO_ENGINE_SUBSTITUTION'

May be it`s have to be added to documenttation

Issue fixed. Topic Closed.

You can get rid of the [mysql] section as it is invalid. You also haven't followed the instructions about which file to edit.

(And the topic should remain open to others - it wasn't created just for you!)

You havn't set the timezone is the right php.ini file. Normally the one you need to edit is /etc/php/apache2/php.ini