Problem with password when installing SQL

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Problem with password when installing SQL

Postby QuattroFour4 » Fri Apr 11, 2008 5:57 pm

Every time I try to install SQL 8.2.6 for PT2, and this screen comes up,

[ img ]

I type in a password, and this screen always pops up:

[ img ]

What do I do?
QuattroFour4
 
Posts: 8
Joined: Thu Mar 13, 2008 5:34 pm

Re: Problem with password when installing SQL

Postby ptrack pat » Fri Apr 11, 2008 10:31 pm

Are you using Vista? If so, did you disable the UAC first?

Are you leaving all the other fields set to the default values? You haven't changed the account domain field value have you?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Problem with password when installing SQL

Postby QuattroFour4 » Sat Apr 12, 2008 3:53 am

No, I am using XP and I have not changed any of the default values; they are as shown.
QuattroFour4
 
Posts: 8
Joined: Thu Mar 13, 2008 5:34 pm

Re: Problem with password when installing SQL

Postby ptrack pat » Sat Apr 12, 2008 11:23 am

Have you installed PostgreSQL before?

Go to the Start menu, select Run. Type COMMAND and hit OK to open a DOS window.

Type the following:

net user postgres /delete

and hit the ENTER key.
Type EXIT to close the DOS window and then install PostgreSQL again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Problem with password when installing SQL

Postby QuattroFour4 » Sat Apr 12, 2008 10:23 pm

I tried that a few times, and the same thing continues to pop up :(
QuattroFour4
 
Posts: 8
Joined: Thu Mar 13, 2008 5:34 pm

Re: Problem with password when installing SQL

Postby ptrack pat » Sat Apr 12, 2008 10:33 pm

I have no idea why this is happening.

On this first window, change the user name to "postgres2" and enter "postgres2" as the password in both fields at the bottom of the window.

Does it still give the same error?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Problem with password when installing SQL

Postby JensdePens » Fri Apr 18, 2008 7:09 pm

Hi

I have the same problem. I was following these instructions: http://www.pokertracker.com/products/PT ... InstallSQL
But this error occured on the first screen where you have to put in a password (2 times):

Error: Invalid Username specified

I changed the username to 'postgres2' (and also the password to 'postgres2')
Then it installed just fine.

But now trying to convert the PT2 database I got the following error.

---

101-SQLSTATE-08001
Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request
This is probably because of:

1)Entered wrong username/password
2)Not started the postgreSQL database
3)Not installed the PostgreSQL ODBC driver

---

I've searched the forums but could not find any help yet.

Thanks in advance for any help
Jens
JensdePens
 
Posts: 16
Joined: Fri Apr 18, 2008 4:57 am

Re: Problem with password when installing SQL

Postby ptrack pat » Fri Apr 18, 2008 7:19 pm

That error means that the PostgreSQL service is not able to start. Have you been using PostgreSQL before this and this error just started or is this the first you have installed it.

Are you using Vista?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Problem with password when installing SQL

Postby JensdePens » Fri Apr 18, 2008 7:33 pm

I haven't been using Postsql before. This is the first I have installed. (did install and uninstalled it a few times today, trying to make the convert-thing work)

I have been using OpenSLL (xammp) which gave me an error installing SQL.
I've deleted this program and the error (concerning LIBEAY32.DLL and SSLEAY32.DLL files) disappeared.

I'm using XP.
JensdePens
 
Posts: 16
Joined: Fri Apr 18, 2008 4:57 am

Re: Problem with password when installing SQL

Postby ptrack pat » Sat Apr 19, 2008 1:31 am

Use the Start > Settings > Control Panel > Add or Remove Programs window to uninstall PostgreSQL
Manually delete any remnants of the c:\program files\postgresql\8.2 folder afterwards.
From the Start menu select Run - type COMMAND into the window that opens and hit OK to open a DOS window.
Type the following:

net user postgres /delete

and hit ENTER to run it.
Type EXIT to close the DOS window.

Now try to reinstall PostgreSQL leaving everything set to the defaults and just entering passwords when needed.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Next

Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests