Page 1 of 2

ZM Viewers problem

Posted: Fri Dec 12, 2008 2:43 am
by DREMA
Hello, I'm trying to use the zm4ms, zmviewer and oter to get a stream of my remote zm server, but I can't gei the to work. They ask me for a username and password, I had tried every password I have, varios zm users, zm admin, mysql root, but no one works, I always get "acces denied to DREMA@remoteserver.org".

I'm using zm 1.23 on Ubuntu intrepid.

Any help please??? :(

Posted: Sat Dec 13, 2008 3:58 pm
by caladeira
Hello!

The only password required are the mysql database password to access event data and a password for the zoneminder it self.

Usually, mysql username is "root" and the password is the one you have setup during installation.

The username/password for zone minder is the one you use in the html interface.

Recently I start using a new client: JZMC.
It is in the initial development, but already very usable.

Check out this post:
http://www.zoneminder.com/forums/viewtopic.php?t=12606

Hope it helped.
Regards.

Posted: Mon Dec 15, 2008 9:56 pm
by DREMA
Hi, thanks for your reply, I tried every user and password I have with no luck, I also commented out the line "bind network access only to: localhost", but I still can't connect.
Also tried de jzmc, but it doesnt accept my user/pass.
Any suggestion?

Posted: Tue Dec 16, 2008 10:13 pm
by caladeira
Well, it should be for shore related with access to mysql from a remote location.

Don't you have to open some ports in the router of the remote site for mysql?

As far as I've found, 3306 is the default mysql port.

Hope it helps.

Best regards.

Posted: Thu Dec 18, 2008 9:19 am
by DREMA
Yeah I have that port forwarded, but even on the local network I can't get iit to work.

Any other advice?

Thanks!

Posted: Thu Dec 18, 2008 10:51 pm
by caladeira
If you type on a server console "mysql -u root -p" and enter the password, can you see the mysql prompth "mysql>" or an error message?

And in other machine on the local network?

And in a remote machine?

Posted: Fri Dec 19, 2008 10:54 am
by DREMA
Hi Caladeira, thanks for your help!
Locally I can conect to the mysql server with no problem, but when I try to "mysql -h my mysqlserver.com -u root -p" I got "ERROR 1130 (00000): Host '189.xxx.xxx.xxx' is not allowed to connect to this MySQL server" so its clear for me that i cant get remote/localnetwork connection on this server, so how do I enable connections to my server?
I repeat, I'm using Ubuntu Intrepid32.

Thanks again.

Posted: Sun Dec 21, 2008 9:08 pm
by caladeira
Well, I'm not a mysql expert, not even close!

I think you should look your firewall settings and mysql configuration files.

You mention Ubuntu Intrepid, but which version Server or Desktop?
Some people use desktop versions for server work because of a more user friendly interface.

I think firewall have different settings where you are using Ubuntu Server or Desktop.

Hopefully, some mysql expert read this post and post some solution.

Best regards.

Posted: Sun Dec 21, 2008 9:59 pm
by jameswilson
you will need to tell mysql to listen on ip.
comment out 'skip netowrking' in the my conf file

Posted: Mon Dec 22, 2008 6:19 am
by DREMA
I don't have that line on my conf file, but I have "bind network access only to: localhost" commented out already.
Again, I'm using Intrepid.

Posted: Mon Dec 22, 2008 9:52 pm
by caladeira
DREMA wrote:Again, I'm using Intrepid.
Ok, but you have installed the "Ubuntu 8.10 Server" or "Ubuntu 8.10 Desktop"?

Posted: Tue Dec 23, 2008 5:12 pm
by DREMA
Right, sorry, I'm using Intrepid Server 32bits.
Thanks

Posted: Mon Dec 29, 2008 6:24 pm
by DREMA
Hi!
Happy holidays for everyone!
Anymore help with my little problem?
Thaanks!

Posted: Mon Dec 29, 2008 9:01 pm
by caladeira
Happy holidays to you!

I'm sorry, but I have no more ideas.

As soon as possible, I'll try to access my server from outside.
Then I'll post the results.

Best regards.

Posted: Tue Dec 30, 2008 9:15 am
by jbg70
The user accessing the database from outside needs the correct permission.
In mysql shell use:

Code: Select all

GRANT ALL on $_zm_database_name.* to $_your_username@'%' identified by '$_password';
Replace $_ with your real data.
The symbol % gives the user access from anywhere only on zm mysql database. If you have a static outside ip or a subnet you could also use it.

Regards.