PDA

View Full Version : Error with PostrgreSQL.



Boglord
09-22-2008, 01:53 AM
I've had PostrgreSQL installed when I tried out PT3, but once I installed Holdem Manager it did not work.

I proceeded to uninstall it and deleted the remaining files in Program Files.

I'm now on my third install and I get the same error which I'll try to show below.

NOTE: I have disabled the User Control thingie (using Vista, SP2).

First, when I install Postgre I am not allowed to use the username Postgre so I proceed to use the one from the readme, which is Postgreuser.

Everything else works fine there.

Once I start Holdem Manager up, I am redirected to the Database Control Panel.

Once here, I see the following:

Server Name: 127.0.0.1
Port: 5432
Loginname: postgresuser
Password: postgrespass

I proceed and click Connect.

First error comes up saying:

"The username and/or password was incorrect. Would you like to have Holdem Manager configure the database to accept this login and password?"

I click ok.

And now I get the error that I'm always stuck on.

"Connection Error: Fatal: 3D000: database: "postgresuser" does not exist"

Now I've created this username (or so I think)...

What can I do to get it to work?

morny
09-22-2008, 09:34 AM
Uninstall and reinstall postgreSQL and use a different username, sometimes they take exception to certain keywords in names so that might be causing the problem. If you dont have any previous SQL databases also delete the PostgreSQL folder located at c:\Program Files after you uninstall via Add & Remove Programs in the control panel and before you reinstall postgrSQL

Boglord
09-22-2008, 10:03 AM
I've done the above, used a completely different username/pass and I get the same errors (I also deleted all the folders).

morny
09-22-2008, 01:39 PM
Which version of PostgreSQL are you installing?

Maybe email me morny@holdemmanager.net and we can do a www.teamviewer.com session

Boglord
09-22-2008, 03:11 PM
I am using the latest one, which is 8.3 I believe.

I know the tutorial shows the installation for 8.2.

Boglord
09-22-2008, 03:39 PM
I think I managed to get it to work for now.

Boglord
09-22-2008, 05:31 PM
Now that I got it somewhat working I keep getting an error.

Here is a copy of it.

This error prevents me from accessing some tabs at times (such as hands, sessions, etc).



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

************** Exception Text **************
System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.ReadByte()
at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnu merable`1 ienum)
at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnecto r context)
at Npgsql.NpgsqlConnector.Open()
at Npgsql.NpgsqlConnectorPool.GetPooledConnector(Npgs qlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorI nternal(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestPooledConnector( NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestConnector(Npgsql Connection Connection)
at Npgsql.NpgsqlConnection.Open()
at HoldemManager.Ә.ஂ(Int32 Ձ)
at HoldemManager.ଣ.෩(Object ՚, EventArgs ՛)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at DevComponents.DotNetBar.Office2007RibbonForm.OnLoa d(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ContainerControl.WndProc(Mess age& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at DevComponents.DotNetBar.Office2007RibbonForm.WndPr oc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(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.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.6.0.0
Win32 Version: 1.6.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 7.5.0.1
Win32 Version: 7.5.0.1
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
HMClass
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HMClass.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.1.2000.0
Win32 Version: 3.1.2000.19212
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.5.0
Win32 Version: 2.0.5.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.8
Win32 Version: 1.0.0.8
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 1.98.4.0
Win32 Version: 1.98.4.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1434 (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.1434 (REDBITS.050727-1400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Mono.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.1.0.621
Win32 Version: 5.1.0.621
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/ZedGraph.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.
-------------------------------------------

Main error looks like this (I click on details to get what you have above).


-------------------------------------------
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
-------------------------------------------

morny
09-22-2008, 05:38 PM
This is usually to do with firewalls and antiviruses causing problems with PostgreSQL and the database making a connection.

This temporary measure usually works http://208.109.95.123/faq/afmviewfaq.aspx?faqid=34 and also makes sure you have the newest version http://www.holdemmanager.com/downloads/HmUpdate1.06.03h.exe

Less likely to help but might be worth a try http://208.109.95.123/faq/afmviewfaq.aspx?faqid=153

But its more than likely your antivirus/firewall causing the intermitting problem