1.28.109 setup problem

[BiloxiGeek]

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.

[BiloxiGeek]

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.

[bbunge]

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

bb

[BiloxiGeek]

SciLinux 7.1

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

[knight-of-ni]

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

[BiloxiGeek]

Yep, I got things working again.

[knight-of-ni]

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

[BiloxiGeek]

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.