Page 42 of 49

Error: Unable to connect to any of the mysql hosts

Posted: Wed Jun 18, 2008 5:15 pm
by KM
Hello
Somebody has already posted this previously, but I get the following error in configuring zm on Win XP:

-Unable to connect to any of the mysql hosts.
I have checked the username and password in both mysql and Viseon Viewer to be correctly set to 'zmuser' and 'zmpass'. I have granted all access to zmuser in mysql.

I have .NET 3.0 installed on my machine. The monitor settings are as follows:
Cam 1 IP/URL: 192.168.103.164
Port: <blank>
Site Names: <unchecked>
URL*: <unchecked>

Under 'Paths' tab:
Live view path: C:\Foundation\Apache2.2\cgi-bin\nph-zms (this was originally '/cgi-bin/nph-zms')
Playback path: C:\zm\events (this was originally '/zm/events/)

I have ZoneMinder running fine on my Linux box where the settings are slightly different:
Remote Host Name: root:math225c@192.168.103.164
Remote Host Path: /axis-cgi/jpg/image.cgi?resolution=640x480

I have used the above settings in my Win box but I get the same error.

Note that when I click the OK button on the above error message, an exception message pops up saying :

__________________________________________
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at ViseonViewer2.mysql.Button2_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.PerformClick()
at ViseonViewer2.Cam2.PlayBut_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ViseonViewer2
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Apps/2.0/QLTVPXCW.8XD/KYGHNAD2.MXT/vise..tion_0a282930b5e4c390_0001.0000_6f5da21aaa825d01/ViseonViewer2.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
MySql.Data
Assembly Version: 5.0.6.0
Win32 Version: 5.0.6.0
CodeBase: file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Apps/2.0/QLTVPXCW.8XD/KYGHNAD2.MXT/vise..tion_0a282930b5e4c390_0001.0000_6f5da21aaa825d01/MySql.Data.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system>
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
___________________________________________________



I know that theres something trivial thats going wrong in my settings here. I would be glad if someone could point it out.
Please excuse me if I am asking the same questions again, but after going through the forums, I still havent been able to get this working.

-KM

Posted: Wed Jun 18, 2008 10:35 pm
by jameswilson
Live view path: C:\Foundation\Apache2.2\cgi-bin\nph-zms (this was originally '/cgi-bin/nph-zms')
Playback path: C:\zm\events (this was originally '/zm/events/)
These are definelty wrong

The default paths are for the live cd, if you are using other distro then you may need to modify your path to suit. Its the url path to images on the zm server. If you post your full url to jpeg images we can work out a path statement for you.

James

Posted: Thu Jun 19, 2008 5:23 pm
by KM
The default paths are for the live cd, if you are using other distro then you may need to modify your path to suit. Its the url path to images on the zm server. If you post your full url to jpeg images we can work out a path statement for you.
I do not have an images folder on my Win box. In Linux, the '--with-webdir=<>' option allowed us to specify a web dir where the images directory was automatically created by ZM. Viseon Viewer does not ask for any such option, hence the images dir too hasnt been created by ZM. That is why I manually created an images folder in the apache web server dir and gave this path to ZM.

Isnt ZM supposed to create a zm and cg-bin dir on its own on installation , the way it does on Linux ?

-KM

Posted: Thu Jun 19, 2008 10:37 pm
by jameswilson
Is your zm installation working fully without zm?

zm4ms is purly an interface, it takes all the images and db etc from the zm server.
Trust me... i do know lol.
It will try and get images from for example

http://10.0.0.1/zm/nph-zms?blah blah balh.

Not C: anything.

Its the path statement that will need to be altere to suit your install. As i said its default settings are designed for the live cd. If your not using the live this will need to be modified to match your web directory strubcture on your zm box.

Just thought. Your not trying to use zm4ms as a full app, ie recorder etc without a linux zm?

James

Posted: Thu Jun 19, 2008 10:48 pm
by KM
Just thought. Your not trying to use zm4ms as a full app, ie recorder etc without a linux zm?
There it goes. I thought zm4ms was an independent application. No wonder I was trying to look for a server installation on my Win machine without any success. Thought I had missed some setup or something.

Thanks for your help.

Posted: Thu Jun 19, 2008 10:53 pm
by jameswilson
no problem
glad we got to the bottom of it!

Errors when cycling camera or watching full-screen

Posted: Wed Jul 02, 2008 10:31 pm
by Beofres
Hello!

Been using the viewer for awhile now, but it appears to be very...buggy at times. I'm trying to cycle 3 cameras and once it reaches the third camera I get an error message. It happens on a windows 2000 computer and on a windows xp box.

Code: Select all

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Conversion from string "" to type 'Integer' is not valid. ---> System.FormatException: Input string was not in a correct format.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
   --- End of inner exception stack trace ---
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
   at ViseonViewer2.sequenceView.Timer2_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ViseonViewer2
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Apps/2.0/67JD3882.A89/VJ0MZK7E.CHO/vise..tion_0a282930b5e4c390_0001.0000_3fb34866ca7eae65/ViseonViewer2.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

I also get this occasionally when in full screen:

Code: Select all

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Conversion from string "" to type 'Integer' is not valid. ---> System.FormatException: Input string was not in a correct format.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat)
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
   --- End of inner exception stack trace ---
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)
   at ViseonViewer2.dualHead.Timer2_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ViseonViewer2
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Documents%20and%20Settings/Administrator/Local%20Settings/Apps/2.0/GDW45X38.13R/BYP1OQED.8J1/vise..tion_0a282930b5e4c390_0001.0000_65e9c797a89fee3f/ViseonViewer2.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


