Page 1 of 1

No pictures shown, mysql problem?

Posted: Wed Mar 15, 2006 9:16 pm
by Zombie
Hi all!
I have just installed zoneminder in a fedora 3. Compiled and up and running but there is no pictures shown. Maybe it is something about the mysql because the pictures in the folder IMAGES are like 'core.6648' and 863MB large.

There is only root@myhost in user() in the database mysql. I have to admit mysql is not my profession at all. I may have messed up the registration of my user beo@localhost at the beginning. When i try this:

mysql> insert into user (Host,User,Password)
-> values('localhost','beo','YES');
ERROR 1062: Duplicate entry 'localhost-beo' for key 1

I also tried this:

mysql> insert into user (Host,User,Password)
-> values('%','beo',PASSWORD('YES'));
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
file:///home/beo/IVC/zoneminder_1.22.0/ZoneMinder-1.22.0/README.html
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

How can i remove all the mess i have made, like the databases and users and start all aver again?

Posted: Wed Mar 15, 2006 9:34 pm
by wmoore
i thnk something like:

# mysql mysql
mysql> drop database 'zm';

should be close. Then just begin again as per install directions.

-WAM

Posted: Wed Mar 15, 2006 11:10 pm
by zoneminder
Also using the 'grant' statement is easier than manually inserting rows into the user and db tables.

Thanks for your replys

Posted: Fri Mar 17, 2006 10:15 pm
by Zombie
Yes, as far as my limited skills in Mysql (even with a book), i have now the database working, after removing (drop) and a new install.

But i still have no pictures and can not remove any cameras.. so i checked 3 log files.
___________
zmdc.log
___________

03/17/06 22:49:57.538980 zmdc[7893].INF ['zmc -d /dev/video0' started at 06/03/17 22:49:57]
03/17/06 22:49:57.543987 zmdc[7303].INF ['zmc -d /dev/video0' starting at 06/03/17 22:49:57, pid = 7893]
03/17/06 22:49:57.688456 zmdc[7303].ERR ['zmc -d /dev/video0' crashed, exit status 255]
___________
zmdc.log:
___________

03/13/06 23:31:11.026210 zmdc[20586].INF [Starting pending process, zmc -d /dev/video]
03/13/06 23:31:11.029056 zmdc[20644].INF ['zmc -d /dev/video' started at 06/03/13 23:31:11]
03/13/06 23:31:11.038146 zmdc[20586].INF ['zmc -d /dev/video' starting at 06/03/13 23:31:11, pid = 20644]
03/13/06 23:31:11.081750 zmdc[20586].ERR ['zma -m 1' crashed, exit status 255]
03/13/06 23:31:11.108126 zmdc[20586].ERR ['zmc -d /dev/video' crashed, exit status 255]
----------------
zmwatch.log
----------------

03/17/06 08:00:41.348591 zmwatch[1673].ERR [Can't get shared memory id '7a6d2001', 1: No such file or directory]
(comment: that is the key in the option in system tab "ZM_SHM_KEY". I guess it has been set by default to that number and shouldn't change it?)
03/17/06 08:00:41.349194 zmwatch[1673].INF [Restarting capture daemon for Composite2, shared memory not valid]
03/17/06 08:00:41.747258 zmwatch[1673].INF ['zmc -d /dev/video' started at 06/03/17 08:00:41] at /usr/local/bin/zmwatch.pl line 118
___________
so i have problem with my key, memory or the driver. I have checked with "effectv" and it shows video without problem so my bttv.o is working.
Can it be a user (righs?) problem? Must the application be started as su?
Does anyone have any creative ideas?

I will answer myself...

Posted: Fri Mar 17, 2006 11:21 pm
by Zombie
One step further...

I have found that everything must be done as su. Even Firefox has to be started as su.
Okay ,a while ago i saw a black squares and sometimes a white square. After some adjustments of brightness and contrast, i nearly got a picture. But it is purple with some movements in it. 320x240 and YUV422 is the best bid right now.
I have to find a way to see the format from the driver. Any ideas?

/Berndt

Posted: Sat Mar 18, 2006 12:10 am
by Zombie
:D YEEEESSSS!

It is Working now. Camera setting 320x240 and RGB555 (never used that before...)
6 wireless cameras online and woooow. This is a wonderful tool. 6 weeks of healty learning ended up now with great reults.

I hope somebody can get some help out of my amature problems and even more cryptical answers to myself... :lol:

Thanks all for your support.

Posted: Sat Mar 18, 2006 12:29 am
by jameswilson
no thankyou for haring your answers back on here. Im sure it will to useful to many people.

glad your zming