Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 PostgreSQL db initialization problem
Google
Post new topic Reply to topic
Author Message
rickh57
 
 


Joined: 24 Dec 2004
Posts: 33

PostPosted: Thu Apr 14, 2005 3:22 pm Reply with quoteBack to top

With the released 1.5.2, I had the same PostgreSQL problem that I saw in the earlier beta (this was on a Win/2000 server box).

The \pgsql\data\ directory wasn't there, so I got it to work by using

runas /env /user:pdxhaler01\apache2triad "bin\initdb.exe -U root -D data"

from a command line. That is, I had to specify my machine name as the domainname, plus use the /env runas option in order for it to run... My user in the administrator group for my box...
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Thu Apr 14, 2005 6:26 pm Reply with quoteBack to top

well the installer and postgres is identicall in 1.5.2 with the 1.4.1 one so when you have the time can you test it with that version too ?

what do you get when running
Quote:
runas /user:apache2triad "initdb -U root -D C:/apache2triad/pgsql/data"

?

how about
Quote:
runas /user:apache2triad cmd

?

do you have terminal services or other nonstandard setups ?


Last edited by Vlad Alexa Mancini on Thu May 12, 2005 5:05 pm; edited 3 times in total
View user's profileSend private message
rickh57
 
 


Joined: 24 Dec 2004
Posts: 33

PostPosted: Thu Apr 14, 2005 7:01 pm Reply with quoteBack to top

Running the first command gives:

C:\apache2triad\pgsql>runas /user:apache2triad "bin\initdb.exe -U root -D data"
Enter password for apache2triad:
Attempting to start "bin\initdb.exe -U root -D data" as user "apache2triad"...
RUNAS ERROR: Unable to run - bin\initdb.exe -U root -D data
1326: Logon failure: unknown user name or bad password.

I get the same error when trying the "runas /user:apache2triad cmd", as well.

I'm not using terminal services, etc., but I am part of a domain.
View user's profileSend private message
soccer
 
 


Joined: 25 Oct 2005
Posts: 8
Location: Augusta, GA

PostPosted: Tue Oct 25, 2005 6:42 pm Reply with quoteBack to top

I keep getting the same error. Any combination of usernames and passwords doesn't work. I am so frustrated b/c in the FAQ it has

Q22 : Why did PostgreSQL did not install , and i am missing the config file and /data folder ?

The answer points to this forum thread and this thread doesn't help at all!! I would pay money if someone would just help me.
View user's profileSend private messageSend e-mailAIM AddressYahoo Messenger
ennics
 
 


Joined: 08 Nov 2005
Posts: 1

PostPosted: Tue Nov 08, 2005 9:46 am Reply with quoteBack to top

i had the same problem under my winXP. Try to:
- create new user WITHOUT administrator privileges (normal user) ex. pgsql
- run init: runas /user:pgsql "initdb -U root -D C:/apache2triad/pgsql/data"
- confirm the password.
works for me Wink
View user's profileSend private message
klaith
 
 


Joined: 10 Nov 2005
Posts: 1

PostPosted: Thu Nov 10, 2005 12:12 pm Reply with quoteBack to top

Story so far:
After installation of apache2triad and reboot I notice that postgresql process is not running. I try to start the service using the control panel but the service stops as soon as I start it. Read the apache2triad_pgsql.txt file and notice that the data directory is missing. google to find this thread. Execute the runas command (runas /user:apache2triad "initdb -U root -D C:/apache2triad/pgsql/data") and get the following error message:

RUNAS ERROR: Unable to run - initdb -U root -D C:/apache2triad/pgsql/data
1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

Anybody got any ideas?

Prior to installing apache2triad I had a vanilla postgresql installation running no problem.

Update: Logged off and logged back on as apache2triad. Opened a command prompt and ran initdb -U root -D c:\apache2triad\pgsql\data
viola!~)
View user's profileSend private message
fredi
 
 


Joined: 11 Mar 2006
Posts: 1

PostPosted: Sat Mar 11, 2006 9:18 am Reply with quoteBack to top

It works if your volume is NTFS-formatted!
If your volume ist a FAT32-volume then try the following procedure:

open a command line/box and type
convert [drive]: /fs:ntfs
e.g.
convert C: /fs:ntfs

That resolved the problem on my machine.

greets
Fredi
View user's profileSend private message
camslaz
 
 


Joined: 28 Mar 2007
Posts: 2

PostPosted: Wed Mar 28, 2007 2:06 am Reply with quoteBack to top

I had this exact same problem on my Windows XP SP2 system. I installed Apache2triad and it all seemed to run smoothly during installation. I had problems starting pgsql and found in the FAQ the issue with the data/ directory. After trying a number of different suggestions in this and other threads it still would not install. The following is was solved the problem for me so thought I would share it...

1. Go to Start -> Control Panel -> System -> Computer Name [tab] and get the 'Full computer name:' name. I am going to refer to this value below as FULLCOMPNAME which you will need to change in point 4.
2. Go to Start -> Run...
3. Type 'C:' and click enter. If you have installed A2T on a different drive enter that intead of 'C:' example 'D:'
4. Type: runas /env /user:FULLCOMPNAME\apache2triad "initdb -U root -D C:/apache2triad/pgsql/data/"
and press enter. Remember to change FULLCOMPNAME with your 'Full computer name:' which you can get in point 1. Also change C: if you have A2T installed on a different drive.
5. You will then be promoted for a password, I entered my root password I entered at the time of installing A2T. Press Enter.
6.This should trigger another command window to open and will run through and install pgsql.

Good Luck
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT