[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

From phpMyAdmin > Status > Advisor. Using your addon...

I can make changes yes via phpMyAdmin

Hi vpeter, it is need to be worry about 7.0.2 compatibility? Related to Rpi, Linux kernel was updated to 4.4.13; not sure if thats related to mysql, but better ask before update, when you running library there on multiple environments

Edit: I just put it right here, to not mess your thread more: Thank you! Compiling 7.0.2 right now.

Quote from vpeter

I dont think there should be any issues.

Hey,
thanks for the addon. Love using it. I used the OE addon with the latest LE version on iMX6 (v17 from here: LAMP – Google Drive was the last I could fin). The MySQL part is working, but it would be cool if you could provide an iMX6 release here as well.
Thanks!

Worked fine in beginning, but recently my HTPC started locking up/freezing for few minutes before being able to use.
Disabled addon & reverted to normal Kodi DB & worked fine again.
JimmySmith how is yours running - smoothly?
Could you post or msg me how yours setup so I can try getting it going again.

Hi,

I didnt register anything.. My configuration you can find in this thread I think. I dont have plenty of movies or TV Shows, like 10-25 Movies, and around 200-300 tv show episodes tops. The next step would be examine your logs, if those doesnt tell you, which part of kodi/plugins have problems during freeze.

Is there a way to store the sql database on an external usb drive instead of the internal sd card? i actually installed this on a android box running LE but dont want to waste my internal storage space and would just rather have it external incase i need to switch devices.

Secondly how are we to handle LE updates once Krypton is released, do you have to update LE first and then upgrate LAMP or install newer LAMP addon the install the latest LE?

Quote from JimmySmith

Did you mean for Kodi? If yes, I using

Code

query_cache_type        = 1
query_cache_size        = 5M
skip-name-resolve
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..

Code

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K


# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 10M
innodb_additional_mem_pool_size = 2M


# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 2M
innodb_log_buffer_size = 8M


#innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Display More

Noob question but where are you adding the above config?

Quote from vpeter

I will rebuild the addon in next days for all projects. And when addon will not start I will rebuild it again

/storage/.kodi/userdata/addon_data/http://service.web.lamp/mysqld.cnf

Thanks but what about moving the database to an external usb drive instead?

Or atleast a backup plan to backup the database based on a schedule.

Hi

Is there any chance to compile php5-libsmbclient just to allow owncloud access external SMB drives (as it was introduced in 8.1 ownCloud 8.1 Release Notes — ownCloud 8.1 Server Administration Manual 8.1 documentation) ?

BR
Janusz

Hy VPeter,

Your addon work on wetek play?
It has Amlogic AML-8726 MX soc.

I had lamp addon for openelec, but I use libreelec 7.0.2
Do I need find for libreelec,or work the old version?

I install lamp addon to s905 device.
I copy wordpress , there already a problem, isnt store the sql settings automatically, but i make it manually with config file.
Try wordpress with with real estate template, with mysql database ,but i cannot upload photos.

I tried with other plugin too.
There is this screenshot.
I watched privileges, but all is 755 at wp-content directory.
I think its enough.
How can i fix it?