ZM Viewers problem

[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???

[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.

[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?

[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.

[DREMA]

Yeah I have that port forwarded, but even on the local network I can't get iit to work.

Any other advice?

Thanks!

[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?

[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.

[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.

[jameswilson]

you will need to tell mysql to listen on ip.
comment out 'skip netowrking' in the my conf file

[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.

[caladeira]

Again, I'm using Intrepid.

Ok, but you have installed the "Ubuntu 8.10 Server" or "Ubuntu 8.10 Desktop"?

[DREMA]

Right, sorry, I'm using Intrepid Server 32bits.
Thanks

[DREMA]

Hi!
Happy holidays for everyone!
Anymore help with my little problem?
Thaanks!

[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.

[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.