PDA

View Full Version : HEM needs to know where to find database??



MoreEV
03-03-2011, 05:45 PM
Hi Guys,i have just downloaded the trial version of HEM and am already having problems

Server name:
Port number
Loginname
Password

i did try postgrespass and dbass doesnt seem to make a big D

Sarek
03-03-2011, 06:52 PM
do you had PostgreSQL installed before?
port (default) is 5432 - but possibly 5433
user = postgres
run PGadmin and see
try this passw = postgres

MoreEV
03-03-2011, 06:55 PM
i have been using PT3 for the past year but am not happy with them anymore,so i know that i already have a SQL

Sarek
03-03-2011, 06:58 PM
default PT passw for Postgre is
dbpass
also try svcpass

and:
Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
Scroll to the bottom and change all md5 to trust. Save and close the file.
Move the file back to the data folder.
Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services
HM will accept any password now.

MoreEV
03-03-2011, 07:00 PM
do you had PostgreSQL installed before?
port (default) is 5432 - but possibly 5433
user = postgres
run PGadmin and see
try this passw = postgres

runpgadmin?????

Sarek
03-03-2011, 07:04 PM
please read this - how to run PGadmin
http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

MoreEV
03-03-2011, 07:06 PM
ok password worked but then there isnt any database,it did ask me to create one database (which i did) then when i open HEM i get this message:

Unhandled exception has occured in your application.if you click continue,the app will ignore this error and attempt to continue.if you click Quit,the app will close immediatly.
invalid access to memory location.(exception from HRESULT:0x800703E6)
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.BadImageFormatException: Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
at i.b7(Object A_0, EventArgs A_1)
at cl.b(Object A_0, EventArgs A_1)
at DevComponents.AdvTree.AdvTree.OnSelectionChanged(E ventArgs e)
at DevComponents.AdvTree.AdvTree.SelectNode(Node node, eTreeAction action)
at DevComponents.AdvTree.AdvTree.ر(Node ؋, MouseEventArgs ؗ, Point ء)
at DevComponents.AdvTree.AdvTree.OnMouseDown(MouseEve ntArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& 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.3603 (GDR.050727-3600)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.11.5.3537
Win32 Version: 1.11.05.3537
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 8.3.0.0
Win32 Version: 8.3.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.2.2000.0
Win32 Version: 3.2.2000.3813
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3074 (QFE.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1453 built by: NetFX
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1453 built by: NetFX
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.13.0
Win32 Version: 2.0.13.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.17
Win32 Version: 1.0.0.17
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 2.0.6.0
Win32 Version: 2.0.6.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.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
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.4.31904
Win32 Version: 5.1.4.31904
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/ZedGraph.DLL
----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1500 built by: QFE
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
SitNGoWizard.1.1
Assembly Version: 1.0.2.20
Win32 Version: 1.0.2.020
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/SitNGoWizard.1.1.EXE
----------------------------------------
SitNGoWizard.Localization.2.0
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/SitNGoWizard.Localization.2.0.DLL
----------------------------------------
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/log4net.DLL
----------------------------------------
HoldemVision
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemVision.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>

Sarek
03-03-2011, 07:13 PM
Please make sure that your windows is uptodate, all service packs and windows updates installed.
Uninstall your current NetFramework version with this tool: http://rvgsoftware.fileburst.com/dotnetfx_cleanup_tool.zip
and download the "big" installer (230 MB)
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe
and run it

MoreEV
03-03-2011, 07:16 PM
Will i be able to use hand the hands i ve played before with PT3?

Sarek
03-03-2011, 07:22 PM
PT3 moves all original HHs after autoimport in it's archive
default path is "Processed" folder in PT folder
you can import HHs from there in HM database (use Import from folder button)

MoreEV
03-03-2011, 07:45 PM
i m still getting the same message

unhandled exception blablabla

MoreEV
03-03-2011, 08:34 PM
when i m on the PostgreSQL setting page,there is no database,what should i do?

click on export hands?

MoreEV
03-03-2011, 09:02 PM
i might stick with PT3,this is very annoying

Patvs
03-04-2011, 12:21 AM
Manually run a Windows Update.
Install all updates, especially all .net framework updates. AND reboot.

Which Operating System, Firewall, and Anti-Virus are you using?

--


Which SQL version are you using now? (installed by PT3) SQL 8.3?
Open dbcontrolpanel.exe in the HoldemManager forum. Connect to SQL--> create a new empty database--> set it as default--> start HoldemManager.

MoreEV
03-04-2011, 06:15 AM
http://www.moreev.com/wp-content/uploads/2011/01/error-message.jpg

MoreEV
03-04-2011, 06:16 AM
i have done everything i ve been told but am always getting the same thing :-(

MoreEV
03-04-2011, 07:27 AM
i m using firefox
SQL 8.3
AVG+comodo

Patvs
03-04-2011, 06:42 PM
Uninstall Comodo.

Update SQL to 8.4.7 (or 9.0.3) and install it to port 5433.

Did you ran a manual Windows Update? There were no .net framework updates you could install?

MoreEV
03-05-2011, 04:55 AM
i m trying to setup SQl 8.4.7 but it is asking me for my password
i ve tried postgress,dbpass but nothing works

i might have changed the password years ago when i installed my SQL with PT,what should i do now?

MoreEV
03-05-2011, 08:12 AM
Uninstall Comodo.

Update SQL to 8.4.7 (or 9.0.3) and install it to port 5433.

Did you ran a manual Windows Update? There were no .net framework updates you could install?

i uninstalled comodo

updated .net framework
but cant install 8.4.7 cause they asked me for a password

MoreEV
03-05-2011, 09:53 AM
should i uninstall SQL 8.3?

if i do that ,will i lose all my data?will i stll be able to use PT3?

Patvs
03-05-2011, 02:55 PM
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL. (and it will accept ANY password)

---

If you install SQL 8.4 to port 5433... you can just leave SQL 8.3 running on port 5432 (containing your PT3 database). SQL 8.3 and 8.4 can "co-exist" side by side if they're on separate ports.

MoreEV
03-06-2011, 11:54 AM
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL. (and it will accept ANY password)

---

If you install SQL 8.4 to port 5433... you can just leave SQL 8.3 running on port 5432 (containing your PT3 database). SQL 8.3 and 8.4 can "co-exist" side by side if they're on separate ports.

it s still asking me for a password :-(

never thought getting HEM would be such a pain

Sarek
03-06-2011, 05:26 PM
if it saks password - this means you did not deleted user
open CMD and type there
net user
amd press Enter
this gives you list of all PC users

MoreEV
03-07-2011, 06:43 PM
Too much headache,still not working,i ve tried everything

I ll have to stick with PT3,thanks for ur help anyway