db connection

[Pierre Sahores]

Le 1 sept. 04, à 01:33, Hershel Fisch a écrit :

>>
>>>
>>>> 2) If this is the case then why is the err , invalid database type.
>>>
>>> To see if postgres is running normally lauch the activity monitor 
>>> app and search the postgres thread. To see if the "postgres" user is 
>>> rightly set, test "su - postgres" at the shell prompt and, then if 
>>> you are prompted for the password, type "postgres". If something 
>>> goes wrong, postgres need to be reinstalled (prefer the Marc 
>>> Liyanage's installer -- 
>>> <http://www.entropy.ch/software/macosx/postgresql/>).
>> Sorry , don't know what and where the activity monitor is.
>> The su - postgres is ok.
>> And I did use entropy's installation.
>
> [Hershel-Fischs-Computer:~] hershel% su - postgres
> Password:
> [Hershel-Fischs-Computer:~] postgres% /usr/local/bin/pg_ctl stop -D 
> /usr/local/pgsql/data/
> waiting for postmaster to shut down......done
> postmaster successfully shut down
> [Hershel-Fischs-Computer:~] postgres% /usr/local/bin/postmaster -D 
> /usr/local/pgsql/data -i
> LOG:  database system was shut down at 2004-08-31 19:11:05 EDT
> LOG:  checkpoint record is at 0/C1E4D0
> LOG:  redo record is at 0/C1E4D0; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction id: 6911; next oid: 19457
> LOG:  database system is ready

OK, the database is cleanly loading and running. If you can't access it 
from the Rev application, it can have to do with, at least :

- PHP not proeperly installed and configured in "httpd.conf"
- the tcp/ip sockets support is not actived in the "hba.conf" file of 
the postgres server

Let me know the end ;)

Best, Pierre

>
>>>
>>>
>>>> 4) "put  revOpenDatabase("MySQL","127.0.0.1","test",postgres,)" 
>>>> when I don't have mySql running, into the message box crashes or 
>>>> Freezes RR.
>>>
>>> Don't tell RR to connect MySQL if you want to access a PostgreSQL 
>>> server...
>>>
>>>> Thanks in advanced. Hershel
>>>
>>> Hope this can help,
>>>
>>> Best, Pierre
>>>
>>>
>>> Bien cordialement, Pierre Sahores
>>>
>>> 100, rue de Paris
>>> F - 77140 Nemours
>>>
>>> psahores+ at +easynet.fr
>>>
>>> GSM:   +33 6 03 95 77 70
>>> Pro:      +33 1 64 45 05 33
>>> Fax:      +33 1 64 45 05 33
>>>
>>> WEB/EAI services & ACID DB over IP
>>> "Mutualiser les deltas de productivité"
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

psahores+ at +easynet.fr

GSM:   +33 6 03 95 77 70
Pro:      +33 1 64 45 05 33
Fax:      +33 1 64 45 05 33

WEB/EAI services & ACID DB over IP
"Mutualiser les deltas de productivité"