PDA

View Full Version : Postgres 8-3 Instal Problem : Procedural language



Mojo
10-27-2009, 02:41 PM
hello,
HM bought a week ago and still trying to instal all that .... :D

By end of 2008 , i have installed Psql 8-2 and HM test version .. since no use !
Last week i have uninstalled all that to restart from zero and since .. no good results.

I have downloaded PSQL 8-3 and HM from your site
I have studied stickies and viewed videos
- UAC / ZoneAlarm / AVast / Windows Defender are off ( as my internet ... )
- when needed : psql : stopping service, deleting net user .
- Re-unstalling HM and PSQL

I launch postgresql-8.3.msi from unzipped folder and failed with a popup

" Failed to connect to the database. Procedural languages files are installed, but are not activated to any databases. " with a ok push-button.

... then process continues with other popup and so on until end of installation , with pqsl 8-3 service running but such way that all HM attempts to connect fail.

Here is the last lines of the log file at first popup time , maybe can help.

WriteRegistryValues: Key: \Software\PostgreSQL\Services\pgsql-8.3, Name: Product Code, Value: {B823632F-3B72-4514-8861-B961CE263224}
MSI (s) (90:E4) [14:36:44:796]: Executing op: RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\E ventLog\Application\pgAgent,,BinaryType=0,)
MSI (s) (90:E4) [14:36:44:796]: Executing op: RegAddValue(Name=EventMessageFile,Value=C:\Program Files\PostgreSQL\8.3\bin\pgaevent.dll,)
WriteRegistryValues: Key: \SYSTEM\CurrentControlSet\Services\EventLog\Applic ation\pgAgent, Name: EventMessageFile, Value: C:\Program Files\PostgreSQL\8.3\bin\pgaevent.dll
MSI (s) (90:E4) [14:36:44:998]: Executing op: RegOpenKey(Root=-2147483646,Key=Software\pgAdmin III,,BinaryType=0,)
MSI (s) (90:E4) [14:36:44:998]: Executing op: RegAddValue(Name=Helper Path,Value=C:\Program Files\PostgreSQL\8.3\bin\,)
WriteRegistryValues: Key: \Software\pgAdmin III, Name: Helper Path, Value: C:\Program Files\PostgreSQL\8.3\bin\
MSI (s) (90:E4) [14:36:45:061]: Executing op: RegOpenKey(Root=-2147483646,Key=SYSTEM\CurrentControlSet\Services\E ventLog\Application\PostgreSQL,,BinaryType=0,)
MSI (s) (90:E4) [14:36:45:061]: Executing op: RegAddValue(Name=EventMessageFile,Value=C:\Program Files\PostgreSQL\8.3\lib\pgevent.dll,)
WriteRegistryValues: Key: \SYSTEM\CurrentControlSet\Services\EventLog\Applic ation\PostgreSQL, Name: EventMessageFile, Value: C:\Program Files\PostgreSQL\8.3\lib\pgevent.dll
MSI (s) (90:E4) [14:36:45:092]: Executing op: ActionStart(Name=InstallServices,Description=Insta lling new services,Template=Service: [2])
Action 14:36:45: InstallServices. Installing new services
MSI (s) (90:E4) [14:36:45:092]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=130000 0)
MSI (s) (90:E4) [14:36:45:092]: Executing op: ServiceInstall(Name=pgsql-8.3,DisplayName=PostgreSQL Database Server 8.3,ImagePath="C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "C:\Program Files\PostgreSQL\8.3\data\",ServiceType=16,StartType=2,ErrorControl=32769,,,, StartName=.\postgres,Password=**********,Descripti on=PostgreSQL Database Server (postmaster))
MSI (s) (90:E4) [14:36:49:460]: Executing op: ActionStart(Name=StartServices,Description=Startin g services,Template=Service: [1])
Action 14:36:49: StartServices. Starting services
MSI (s) (90:E4) [14:36:49:460]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=130000 0)
MSI (s) (90:E4) [14:36:49:476]: Executing op: ServiceControl(,Name=pgsql-8.3,Action=1,Wait=1,)
StartServices: Service: PostgreSQL Database Server 8.3
MSI (s) (90:E4) [14:37:01:831]: Executing op: ActionStart(Name=InstallPl,Description=Activating procedural languages...,)
Action 14:37:01: InstallPl. Activating procedural languages...
MSI (s) (90:E4) [14:37:01:831]: Executing op: CustomActionSchedule(Action=InstallPl,ActionType=3 073,Source=BinaryData,Target=_InstallPl@4,CustomAc tionData=1033;postgres;postgrespass;5432;C:\Progra m Files\PostgreSQL\8.3\share\;1;;;;;;;)
MSI (s) (90:6C) [14:37:01:846]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI570D.tmp, Entrypoint: _InstallPl@4
MSI (c) (B8:E0) [14:37:22:126]: Note: 1: 2205 2: 3: Error
MSI (c) (B8:E0) [14:37:22:126]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2835
DEBUG: Error 2835: The control ErrorIcon was not found on dialog ErrorDlg
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2835. The arguments are: ErrorIcon, ErrorDlg,

Thanks

fozzy71
10-27-2009, 02:47 PM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the popup menu. Windows 7 you MUST set all the executables to always run as admin.

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

Mojo
10-27-2009, 05:18 PM
I have ( i think ) done as mentionned.

Postgresql 8.4 installed.
HM Installed.

When running HM , at CREATE NEW DATABASE time , i fail with popup =

DB CONTROL PANEL
" The following error occured when trying ton initialize the HM database.
ERROR 22023: le nouvel encodage ( SQL_ASCII ) est incompatible avec l'encodage de la base de donnees modèle ( UTF8 ).
"

What is wrong ?

Thanks

fozzy71
10-27-2009, 06:22 PM
Are you doing a backup/restore of a DB or is this a new DB?

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Mojo
10-28-2009, 06:16 AM
Hi , ( and thanks for help ! )

( For info , my OS is Vista Basic )

I don't mind datas from the past , ( and now not sure they are existing on my PC .... no DB appears on DB Control Panel ...)
so if i got them i will later filter and /or delete via HM ,
and if don't got them ....... that's fine .....

So now I :

- Have updated HM to latest beta
- Have created a new UTF DB ( no old DB existing , so can't be imported)
( must DBs be now always created as UTF-DB instead of SL-ASCII ? )

with only successful messages .....
( I was sure i was the best ............ thanks a lot ....... )

and will now try to import , for test , few hands in between the 9 months of hands history and ,if ok, will process the whole history by night.

Be sure i'll come back to you if any problem ....

Thanks again

fozzy71
10-28-2009, 12:21 PM
Yes, you should make any new DB's as UTF. If you are restoring an old .backup file, for a DB that was originally sqlascii, then you need to create an ascii DB using pgadmin, or it wont restore properly using the new default of UTF encoding.

Mojo
10-28-2009, 01:31 PM
Yoooooooooooooooooo !

- PSQL 8-4 Installed
- HM laste version + patch installed
- Stocked HH imported ( 80k 1h30 )

Now i have to learn how to use all that in a good way ....

Thanks a lot of.