Thread: session_pgsql-0.6.1

session_pgsql-0.6.1

From
"Bernd Hoffmann"
Date:
Hello,

i need some help with session_pgsql-0.6.1. The installation runs without
wrong http://unixserver.info/phpinfo.php

The only one manual which I can find is the README:
..
...
Once you have successfully installed session_pgsql (and PHP of course)
and PostgreSQL to localhost. All you have to do is (as postgres super user)

% createuser nobody
% createdb php_session
...
..

I cant't create a user "nobody" without a password!

Can somebody send me a link (tutorial, manuel,...) which I can use this
extension on a multiuserserver??

Thanks..

Bernd


Bernd Hoffmann
Geisbergblick 1
96123 Litzendorf
Tel.: 09505804066
info@unixserver.info


Re: session_pgsql-0.6.1

From
brew@theMode.com
Date:
Bernd.......

> Once you have successfully installed session_pgsql (and PHP of course)
> and PostgreSQL to localhost. All you have to do is (as postgres super user)
>
> % createuser nobody
> % createdb php_session

Perhaps you don't have permission to create new users.  In that case find
out what user you can log in as and use that and change the code.  I don't
think there is anything special about users in postgreSQL, except to keep
track of who has what permissions and where they can connect from.

If you are lucky there is one common connection include file so you only
have to change it once instead of on every connection instance.

If you still have trouble with users and connecting to the DB server
you'll have to contact the server admins for help as this is server
specific.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================


Re: session_pgsql-0.6.1

From
"Bernd Hoffmann"
Date:
brew.......

thanks for answer..

> Perhaps you don't have permission to create new users.  In that case find
> out what user you can log in as and use that and change the code.  I don't
> think there is anything special about users in postgreSQL, except to keep
> track of who has what permissions and where they can connect from.

I'm rootuser :)

> If you are lucky there is one common connection include file so you only
> have to change it once instead of on every connection instance.

There is only one dbconnect string without password.
The installation is ok, I think http://unixserver.info/phpinfo.php

> If you still have trouble with users and connecting to the DB server
> you'll have to contact the server admins for help as this is server

Normally my server runs with the following two lines in pg_hda.conf
local      all
password
host       all         127.0.0.1     255.255.255.255    password

I can't create a user per createuser without password because
input ask me to a password again and again.

I've add the following line to my pg_hda.conf without success. :(
local      php_session                                            trust

Can I use any db, with other dbname and with password? If yes, how can I
disshow my
dbname, password.. in phpinfo?

Where can I find some examples at web?

PS.: Excuse me for my bad english, but I'm german.. :)

Thanks

Bernd

Bernd Hoffmann
Geisbergblick 1
96123 Litzendorf
Tel.: 09505804066
info@unixserver.info


Re: session_pgsql-0.6.1

From
"Adrian Tineo"
Date:
After installing you NEED to create a user, this hasn't got to be the same
name of your unix user but most normally it will be. For example if your
Unix username is bhoffmann.

su - root    //Enter password
su - postgres    //Enter as postgresql superuser and no password will be
needed as you were root
createuser bhoffmann
exit
exit    //now you are bhoffmann again type "whoami" to check
createdb mydb    //Creates a db as user bhoffmann, you can also use
"createbd mydb -U bhoffmann"
psql mydb
etc

Let us know if it worked.

>
> I'm rootuser :)


Adrian Tineo