<div dir="ltr"><div>Indeed, these tables are created during the installation of Lizmap.</div><div>It's not possible to change the backend just with updating the config file.<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le jeu. 6 janv. 2022 à 14:02, Nicolas Boisteault <<a href="mailto:nboisteault@3liz.com">nboisteault@3liz.com</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi,</p>
<p>did you launch /lizmap/install/installer.php after changes ?<br>
</p>
<div>Le 06/01/2022 à 12:54, Zizi Jama a
écrit :<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Hello,</div>
<div><br>
</div>
<div>I am using this repo <a href="https://github.com/3liz/lizmap-docker-compose" target="_blank">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-wrap"><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-wrap"><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></fieldset>
<pre>_______________________________________________
Lizmap mailing list
<a href="mailto:Lizmap@lists.osgeo.org" target="_blank">Lizmap@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap</a>
</pre>
</blockquote>
<div id="gmail-m_3173336366977631107grammalecte_menu_main_button_shadow_host" style="width:0px;height:0px"></div>
</div>
_______________________________________________<br>
Lizmap mailing list<br>
<a href="mailto:Lizmap@lists.osgeo.org" target="_blank">Lizmap@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap</a><br>
</blockquote></div>