The restore function with pi-manage is broken on privacyidea 3.9.2

[sepp67]

The restore function with pi-manage is broken on privacyidea 3.9.2

The issue was reproduces on a fresh installation.
ubuntu 22
privacyidea 3.92

The issue happens only when the radius config is integrated in the backup

pi-manage backup create radius_directory /etc/freeradius/3.0/

Then the following error message follows:

Also restoring encryption key 'enckey'
Restoring to /etc/privacyidea/pi.cfg with data from /etc/freeradius/3.0/mods-config/sql/ippool/postgresql/procedure.sql
Restoring database.
ERROR 1146 (42S02) at line 32: Table 'pi.radippool' doesn't exist

[cornelinux]

A table pi.radipool is not default to privacyIDEA.
This is the old problem, that default tools can not solve none-default tasks.
@sepp67 Please consider closing this request.

[plettich]

The problem here is that we use the first *.sql file as the privacyIDEA database dump:

privacyidea/pi-manage

Line 383 in b9df53e

elif re.search(r"\.sql", line):

We know that the database dump from the backup -> create is called dbdump-<DATE>.sql so we can search for this pattern instead of just using the first *.sql in the backup.

Could probably be combined with #3815

[cornelinux]

Simple solution would be to omit the backup of the non-default FreeRADIUS configuration.
Then everything would work out fine.