Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[vtverdohleb]

is possibile create a new zm database with zm_create.sql, with removing the zm dabase old?
Or sql database file to be imported with phpMyAdmin?

You can import with phpmyadmin

[texas_72]

Hi
I solved it by recreating the db zm with the command "mysql mysql < db/zm_create.sql" using SSH.

[freeman74]

Hi
I solved it by recreating the db zm with the command "mysql mysql < db/zm_create.sql" using SSH.

Hi,

I have the same problem and errors but if I try to create manually (or import through Myphp) the database the situation doesn't change because the script zm_create.sql isn't complete... I believe that the sql command for table creations are missing.

Below the content from zm_create.sql. can someone give me the full script?

thank you
freeman

-- MySQL dump 10.13  Distrib 5.1.36, for unknown-linux-gnueabi (arm)
--
-- Host: localhost    Database: zm
-- ------------------------------------------------------
-- Server version   5.1.56

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

[freeman74]

Hi
I solved it by recreating the db zm with the command "mysql mysql < db/zm_create.sql" using SSH.

Hi,

I have the same problem and errors but if I try to create manually (or import through Myphp) the database the situation doesn't change because the script zm_create.sql isn't complete... I believe that the sql command for table creations are missing.

Below the content from zm_create.sql. can someone give me the full script?

thank you
freeman

-- MySQL dump 10.13  Distrib 5.1.36, for unknown-linux-gnueabi (arm)
--
-- Host: localhost    Database: zm
-- ------------------------------------------------------
-- Server version   5.1.56

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Hi,

I've restored original settings, installed again ssh also perl and zoneminder. In this case the zm db is created (with the previous temptative not) but is empty (no tables inside). I tried with mysql mysql < db/zm_create.sql command through ssh but I'm getting this error: "-sh: db/zm_create.sql: No such file or directory".

The content of zm_create.sql is the same of previous post.

someone can help me?

thank you
freeman

[vtverdohleb]

I've restored original settings, installed again ssh also perl and zoneminder. In this case the zm db is created (with the previous temptative not) but is empty (no tables inside). I tried with mysql mysql < db/zm_create.sql command through ssh but I'm getting this error: "-sh: db/zm_create.sql: No such file or directory".

mysql --user=zm --password=vf4n9nhoe9c458959nvt < /mnt/HD/HD_a2/Nas_Prog/ZoneMinder/share/zoneminder/db/zm_create.sql

[freeman74]

I've restored original settings, installed again ssh also perl and zoneminder. In this case the zm db is created (with the previous temptative not) but is empty (no tables inside). I tried with mysql mysql < db/zm_create.sql command through ssh but I'm getting this error: "-sh: db/zm_create.sql: No such file or directory".

mysql --user=zm --password=vf4n9nhoe9c458959nvt < /mnt/HD/HD_a2/Nas_Prog/ZoneMinder/share/zoneminder/db/zm_create.sql

thank you for the support, but the zm db is always empty after this command, no tables inside. 

I

[vtverdohleb]

thank you for the support, but the zm db is always empty after this command, no tables inside. 

zm_create.sql

[freeman74]

thank you for the support, but the zm db is always empty after this command, no tables inside. 

zm_create.sql

Thank you! Now everything is OK! 

[philphil61]

Don't know what I did wrong
Tried Zoneminder to setup my IP camera which is 720 - Zoneminder has been running but no cam connected for almost 24hrs
I'm having difficulty trying to connect/setup cam when I finally figure out some sort of image I change the resolutions from 360 x 480 to 1280 x 720

and then the nightmare begins - 320L locks up - can't access, won't power off but all lights normal
After several hours and 30+ attemtps, including trying reset to factory, I finally fixed it by accessing the webgui as soon as possible then going to addons and stopping Zoneminder

Now I've repeatedly acknowledged that what I know about PC's is self taught, no qualifications, and in some areas it's basic knowledge but wtf
This 320L is my first and last DLink product - It should be relatively easy to buy any network device and use it with any other network device but not if you have a DLink product.

All I want to do is setup an HD IP Cam so I can fix it outside and record to my NAS any "notifications" because my NAS is the only device powered on 24/7 but because my NAS is a DLink NAS and my IP cam isn't I hit many (too many) hurdles and walls.  Why is it so difficult?

Can't wait for my 320L to die then I'll have a real excuse to spend hard earned money on something worthy.

[allenc2013]

I have a 320L too, and after installing Zoneminder, the system has became very unresponsive.

It is a bit strange as at time, it will be responsive, but the it stopped responding.  CPU is fluatating wildly between 100% and 30-40%.

[sanatic]

Hello I'm having the problem Could not select database: Unknown database 'zm'. I have 1 dlink 320L. how to solve the problem?

[vtverdohleb]

NAS reboot. After reboot to reinstall the add-on.

[sanatic]

Hello, I have a d-link DNS-320L to install ZoneMinder, pops up this error - Could not select database: Unknown database 'zm', can anyone help

[sanatic]

Is there any tutorial how to configured the camera in ZoneMinder