[Debian-iot-maintainers] Bug#985238: workaround , first patch

[Florian Küpper]

The error psql emits is triggered by glewlwyd.postinst feeding it mysql 
command line options.

With that fixed , I see the following error:

....

/   CREATE INDEX
    CREATE TABLE
    INSERT 0 1
    INSERT 0 1
    INSERT 0 1
    INSERT 0 1
    INSERT 0 1
    INSERT 0 1
    ERROR:  function gen_salt(unknown) does not exist
    LINE 1: ...ser WHERE gu_username='admin'), crypt('password', 
gen_salt('...
                                                              ^
    HINT:  No function matches the given name and argument types. You 
might need to add explicit type casts.
    INSERT 0 1
    INSERT 0 1
I   NSERT 0 1
    INSERT 0 1
    Start Glewlwyd service
    Setting up glewlwyd-dbgsym (2.5.2-1) ...
    Processing triggers for man-db (2.9.4-2) ...
    root at msg:/tmp/glewlwyd#
/

I found out that the pgcrypo extension needs to e enabled.

These two changes are attached as pgConfig.diff , which where generated 
with quilt (debian/patches).


The last hurdle, I hope is this one:

Note: I could build the package with dpkg-buildpackage -uc -us 
-rfakeroot.  It installed but failed to start.

    root at msg:/tmp/glewlwyd# tail /var/log/daemon.log
    Mar 15 19:49:11 msg systemd[1]: Started Glewlwyd OAuth2 
authentication provider (Debian package).
    Mar 15 19:49:11 msg glewlwyd[17604]: Error - database type unknown
    Mar 15 19:49:11 msg glewlwyd[17604]: Error parsing config file


in /etc/glewlwyd/glewlwyd-db.conf the value says:

type = "pgsql"

but glewlwyd needs it to be

type = "postgre"

See also attached glewlwyd-db.diff file, which is simply a before/after 
diff of that file on the system after installation.


With that changed , glewlwyd starts and I can login as admin with the 
default password.

So far it is beyond me how change the templating of dbconfig-common to 
reflect that and since this my first attempt at filing a bug report I am 
awaiting Your feedback.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgConfig.diff
Type: text/x-patch
Size: 1655 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/debian-iot-maintainers/attachments/20210315/874a4fa6/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: glewlwyd-db.diff
Type: text/x-patch
Size: 289 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/debian-iot-maintainers/attachments/20210315/874a4fa6/attachment-0001.bin>