LAMP addon - Linux, Apache, MySQL PHP bundle


  • Can you compile this for odroid C2


    Uploaded service.web.lamp-8.0.20-Odroid_C2-aarch64.zip - I assume Odroid builds are only from master (v8.0)?


    Untested because don't own this hw.

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)

    The post was edited 1 time, last by vpeter ().


  • Uploaded service.web.lamp-8.0.20-Odroid_C2-aarch64.zip - I assume Odroid builds are only from master (v8.0)?


    Untested because don't own this hw.


    Thanks there is a build in odroid forum with LE 7.0


  • there is a build in odroid forum with LE 7.0


    I uploaded service.web.lamp-7.0.20-Odroid_C2-aarch64.zip for 7.0 version too.


    Still untested because still don't own this piece of hw

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)

    The post was edited 1 time, last by vpeter ().


  • Is this available for x86?


    service.web.lamp-7.0.20-Generic-x86_64.zip


    If needs for master let me know. But will build them anyway soon computer will be idle.

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)

    The post was edited 1 time, last by vpeter ().


  • Any tips on settings to tweak to optimise SQL?


    Did you mean for Kodi? If yes, I using

    Code
    1. query_cache_type        = 1
    2. query_cache_size        = 5M
    3. skip-name-resolve
    4. default-storage-engine  = innodb


    And it works pretty well for me (not big Library, two Pi's clients). Make sure that your Videos DB are innodb also (you can create it with default-storage-engine, or you can alter existing one).


    I modified also a few of other parameters (not sure which one, some of them are setuped already from vpeters template), not sure if it havinf much influence, but innodb and query cache are confirmed along Kodi forums..

    RPi2 B + Panasonic TV, LE 7.0.3
    RPi2 B + Phillips TV, LE 7.0.3
    Win 7 + Kodi 16.1
    RPi2 B + Older Panasonic TV, LE 7.0.3

    Rpi + <Any Generic TV on my Trips>, LE 7.0.3

    ---
    MySQL from LAMP plugin as Library DB for clients

    All my Kodi installations have implemented .zip patch.

    The post was edited 1 time, last by JimmySmith ().

  • Update:
    Changed to InnoDB, seems to have solved the lagging problem ive had.
    Dare I say its been working floorlesly for the past 3 days!
    Thanks again, hope they add this addon to LibreElec AddOn library.


  • hope they add this addon to LibreElec AddOn library


    If with they means me then don't expect that. It is old discussion and things like this were not acceptable to include in any way. That's why this addon is somewhere lost in space without people knowing it exist


    I'm almost sure there will be mysql docker version available one day. You could use that then.

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)

    The post was edited 1 time, last by vpeter ().

  • As an official addon.
    Hopefully like you say a Docker version will be available soon. But until then thanks for the work you put into this!

  • Hi,


    how update works? Is it enough to just install latest version, and then

    Code
    1. systemctl stop httpd.service
    2. systemctl disable httpd.service


    for enabling only mysql?


    Or should I uninstall previous version first?

    RPi2 B + Panasonic TV, LE 7.0.3
    RPi2 B + Phillips TV, LE 7.0.3
    Win 7 + Kodi 16.1
    RPi2 B + Older Panasonic TV, LE 7.0.3

    Rpi + <Any Generic TV on my Trips>, LE 7.0.3

    ---
    MySQL from LAMP plugin as Library DB for clients

    All my Kodi installations have implemented .zip patch.


  • how update works? Is it enough to just install latest version


    Yes, just update to latest version.

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)


  • Any ideas on fixing these issues


    It would be very helpful if you would write where/when you get this.

    my lamp addon (unofficial/community) (limited no support)
    my touchscreen support and instructions by Grruhn (now touchscreen addon exists in repository)