Credentials

[jcr639]

Hi.

The credentials for both of the accounts I access my Zoneminder web portal with have stopped working. I've reset the MySQL database passwords on both of these users and restarted ZM, but still no access. It's as if the passwords are incorrect, and I never get beyond the login window. The system has been working fine, up and running for months at a time, until yesterday.

I'm inexperienced with SQL, but I am looking now at checking the database and possibly repairing it. Any other thoughts or suggestions are greatly appreciated.

[jcr639]

Addendum:

I've run "mysqlcheck' on the zm database and everything shows OK. I've also tried creating a new user, and have the same result on the web portal.

I suppose if there are no suggestions, the next thing I will look at is upgrading Zoneminder, and (hopefully) preserving my settings, zones, etc.

[eh_ch]

Hmm, same problem here. My credentials still work on my android app "IPcamViewer" so I can see the streams and can verify that zm is running. I just have no access to the console.

I've restarted apache2, restarted zoneminder, rebooted, no dice.

Edit1: I've now also done the mysqlcheck --all-databses --auto-repair -u user -ppassword

Edit2: from http://www.zoneminder.com/forums/viewto ... cant+login,

I ran out of inodes even though there was plenty of disk space:

Code: Select all

root@ii:/var/cache/zoneminder/events/2/14/12# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1       106G  1.6G  100G   2% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
udev            2.0G  8.0K  2.0G   1% /dev
tmpfs           395M  1.4M  393M   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            2.0G     0  2.0G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/sdb1       2.7T  2.0T  583G  78% /var
root@ii:/var/cache/zoneminder/events/2/14/12# df -i
Filesystem        Inodes     IUsed   IFree IUse% Mounted on
/dev/sda1        7069696    103224 6966472    2% /
none              504673         2  504671    1% /sys/fs/cgroup
udev              501959       576  501383    1% /dev
tmpfs             504673       597  504076    1% /run
none              504673         3  504670    1% /run/lock
none              504673         6  504667    1% /run/shm
none              504673         2  504671    1% /run/user
/dev/sdb1      183148544 179552878 3595666   99% /var
root@ii:/var/cache/zoneminder/events/2/14/12#

and from there I went into /var/cache/zoneminder/events, chose a camera, and

Code: Select all

rm -r [i]oldest_or_least_significant_day[/i]

That was enough to get me into a console. In terms of long term fix, I will be setting the purge when full filter to run at 25% or 30% (currently at 20%) just long enough to ensure that I can archive what I want to save, before reformatting with more inodes.

I did not encounter this limitation until I jumped from 2TB to 3TB on my sdb1 mounted at /var. (4th HDD upgrade on this 7 year old Q6600 tank, btw!)

[bucsfan069]

I am having the same problem with inodes reaching 100%...I have a feeling this is the root cause of most of the issues I have been having with zoneminder...just out of suriosity what remedy is there to fix this problem? I see your post that you will be reformatting, what options will you be using to fix the inode issue? is there a prefered File System to alleviate this problem?

[Paranoid]

I am having the same problem with inodes reaching 100%...I have a feeling this is the root cause of most of the issues I have been having with zoneminder...just out of suriosity what remedy is there to fix this problem? I see your post that you will be reformatting, what options will you be using to fix the inode issue? is there a prefered File System to alleviate this problem?

Your inode size is probably 16k. Recreate the file system with a smaller inode size of 8k. You will lose everything in that filesystem when you recreate it so make sure anything essential is backed up.

Also, when you mount the filesystem make sure the "noatime" option is used.