please help sql problem

sergiut2002 · Post by **sergiut2002** » Mon Oct 29, 2007 10:39 am

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

sergiut2002 · Post by **sergiut2002** » Mon Oct 29, 2007 10:48 am

how can i reset the sql.. reinstall everything..
________
Spree

Lee Sharp · Post by **Lee Sharp** » Mon Oct 29, 2007 3:17 pm

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.

sergiut2002 · Post by **sergiut2002** » Tue Oct 30, 2007 7:22 am

ubuntu 7.04 desktop
________
Franco comotti

hushpuppy · Post by **hushpuppy** » Tue Oct 30, 2007 12:52 pm

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.

Lee Sharp · Post by **Lee Sharp** » Tue Oct 30, 2007 4:18 pm

Run Synaptic, and "Completely Remove" mysql and zoneminder. Then when you reinstall it will be totally clean.

sergiut2002 · Post by **sergiut2002** » Wed Nov 07, 2007 3:28 pm

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

and I had to reinstall the desktop

now it seems it works.

thanks every1.
________
VAPOR TOWER VAPORIZER