Page 1 of 1

please help sql problem

Posted: Mon Oct 29, 2007 10:39 am
by sergiut2002
Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) failed: Access denied for user 'zmuser'@'localhost' (using password: YES) at /usr/share/perl5/ZoneMinder/Config.pm line 89
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 91.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 45.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 45.
failure

invoke-rc.d: initscript zoneminder, action "start" failed.
dpkg: error processing zoneminder (--install):
subprocess post-installation script returned error exit status 255
Errors were encountered while processing:
zoneminder


i really don`t know what to set,. i get this error when i try to run sudo dpkg -i zoneminder_1.22.3-8_i386.deb

I don`t know anything about mysql. As far as i can see it`s a problem with access to zm datagbase. But i don`t know how to give access toit
________
VAPIR NO2

a

Posted: Mon Oct 29, 2007 10:48 am
by sergiut2002
how can i reset the sql.. reinstall everything..
________
Spree

Posted: Mon Oct 29, 2007 3:17 pm
by Lee Sharp
That depends on what distribution you are on and how you installed mysql. But you can go in with a mysql admin tool and delete the zm database, then recreate it.

re

Posted: Tue Oct 30, 2007 7:22 am
by sergiut2002
ubuntu 7.04 desktop
________
Franco comotti

Posted: Tue Oct 30, 2007 12:52 pm
by hushpuppy
I'm not sure if ubuntu has a mysql gui, but my live cd does.

You should/could be able to simply boot my cd, copy the /opt/mysql-gui-tools-5.0 to /opt on your hard disk, then reboot and use the binaries in the above directory.

http://www.doubleburgerbar.com/watchdog to download.

Alternativley you could mount the squashfs on the live cd and run directly from there, let me know if you want to know how to mount a sfs file.

Posted: Tue Oct 30, 2007 4:18 pm
by Lee Sharp
Run Synaptic, and "Completely Remove" mysql and zoneminder. Then when you reinstall it will be totally clean.

Posted: Wed Nov 07, 2007 3:28 pm
by sergiut2002
Lee Sharp wrote:Run Synaptic, and "Completely Remove" mysql and zoneminder. Then when you reinstall it will be totally clean.
thanks... last time i removed with synaptic i removed also some other stuff and couldn`t boot into ubuntu again :P and I had to reinstall the desktop

now it seems it works.

thanks every1.
________
VAPOR TOWER VAPORIZER