Other than that, this application has great potential and I love it when it does work!

Thanks,

-Beofres

Posted: Sun Jul 06, 2008 5:01 pm
by socsuser
jameswilson wrote: It will try and get images from for example

http://10.0.0.1/zm/nph-zms?blah blah balh.
James
Hi James, in my situation, for viewing a monitor the URL is:
http://zoneminder/zm/index.php?view=watch&mid=1

Now, this is quite different than your nph-zms controller that is listed above as it is using index.php and I can't help but figure that I'm missing something. Where can I find the proper URL for zm4ms?

Also, regarding each of the fields in the settings window, what should they be following the IP/URL? Such as Port, MON (assume Monitor Number?), Cam. Desc. is obvious, but what of Site Names (Enabled Checkbox)? Then there is the URL checkbox at the end as well, which is enigmatic to a degree... I've got it checked since I'm giving it a URL, but I'm getting a red X icon in the center of each camera image.

Then also, under the Playback tab, what should actually go here? It's not asking for an ip or hostname of the mysql server...

Seems that I'm missing some sort of critical instructions as I've not been able to find anything completely clear-cut or indicative here on the ZM Forums.

[EDIT]
Continuing on, I did find `/usr/share/zoneminder/cgi-bin/nph-zms`. What is to be done regarding these? It appears that this is found in the config as ZM_PATH_ZMS and is the streaming server and nph has to do with non-parsed header, however, what is to be done regarding this and passing it proper parameters, etc?

Posted: Sun Jul 06, 2008 9:15 pm
by jameswilson
your path is wrong, that is the page path not the image path. When viewing if you select stills, then right click on the resulting image and view its properties this will give you your image path.

URL checkboxes are for 'URL MODE'. This uses the ip/url box as the whole setting so you can enter any valid jpeg url here and can be used for non zm purposes, webcams, weather cams etc.

Site names are used when using zm4ms to monitor several sites and the cam name will alternate with the site name. Thats all that does.

Playback, as zm4ms can request data from mutiple machines it assumes the ip address of the monitor you wish to view.

Posted: Sun Jul 06, 2008 9:16 pm
by jameswilson
re the bug above, i havnt been able to replicate this, but if i do recall a similar issue many months ago. Can you create both custom views and see if this helps.
Will help me track it down, also if you know how to replicate it everytime this will help

I couldn't see

Posted: Fri Aug 01, 2008 10:14 pm
by nux
dear james,

first of all, thanks for your extraordinary work !

I have a zm working on one pc with only one monitor all is working ok

My setting in zm4ms in other machine are:

Paths:

Live View Path : http://ip_number_zm/cgi-bin/nph-zms
Data Type , http://ip_number_zm/cgi-bin/nph-zms
Playback Path http://ip_number_zm/zm/events

the paths are OK I verified from the zm4ms machine and others

but I couldn't see anything :-(

can you help me ?

thanks !

Posted: Sat Aug 02, 2008 6:48 am
by jameswilson
the paths shouldnt be changed and if so need to reflect the values for your zm server, ie if you have changed the directory structure.

To test use url mode on cam1 and past the full single url into the ip box.

ie connect to your zm box and view the non stream jpeg image, right click on the image to find its url and paste that into zm4ms.

Also disable auth on the zm box while you set it up.

thanks

Posted: Sat Aug 02, 2008 2:21 pm
by nux
yes !! it works !

thanks !

Posted: Tue Aug 05, 2008 4:30 pm
by nux
I am sure that I am making something in a bad way :-(

When I copied the url from image in the machine running zm, in the viewer I can only see the picture with a very slow refresh , I need to clic in a little blue rectnagle to have a stream.
i want to have stream when I open the application , without needing to click in anyplace

the url that I am using is like this:

http://nro_ip_zoneminder/cgi-bin/nph-zms?mode=single&monitor=2

can you help me ?

thanks !

Posted: Thu Aug 07, 2008 8:33 am
by jameswilson
you need to increase you refresh speed in the options.
Also using url mode isnt the best way.
Once your running put you path statement back to default and enter the ip only in the ip box.

If your running on port 80 leave the port blank, if not enter the port with a colon ie :82