|
Lines 14-31
Link Here
|
| 14 |
|
14 |
|
| 15 |
1. Preliminary steps |
15 |
1. Preliminary steps |
| 16 |
|
16 |
|
| 17 |
1.1 Install databases/mysql56-server |
17 |
1.1 Install databases/mysql56-server or newer |
| 18 |
You may choose your favourite method - ports or packages here. |
18 |
You may choose your favourite method - ports or packages here. |
| 19 |
FreeBSD default setting use STRICT_TRANS_TABLES sql_mode. It's mandatory to disable it. Edit your my.cnf or create new in /var/db/mysql |
19 |
FreeBSD default setting use STRICT_TRANS_TABLES sql_mode. It's mandatory to disable it. Edit your my.cnf accordingly |
| 20 |
|
|
|
| 21 |
The following example works with ZoneMinder quite well |
| 22 |
|
20 |
|
| 23 |
[server] |
21 |
The following SQL mode should be compatible with ZM: |
| 24 |
skip-networking |
22 |
sql_mode= NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
| 25 |
skip-name-resolve |
|
|
| 26 |
innodb_flush_method = O_DIRECT |
| 27 |
skip-innodb_doublewrite |
| 28 |
innodb_file_per_table |
| 29 |
|
23 |
|
| 30 |
ZoneMinder use very simple queries, however it tends to write to |
24 |
ZoneMinder use very simple queries, however it tends to write to |
| 31 |
the database quite a lot depending on your capture mode and number |
25 |
the database quite a lot depending on your capture mode and number |
|
Lines 105-111
Link Here
|
| 105 |
exec(). Sorry, chroot folks. |
99 |
exec(). Sorry, chroot folks. |
| 106 |
|
100 |
|
| 107 |
PHP throws warning if date.timezone option is not set. The best place |
101 |
PHP throws warning if date.timezone option is not set. The best place |
| 108 |
to do it is an ini file in /usr/local/etc/php |
102 |
to do it is to create new ini file in /usr/local/etc/php with overrides |
| 109 |
|
103 |
|
| 110 |
date.timezone = "UTC" |
104 |
date.timezone = "UTC" |
| 111 |
|
105 |
|
|
Lines 148-157
Link Here
|
| 148 |
other than zmuser/zmpass then you must now edit /usr/local/etc/zm.conf. Change |
142 |
other than zmuser/zmpass then you must now edit /usr/local/etc/zm.conf. Change |
| 149 |
ZM_DB_USER and ZM_DB_PASS to the values you created in the previous step. |
143 |
ZM_DB_USER and ZM_DB_PASS to the values you created in the previous step. |
| 150 |
|
144 |
|
| 151 |
Additionally, you must also edit |
|
|
| 152 |
/usr/local/www/zoneminder/api/app/Config/database.php in a similar |
| 153 |
manner. Scroll down and change login and password to the values you created in the previous step. |
| 154 |
|
| 155 |
Enable and start ZoneMinder |
145 |
Enable and start ZoneMinder |
| 156 |
sysrc zoneminder_enable="YES" |
146 |
sysrc zoneminder_enable="YES" |
| 157 |
service zoneminder start |
147 |
service zoneminder start |