Hey knigggett
I'lll try what you suggested for the auth hash issue, but in the meantime I had to migrate ZM to a new centos VM and I am having an issue to connect to MySQL..
ZM is now installed on a Centos 6.6 minimal installl and all went fine. I have modified the /etc/zm.conf file as needed to connect to my MariaDB server running on a remote machine, started the services (httpd and zoneminder) but when I try to access
http://server-ip/zm I get
Unable to connect to ZM db.SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'centos-database' (13)
centos-database is essentially the VM running the MariaDB server.. All other VM's and services are able to access MariaDB perfectly.
/etc/zm.conf contains:
# Path to installed data directory, used mostly for finding DB upgrade scripts
ZM_PATH_DATA=/usr/share/zoneminder
# Path to ZoneMinder binaries
ZM_PATH_BIN=/usr/bin
# Path to ZoneMinder libraries (none at present, for future use)
ZM_PATH_LIB=/usr/lib64
# Path to ZoneMinder configuration (this file only at present)
ZM_PATH_CONF=/etc
# Path to ZoneMinder web files
ZM_PATH_WEB=/usr/share/zoneminder/www
# Path to ZoneMinder cgi files
ZM_PATH_CGI=/usr/libexec/zoneminder/cgi-bin
# Username and group that web daemon (httpd/apache) runs as
ZM_WEB_USER=apache
ZM_WEB_GROUP=apache
# ZoneMinder database type: so far only mysql is supported
ZM_DB_TYPE=mysql
# ZoneMinder database hostname or ip address
ZM_DB_HOST=centos-database
# ZoneMinder database name
ZM_DB_NAME=zm
# ZoneMinder database user
ZM_DB_USER=zoneminder
# ZoneMinder database password
ZM_DB_PASS=XXXXXXXXXXXXXXXXX
# Host of this machine
ZM_SERVER_HOST=
I have tried with the actual IP of the SQL server but its doing the same. I have checked that the user "zoneminder" has all rights to the zm database and its OK (anyways I would expect a access denied error if it were a permission issue at the SQL server level). The error I am getting indicates more of a connection issue.. I can also connect to the SQL server using the same credentials as in zm.conf from the CLI so this is not a connection issue between machines and its not a credential/permission issue ...
What would it be?
[b]EDIT: I have logged in the SQL server and looked at MariaDB's log and I see tons of similar error messages when I start or stop zoneminder service:
141116 16:03:50 [Warning] Aborted connection 2175 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2174 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2192 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2195 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2203 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2204 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2200 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2205 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2194 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:03:50 [Warning] Aborted connection 2193 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:04:20 [Warning] Aborted connection 2233 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:04:20 [Warning] Aborted connection 2234 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:04:20 [Warning] Aborted connection 2242 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)
141116 16:04:20 [Warning] Aborted connection 2243 to db: 'zm' user: 'zoneminder' host: 'centos-surveillance' (Unknown error)[/b]