PHPRad Classic Initial 2.7.3 Forum

PHPRad Forum => Issues => Topic started by: SwissCharles on January 13, 2022, 07:32:03 PM

Title: PHPRad doesn't see my PostgreSQL database..
Post by: SwissCharles on 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


 
Title: Re: PHPRad doesn't see my PostgreSQL database..
Post by: willvin on 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.