PHPRad doesn't see my PostgreSQL database..

January 13, 2022, 07:32:03 PM

Hi Folks

First things first:
I acted on the info re Postgres’ authentication and modified it’s 2 configuration files to use md5 plus reset the already existing user’s password on the server (ALTER USER…) .

When trying to start a new project (PHPRad Classic 2.7.3), using an existing PostgreSQL 13 database, I get the following error message:
“Fatal: 3D000: Databayse “xyz” does not exist”

What I entered:

selected POSTGRE as DB-Server
Server: localhost Port: 5432
Username: cus
his password: xxxxxx
Database: As soon as I click on the small down-arrow, the above error message appears.
On the DB-Server, I would like to connect to an existing schema which isn’t then shown.

The database is accessible through both, pgAdmin and my modeling tool Moon Modeler…

My environment:

Windows 10 Pro 64 Bit
xampp 8.0.3
PostgreSQL 13.1
Firefox latest

Thanks for your input on this!

Charles

Re: PHPRad doesn't see my PostgreSQL database..

Reply #1 – January 14, 2022, 09:53:57 AM

@SwissCharles‍ hi, it better to use a public schema for you db, that way PHPRad can find it. PHPRad cannot deal with private schema types.