ZoneMinder Forums

Posted: **Thu Nov 19, 2015 11:50 am**

Well I managed to screw up my update to 1.28.109 yesterday. Wasn't paying attention and went through the "New Installs" instructions instead of the "Upgrades" instruction. So I get to rebuild the whole setup now. Trying to get one monitor setup and I think I have the configuration correct but whenever I try to view the live stream I get a stream of errors in ssl_error_log and no video, here's a small sample.

Code: Select all

[Thu Nov 19 05:37:34.731084 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539a5d000-7f7539a60000 rw-p 00131000 fd:00 41951558                   /usr/lib64/libgnutls.so.28.41.0, 
[Thu Nov 19 05:37:34.731102 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539a60000-7f7539abf000 r-xp 00000000 fd:00 41951854                   /usr/lib64/libpcre.so.1.2.0,
[Thu Nov 19 05:37:34.731123 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539abf000-7f7539cbf000 ---p 0005f000 fd:00 41951854                   /usr/lib64/libpcre.so.1.2.0, 
[Thu Nov 19 05:37:34.731141 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539cbf000-7f7539cc0000 r--p 0005f000 fd:00 41951854                   /usr/lib64/libpcre.so.1.2.0,
[Thu Nov 19 05:37:34.731162 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539cc0000-7f7539cc1000 rw-p 00060000 fd:00 41951854                   /usr/lib64/libpcre.so.1.2.0, 
[Thu Nov 19 05:37:34.731182 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539cc1000-7f7539cd7000 r-xp 00000000 fd:00 42145811                   /usr/lib64/libpthread-2.17.so,
[Thu Nov 19 05:37:34.731201 2015] [cgi:error] [pid 20238] [client <IP ADDR>:43266] AH01215: 7f7539cd7000-7f7539ed7000 ---p 00016000 fd:00 42145811                   /usr/lib64/libpthread-2.17.so,

There's a boat load more libraries referenced in the stream of errors, hard to tell if any are more significant than others. I did set the monitor to Record mode, let it run like that for a bit and then set it back to Monitor. I could view individual frames and watch the event so I know the server is talking to the camera as expected. But the live view doesn't work so far.

Posted: **Thu Nov 19, 2015 12:15 pm**

Think I found the problem. Tried to run "curl -k -XGET https://localhost/zm/api/monitors.json" and I get an error back:

Code: Select all

{
    "success": false,
    "data": {
        "code": 500,
        "name": "Database connection "Mysql" is missing, or could not be created.",
        "message": "SQLSTATE[28000] [1045] Access denied for user 'zmuser'@'localhost' (using password: YES)",
        "url": "\/zm\/api\/monitors.json",
        "exception": {
            "class": "MissingConnectionException",
            "code": 500,
            "message": "Database connection \"Mysql\" is missing, or could not be created.",
            "trace": [
                "#0 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Datasource\/DboSource.php(260): Mysql->connect()",
                "#1 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/ConnectionManager.php(105): DboSource->__construct(Array)",
                "#2 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Model.php(3479): ConnectionManager::getDataSource('default')",
                "#3 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Model.php(1128): Model->setDataSource('default')",
                "#4 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Model.php(3501): Model->setSource('Config')",
                "#5 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Model.php(2905): Model->getDataSource()",
                "#6 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Model\/Model.php(2877): Model->_readDataSource('first', Array)",
                "#7 \/usr\/share\/zoneminder\/www\/api\/app\/Controller\/AppController.php(62): Model->find('first', Array)",
                "#8 [internal function]: AppController->beforeFilter(Object(CakeEvent))",
                "#9 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Event\/CakeEventManager.php(244): call_user_func(Array, Object(CakeEvent))",
                "#10 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Controller\/Controller.php(674): CakeEventManager->dispatch(Object(CakeEvent))",
                "#11 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Routing\/Dispatcher.php(187): Controller->startupProcess()",
                "#12 \/usr\/share\/zoneminder\/www\/api\/lib\/Cake\/Routing\/Dispatcher.php(165): Dispatcher->_invoke(Object(MonitorsController), Object(CakeRequest))",
                "#13 \/usr\/share\/zoneminder\/www\/api\/app\/webroot\/index.php(108): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))",
                "#14 {main}"
            ]
        },
        "queryLog": [

        ]
    }
}

I double checked /etc/zm/zm.conf and the username and password are setup correctly there. So why would it not be able to connect to the database? I'm starting to think I might just dump all the db stuff, get it back to a fresh install state and go from there.

Posted: **Thu Nov 19, 2015 1:08 pm**

Which Linux distro are you using? Sounds like Ubuntu? Which upgrade instructions?

bb

Posted: **Thu Nov 19, 2015 1:15 pm**

SciLinux 7.1

I used the README.Centos7 file under /usr/share/doc/zoneminder-1.28.109/

Posted: **Thu Nov 19, 2015 3:35 pm**

You already learned the answer to this previsouly:
viewtopic.php?f=32&t=23665

Posted: **Thu Nov 19, 2015 3:42 pm**

Yep, I got things working again.

Posted: **Thu Nov 19, 2015 3:54 pm**

Excellent.
Will add a reminder to the Fedora/CentOS Readme's to avoid this in the future.

Posted: **Thu Nov 19, 2015 4:04 pm**

One suggestion... In the README.Centos7 (and probably the other README's) move the upgrade instructions up above the New Install instructions.

Justification: Running through upgrade steps on a new install won't break anything since there's nothing setup to break yet. But running New Install steps on an existing setup will break most all of it.

ZoneMinder Forums

1.28.109 setup problem

1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem

Re: 1.28.109 setup problem