<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi,</p>
<p>did you launch /lizmap/install/installer.php after changes ?<br>
</p>
<div class="moz-cite-prefix">Le 06/01/2022 à 12:54, Zizi Jama a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CA+Pxu0BqG_0ev3D_W7cPzx0q3yKF1ZMaNzFzCGqnHs6MZ418sg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hello,</div>
<div><br>
</div>
<div>I am using this repo <a
href="https://github.com/3liz/lizmap-docker-compose"
moz-do-not-send="true">https://github.com/3liz/lizmap-docker-compose</a></div>
<div><br>
</div>
<div>I am aware that it says it is for testing.</div>
<div><br>
</div>
<div>I am trying to use PostgreSQL as the auth db instead of
sqlite.</div>
<div><br>
</div>
<div>I have made changes to profiles.ini.php</div>
<div>
<div style="color:rgb(212,212,212);background-color:rgb(30,30,30);font-family:"Droid Sans Mono","monospace",monospace,"Droid Sans Fallback";font-weight:normal;font-size:14px;line-height:19px;white-space:pre"><div><span style="color:rgb(212,212,212)">[jdb]</span></div>
<div><span style="color:rgb(212,212,212)">; name of the default profile to use for any connection</span></div><div><span style="color:rgb(212,212,212)">default=jauth</span></div><div><span style="color:rgb(212,212,212)">jacl2_profile=jauth</span></div><div><span style="color:rgb(212,212,212)">;lizlog=jauth</span></div>
<div><span style="color:rgb(212,212,212)">[jdb:jauth]</span></div><div><span style="color:rgb(212,212,212)">;driver=sqlite3</span></div><div><span style="color:rgb(212,212,212)">;database="var:db/jauth.db"</span></div>
<div><span style="color:rgb(212,212,212)">driver=pgsql</span></div><div><span style="color:rgb(212,212,212)">host=postgis</span></div><div><span style="color:rgb(212,212,212)">service=lizmapdb</span></div><div><span style="color:rgb(212,212,212)">search_path="lizmap,public"</span></div>
<div><span style="color:rgb(212,212,212)">[jdb:lizlog]</span></div><div><span style="color:rgb(212,212,212)">;driver=sqlite3</span></div><div><span style="color:rgb(212,212,212)">;database="var:db/logs.db"</span></div>
<div><span style="color:rgb(212,212,212)">driver=pgsql</span></div><div><span style="color:rgb(212,212,212)">host=postgis</span></div><div><span style="color:rgb(212,212,212)">service=lizmapdb</span></div><div><span style="color:rgb(212,212,212)">search_path="lizmap,public"</span></div></div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>and here is the content of pg_service.conf</div>
<div>
<div style="color:rgb(212,212,212);background-color:rgb(30,30,30);font-family:"Droid Sans Mono","monospace",monospace,"Droid Sans Fallback";font-weight:normal;font-size:14px;line-height:19px;white-space:pre"><div><span style="color:rgb(212,212,212)">[lizmapdb]</span></div><div><span style="color:rgb(86,156,214)">host</span><span style="color:rgb(212,212,212)">=postgis</span></div><div><span style="color:rgb(86,156,214)">port</span><span style="color:rgb(212,212,212)">=5432</span></div><div><span style="color:rgb(86,156,214)">dbname</span><span style="color:rgb(212,212,212)">=lizmap</span></div><div><span style="color:rgb(86,156,214)">user</span><span style="color:rgb(212,212,212)">=lizmap</span></div><div><span style="color:rgb(86,156,214)">password</span><span style="color:rgb(212,212,212)">=lizmap1234!</span></div></div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>In the logs for my postgis container I get the following
error message:</div>
<div>2022-01-06 10:12:19.654 UTC [1168] lizmap@lizmap ERROR:
relation "jlx_user" does not exist at character 350<br>
2022-01-06 10:12:19.654 UTC [1168] lizmap@lizmap STATEMENT:
SELECT "usr"."usr_login" as "login", "usr"."usr_email" as
"email", "usr"."usr_password" as "password",
"usr"."firstname", "usr"."lastname", "usr"."organization",
"usr"."phonenumber", "usr"."street", "usr"."postcode",
"usr"."city", "usr"."country", "usr"."comment",
"usr"."status", "usr"."keyactivate", "usr"."request_date",
"usr"."create_date" FROM "jlx_user" AS "usr" WHERE
"usr"."usr_login" = 'admin' LIMIT 1 OFFSET 0</div>
<div><br>
</div>
<div>It seems to me the issue is that the relation jlx_user is
not created in the postgis container</div>
<div><br>
</div>
<div>I also notice that the file pgsql.dbconnection.php is not
created<br>
</div>
<div><br>
</div>
<div>I also see a similar error from the lizmap container</div>
<div>2022-01-06 11:15:21 [403] invalid query (ERROR:
relation "jlx_user" does not exist<br>
LINE 1: ...", "usr"."request_date", "usr"."create_date" FROM
"jlx_user"...<br>
^(SELECT "usr"."usr_login" as "login", "usr"."usr_email" as
"email", "usr"."usr_password" as "password",
"usr"."firstname", "usr"."lastname", "usr"."organization",
"usr"."phonenumber", "usr"."street", "usr"."postcode",
"usr"."city", "usr"."country", "usr"."comment",
"usr"."status", "usr"."keyactivate", "usr"."request_date",
"usr"."create_date" FROM "jlx_user" AS "usr" WHERE
"usr"."usr_login" = 'admin' LIMIT 1 OFFSET 0))
/www/lib/jelix/plugins/db/pgsql/pgsql.dbconnection.php 187</div>
<div><br>
</div>
<div>Is my understanding not correct if one changes
profiles.ini.php to use PostgreSQL as the auth db I should not
be getting the above errors.</div>
<div><br>
</div>
<div>Is it a case of me missing something in my setup?</div>
<div><br>
</div>
<div>Thanks.<br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Lizmap mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lizmap@lists.osgeo.org">Lizmap@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/lizmap">https://lists.osgeo.org/mailman/listinfo/lizmap</a>
</pre>
</blockquote>
<div id="grammalecte_menu_main_button_shadow_host" style="width:
0px; height: 0px;"></div>
</body>
</html>