LAMP addon - Linux, Apache, MySQL PHP bundle

  • LAMP addon - Linux, Apache, MySQL PHP bundle: Index of /lamp/



    LAMP – Google Drive


    Same thing as for openelec from here: OpenELEC Mediacenter - OpenELEC Forum - LAMP addon - Linux, Apache, MySQL PHP bundle (1/30)


    Tested on imx6 and RPi2.

    Blu-ray Disc Java menus support - forum thread, Github

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

    Edited once, last by vpeter ().


  • 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.

    Blu-ray Disc Java menus support - forum thread, Github

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

    Edited once, 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

    Blu-ray Disc Java menus support - forum thread, Github

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

    Edited once, 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.

    Blu-ray Disc Java menus support - forum thread, Github

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

    Edited once, 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
    2x 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

    RPi2 B + Samsung TV, LE 7.0.3

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

    All my Kodi installations have implemented .zip patch and EAC3 patch.

    Edited once, last by JimmySmith ().

  • Thanks JimmySmith


    Have actually made a few changes similar to suggested except the InnoDB change.
    Will try converting DB

  • 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.

    Blu-ray Disc Java menus support - forum thread, Github

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

    Edited once, 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
    2x 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

    RPi2 B + Samsung TV, LE 7.0.3

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

    All my Kodi installations have implemented .zip patch and EAC3 patch.


  • Any ideas on fixing these issues


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

    Blu-ray Disc Java menus support - forum thread, Github

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