MySQL Installation Help

  • Hey guys,


    Hope I could get some guidance. I just installed the MySQL plugin through the Extra's repot. I have enabled it and logged in through the GUI. I then created a user - kodi and then created a database called Test and gave kodi full access to it. (I did not create user kodi in omv)...


    When I initially set up the MySQL plugin, I didn't have an option to enter database volume. All the guides I see online mention choosing one. Is there something I am missing?
    Do I need to provide write privileges to MySQL, and/or to user kodi?
    Am I missing anything else??? LOL!


    Thanks for any help - and if someone can point me in the right direction that would rock.
    PS - I am not set on SQL, any alternative that works will be considered!


    Cheers! :thumbup:

  • When I initially set up the MySQL plugin, I didn't have an option to enter database volume. All the guides I see online mention choosing one. Is there something I am missing?

    You used to be able to set a volume in the plugin. That problematic feature was removed.


    Do I need to provide write privileges to MySQL, and/or to user kodi?

    For most apps, you would need to give the kodi user the select, update, insert, and delete privileges.

    omv 5.5.6 usul | 64 bit | 5.4 proxmox kernel | omvextrasorg 5.3.5
    omv-extras.org plugins source code and issue tracker - github


    Please read this before posting a question.
    Please don't PM for support... Too many PMs!

  • I must be missing a step.. I gave user kodi basically global privileges through the web gui, and I gave it access to all databases there but I still can't write to the sql. Kodi just doesn't scan. Is there something on the OMV level that I need to do?


    i created kodi using localhost for host..


    Thank you again for your help, it's very much appreciated.

  • Post a screenshot of the mysql plugin settings and the permissions you assigned the kodi user in mysql. The plugin does very little with mysql.

    omv 5.5.6 usul | 64 bit | 5.4 proxmox kernel | omvextrasorg 5.3.5
    omv-extras.org plugins source code and issue tracker - github


    Please read this before posting a question.
    Please don't PM for support... Too many PMs!

  • I figured out my error... my bad. I didn't create the proper databases to write to. Once I did that, it worked like a charm.


    For anyone looking to do the same, here is what I did:


    1. Install MYSQL plugin from the Extras repo.
    2. Enable it through OMV Gui and then open the MYSQL GUI in a new tab.
    3. Log in and create 2 databases (no caps):

    • videodatabase
    • musicdatabase

    4. Create a user called kodi with a password called kodi. I gave it a domain of %.
    5. Create the advancedsettings.xml and put it in userdata folder (google it).


    Thanks!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!