PDA

View Full Version : Pls help~ on postgre thanks alot



poker_limit
05-29-2010, 09:47 AM
My pc suddenly cannot log on to the postgre and i follow below links to trouble shoot



Logon using Local System Account:

1. Go to Start / Control Panel / Administrative Tools (Need to be using classic view in Windows Vista) / Services. The Services dialog will pop up.

2. Scroll to PostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on it and choose Start. If it starts and then stops or was already started, follow the steps below:

3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.

4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.

5. Select Local System Account and then click Apply then OK.

6. Restart your PC and see if you still get the error.

7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.


i and has use the step 5 to log on to the local system account but unfortunely i forgetted my password......


and i try to use this link to make it to trust

FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+%28PostgreSQL%29)

but i still facing this msg

Error 1069: The service did not start due to a logon failure.

i know that the password i key in maybe wrong.... just wan to ask is it any ways to recover the password? i dun wan to lose my database here!
Really thanks alot if helped

poker_limit
05-29-2010, 03:52 PM
no one can help? pls help~ thanks Alot!!

Gacil
05-29-2010, 04:55 PM
Apologies for the delay.

HM's default name/password is - postgres/postgrespass

If that doesnt help:

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

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL (http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL))

poker_limit
05-30-2010, 10:57 AM
Apologies for the delay.

HM's default name/password is - postgres/postgrespass

If that doesnt help:

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

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL (http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL))

the postgrespass did not help ~ and i has been tried wat u siad


# PostgreSQL Client Authentication Configuration File
# ================================================== =
#
# Refer to the "Client Authentication" section in the
# PostgreSQL documentation for a complete description
# of this file. A short synopsis follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
# local DATABASE USER METHOD [OPTION]
# host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostssl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
# hostnossl DATABASE USER CIDR-ADDRESS METHOD [OPTION]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
#
# DATABASE can be "all", "sameuser", "samerole", a database name, or
# a comma-separated list thereof.
#
# USER can be "all", a user name, a group name prefixed with "+", or
# a comma-separated list thereof. In both the DATABASE and USER fields
# you can also write a file name prefixed with "@" to include names from
# a separate file.
#
# CIDR-ADDRESS specifies the set of hosts the record matches.
# It is made up of an IP address and a CIDR mask that is an integer
# (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies
# the number of significant bits in the mask. Alternatively, you can write
# an IP address and netmask in separate columns to specify the set of hosts.
#
# METHOD can be "trust", "reject", "md5", "crypt", "password", "gss", "sspi",
# "krb5", "ident", "pam" or "ldap". Note that "password" sends passwords
# in clear text; "md5" is preferred since it sends encrypted passwords.
#
# OPTION is the ident map or the name of the PAM service, depending on METHOD.
#
# Database and user names containing spaces, commas, quotes and other special
# characters must be quoted. Quoting one of the keywords "all", "sameuser" or
# "samerole" makes the name lose its special character, and just match a
# database or username with that name.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect. You can use
# "pg_ctl reload" to do that.

# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL listen
# on a non-local interface via the listen_addresses configuration parameter,
# or via the -i or -h command line switches.
#



# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 trust


Wat i can do ? Your help really important to me ~ thanks alot

Sarek
05-30-2010, 11:03 AM
read this plz
FAQ - Hold'em Manager Poker Tracking Software :: Secondary Logon Service Error (http://faq.holdemmanager.com/questions/81/Secondary+Logon+Service+Error)

poker_limit
05-30-2010, 09:16 PM
read this plz
FAQ - Hold'em Manager Poker Tracking Software :: Secondary Logon Service Error (http://faq.holdemmanager.com/questions/81/Secondary+Logon+Service+Error)

The secondary logon has been started....but i still facing the same error 1069?


If i reinstall again the postgres 8.3~ will my database still at there? ? Thanks!

Gacil
05-31-2010, 02:29 AM
The secondary logon has been started....but i still facing the same error 1069?


If i reinstall again the postgres 8.3~ will my database still at there? ? Thanks!
From this process that Fozzy uses, a complete reinstall would also mean reimporting your hands.



Here is the process I follow to fix these issues:

This is usually a firewall or windows update issue.

FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ )

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ )
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8261)

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Hol...ager_Setup.exe (http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe)

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
PHP Code:

<CODE style="WHITE-SPACE: nowrap"><!-- php buffer start --><CODE>net user postgres /delete
</CODE><!-- php buffer end --></CODE>

B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Pos...3.9-v1.0.7.exe (http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe)
<!-- / message --><!-- sig -->__________________


I thought it might help to post the complete process for you to work through. As you can see it is possible to preserve your database if a complete reinstall is not required.

poker_limit
05-31-2010, 07:52 AM
below will be the whole story wat i has been done~ tat days suddenly i unable start my HEM and it pop up a msg unable to connected to 127.0.0.1
so i has been follow the intrustion to resolve it, i face this problem before but most of the time i use step 1 then it will be works.

1) IGo to Start / Control Panel / Administrative Tools / Services and choose to started the PostgreSQL Database Server.! but this time unable to start it.

So i would follow the second step to solve it

2) Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.and i Select Local System Account and then click Apply then OK.

after this the server can be start but i still unable to log in to the postgres. so i would choose back the previous user names to start the service
and now i faicng the error 1069 problem the logon names or password is wrong.....

so i may follow the ways to edit the files pg_hba insde MD5 works change it to trust . but i sitll is same cannot to open the service ~

Wat can i do? i hope to remain my database!

morny
05-31-2010, 08:57 AM
Hi, maybe we can do a teamviewer session to troubleshoot the problem, please email me with a suitable time to do the session and also the timezone your in.

Thanks
Morny
support@holdemmanager.com

poker_limit
05-31-2010, 01:10 PM
Hi, maybe we can do a teamviewer session to troubleshoot the problem, please email me with a suitable time to do the session and also the timezone your in.

Thanks
Morny
support@holdemmanager.com

Email sent my email is poker_limit@yahoo.com

poker_limit
05-31-2010, 07:09 PM
Hi, maybe we can do a teamviewer session to troubleshoot the problem, please email me with a suitable time to do the session and also the timezone your in.

Thanks
Morny
support@holdemmanager.com

never see u online and how should we have it ?

netsrak
06-01-2010, 03:19 AM
Did you get no answer from support? Please check your spam folder too.

We usually arrange TV sessions via email (support@holdemmanager.net)

5Clowns
12-21-2010, 12:32 PM
I had the same problem and solved it by hitting RESTORE through the control panel in Windows 7. I choosed to the time 2 days before. After done that HM starts up smooth again!

I think you fucked with the wrong registry keys or somethin, maybe a bad cleaner? :eek: