Qgis server/qgis web client php search problems

[qgib]

Author Name: Ivan D'Ortenzio (@ivandortegis) Original Redmine Issue: 17016 Affected QGIS version: 2.18.10 Redmine category:qgis_server

---

I have configured a localhost qgiserver/qgisclient in my windows 10 pc with Apache/2.4.27 (Win64) and php7 loaded in httpd.conf:

LoadModule php7_module "C:\Apache_qgiserver\php_mod\php7apache2_4.dll" AddHandler php7-script php DirectoryIndex index.html index.php AddType text/html php PhpIniDir "C:\Apache_qgiserver\php_mod"

The Web client works fine but I cannot configure php search box... I've created a sample project named "prova.qgs" in \htdocs\QGIS-Web-Client\projects with a postgis layer inside named "italia". Then I modified GlobalOptions.js to include search box: // PHP based search scripts (postgis layers only) var searchBoxQueryURL = '../php/search.php?map=' + project_map; var searchBoxGetGeomURL = '../php/search_geom.php?map=' + project_map;

Then I set up the config.php file as follows:

/**

• search configuration */ // Configuration for searchable layers $searchlayers_config = array( // Key is layer name 'italia' => array( // SQL for text search: where to search 'search_column' => 'nome' ) );

// Default search tables define('DEFAULT_SEARCH_LAYERS', 'italia');

but the search box doesn't work and I receive an error:

Internal server error (QGIS Client) db error: SQLSTATE[08006] [7] FATALE: autenticazione con password fallita per l'utente "'postgres'"

this is the query url: http://localhost/php/search.php?map=C:/Apache_qgiserver/htdocs/QGIS-Web-Client/projects/prova.qgs&searchtables=&query=sicilia&cb=stcCallback1001

[qgib]

Author Name: Tudor Bărăscu (@tudorbarascu)

---

I haven't played around with the php search but the error seems obvious (wrong password for user postgres). You could setup the db to temporarily trust connections from your ip just to be sure.

[qgib]

Author Name: Ivan D'Ortenzio (@ivandortegis)

---

Tudor Bărăscu wrote:

I haven't played around with the php search but the error seems obvious (wrong password for user postgres). You could setup the db to temporarily trust connections from your ip just to be sure.

I resolved my problem... but I modified connection string parameters like host,port,dbname,user and password manually in htdocs\QGIS-Web-Client\site\php\Helpers.php. This is because the $ds_parms['user'] return the username as'postgres' and not without quotes.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I resolved my problem...

good. This was also the wrong bug tracker where to report an issue about QWC.

---

• resolution was changed from to invalid
• status_id was changed from Open to Closed