Bug 1928109

Hi! I'll get out an update with MySQL support enabled. We can't enable ffmpegthumbnailer, because we can't add a dependency on something we can't ship in Fedora.

FEDORA-2021-39c3d7d624 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2021-39c3d7d624

Thank you for the MySQL support!

Let me try to argue my case for the ffmpegthumbnailer switch. I understand that you cannot add a dependency to the ffmpegthumbnailer rpm because it is not in the Fedora repo.

But from my point of view this is not necessary. All that should be changed is the compiler switch. That will have no impact on the "normal" user. With default settings the function is disabled: https://docs.gerbera.io/en/stable/config-extended.html

Currently it is not even listed in the config.xml.

In order to use it the user needs to:
1. read the documentation
2. change the settings in /etc/gerbera/config.xml
3. install the ffmpegthumbnailer rpm from rpmfusion (I guess a majority of users has those repos enabled anyway)

Other Fedora software packages support functionalities that only work when non-Fedora rpm's are present. First thing that comes to mind is codec support, e.g. mp3. 

If I am not wrong ffmpegthumbnailer is optionally used by KDE and Gnome to create thumbnails. Gerbera wouldn't be the first Fedora software to use it.

Disadvantage of changing the switch: None
Advantage: People who want to tinker have more options

FEDORA-2021-39c3d7d624 has been pushed to the Fedora 33 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-39c3d7d624`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-39c3d7d624

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

I have installed the new version and tested MySQL support. It works as expected.

Question: Does it make sense to put some default values for mysql into the <storage> section of /etc/gerbera/config.xml? It could be commented out, but would make it easier to get it up and running.

For reference here the steps taken:
----------------------------------
1. Have MariaDB up and running
2. Create database and user
   a: mysql -u root
   b: CREATE DATABASE gerbera_db;
   c: CREATE USER 'gerbera_user'@'localhost' IDENTIFIED BY 'gerbera_user';
   d: GRANT ALL PRIVILEGES ON gerbera_db.* TO 'gerbera_user'@'localhost';
   e: FLUSH PRIVILEGES;
   f: EXIT;
3. Create tables 
   (not sure if necessary, Gerbera manual mentions: "If Gerbera was compiled with database auto creation the tables will be created automatically during the first startup.")

   mysql -u root -p gerbera_db < /usr/share/gerbera/mysql.sql

4. Edit /etc/gerbera/config.xml
   Change <storage> section to look like this:

   <storage>
     <sqlite3 enabled="no">
      <database-file>gerbera.db</database-file>
     </sqlite3>
   <mysql enabled="yes">
     <host>localhost</host>
     <port>0</port>
     <username>gerbera_user</username>
     <password>gerbera_user</password>
     <database>gerbera_db</database>
      </mysql>
    </storage>
----------------------------------

Instructions used:
https://docs.gerbera.io/en/latest/run.html#using-mysql-database
https://docs.gerbera.io/en/latest/config-server.html#storage

I'll consider the mysql config options.

Re: ffmpegthumbnailer, what happens if someone runs gerbera with it enabled at compile time, but doesn't have ffmpegthumbnailer intalled or configured in the gerbera config?

(In reply to Gwyn Ciesla from comment #6)
> I'll consider the mysql config options.
> 
> Re: ffmpegthumbnailer, what happens if someone runs gerbera with it enabled
> at compile time, but doesn't have ffmpegthumbnailer intalled or configured
> in the gerbera config?

I have raised the question about the behaviour of the software on the gerbera github page: https://github.com/gerbera/gerbera/discussions/1234

Hopefully we get some answers from the developers.

I rest my case regarding ffmpegthumbnailer after reading the answer from the maintainer of gerbera: "Gerbera will not start if the library is missing, as the linker will complain."

Thank you again for the MySQL support!

FEDORA-2021-39c3d7d624 has been pushed to the Fedora 33 stable repository.
If problem still persists, please make note of it in this bug report.