Layer from postgresql

[RenataB]

Hi, I'm doing an experiment about using lizmap to publish some layers coming from a postgresql+postgis server.
So, I installed on the same PC (Debian) Postgresql, postgis, Qgisserver, php (with postgresql extension), phyton and so on and I created a very simple project with 3 layers coming from DB.
Then I created repository on lizmap, doing everything I thought was correct but... I can't see my DB layers with lizmap project.
Is there something I can check (or not) in the lizmap plugin? Something to check on the DB?
Thank you very much!
Renata.

[pcav]

Hi Renata,
if you can see the layers on your desktop, you should be able to see them on the server too. Just check that in pg_hba.conf you have the right to access the db from both.

[RenataB]

Hi Paolo,
it's an 'ALL-IN-ONE' installation where everything is on the same Debian PC (from DB to browser), so I don't think there's something between DB and Lizmap but something in Lizmap configuration... unfortunately I'm not enough good with this SW... :-(
(between us: e sfortunatamente non siamo arrivati a parlare di postgresql durante il tuo corso ad Udine).
What can I check now?
Thank you! :-)

[RenataB]

Hi! Could you help me? I'm trying everything: DB in on, apache supports php, in .qsg.cfg file I can see my postgis layers, in Lizmap plugin I don't see anything strange, but... in Lizmap project there's only the layer coming from a shape file I have in the same dir...
What can I check to understand what's going wrong?
Thanks!

[mdouchin]

Hi, some questions:

• do you store the password in QGIS for your postgresql connection ? To check, open the project file in a text editor and search for "dbname" then have a look at the "user" and "password" parameters of the datasource. QGIS server needs a full access to the database : you can store the password in the QGIS project (by allowing QGIS to store the password when creating/editing your PG connection) OR you can use PostGreSQL services
• Have you tried to open your QGIS server WMS service inside a blank QGIS project, to see if QGIS, as a WMS client, can get all the layers ? You could also check in your browser in the "developper tools" the content returned by the server for the request GetCapabilities, and see if your PG layers are found in the returned XML or not.

[RenataB]

Oh thanks Michael! The first solution you list is the right one! I can see my postgis layers in Lizmap Project! :-)
Thank you very much!!! :-)