Re: Trouble installing Drupal 5 using sockets (a little long)
От | Frank Bax |
---|---|
Тема | Re: Trouble installing Drupal 5 using sockets (a little long) |
Дата | |
Msg-id | 48A4C962.7020704@sympatico.ca обсуждение исходный текст |
Ответ на | Re: Trouble installing Drupal 5 using sockets (a little long) (Bryan <brakeb@gmail.com>) |
Ответы |
Re: Trouble installing Drupal 5 using sockets (a little long)
|
Список | pgsql-novice |
Bryan wrote: > On Thu, Aug 14, 2008 at 12:10 PM, Frank Bax <fbax@sympatico.ca> wrote: >> Bryan wrote: >>> I am trying to get my little ALIX server that is running OpenBSD >>> 4.4-current to run pgsql. I've been successful in installing 8.3.3, >>> and since OpenBSD uses a chrooted environment, I intend on using unix >>> sockets for making database connections. I read the man pages, ran >>> "initdb -D /var/postgresql/data -U postgres -A md5 -W" and edited the >>> /var/postgresql/data/postgresql.conf file to read: >>> >>> ------------------------------------------------------------------------------------- >>> In postgresql, assuming an `admin' account has all rights: >>> >>> createuser -U admin --pwprompt --no-superuser --createdb --no-createrole >>> drupal >>> createdb -U drupal -E UTF8 drupal >>> >>> ------------------------------------------------------------------------------------- >>> >>> When I type the following: >>> >>> # createuser -U admin --pwprompt --no-superuser --createdb >>> --no-createrole drupal >> >> You are running createuser under your "root" account and root is not a >> priviledged user of pgsql under OpenBSD. >> >> 1) login as the pgsql "admin" user (I think it's _postgresql; I changed it >> on my system). this was created for you if you used OpenBSD package to >> install pgsql. >> # su - _postgresql >> 2) Issue the createuser and createdb commands from that account. >> > > Frank, > > Thanks for the help. Unfortunately, I did do it with the _postgresql > user, I just was stupid in the copy paste. I hit "#", then pasted the > output. The error you see above is using _postgresql as the user. I > did run the command again making sure I was _postgresql and the error > above is still valid. > > I was further reading about people who were taking the source and > building postgresql. As a option, you can set the socket directory to > be used by the program when you build it? Shouldn't the > postgresql.conf override that directive? OK. I went back and took a closer look at original email. Hopefully you are running all commands as _postgresql. Did you also read: /usr/local/share/doc/postgresql/README.OpenBSD Which suggests a variation to startup command? You've shown that the socket is at /var/www/tmp/ which is great for apps running in chroot'd apache; but it's not great for running commands at the command line which as you can see from the error message indicate they want to socket at /tmp/ I suspect you might need to create a symbolic link from one to the other; but I don't know where the "real" one should be. Perhaps someone else knows that. If you only need the command-line to work one-time while you create the databases; you could modify your config to have socket in /tmp/; cycle pgsql; create user and db; modify config back to /var/www/tmp/ recycle pgsql and get on with Drupal testing. Frank
В списке pgsql-novice по дате отправления: