Posts by Klojum

    You are "suffering" from the old 'overscan' feature that was implemented during the era of the bug tube television screens some 70 years ago.

    You can alter the settings for overscan in the /flash/config.txt file, for while you will need to dive into an SSH session.

    Most of the video default settings you can find here.

    You could also use the Video Calibration in the Kodi GUI, but that is usually used as a last resort.

    About the audio output. Most Raspberry Pi's (if not all) simply have a poor analog audio output signal. Whatever Raspbian does differently, I personally don't know. Alternatively, you could install Raspbian and then install Kodi, if that works better for you.

    /storage/.kodi/userdata/addon_data/service.mariadb/mysql.log

    This is indeed created now, so probably addons have no write permissions outside their own addon-data folder?

    The "service." prefix also did indeed do the trick.

    Kodi user can't connect on localhost but only on real ip address. That's why you need to use -h parameter

    I don't recall having to do that with MySQL. It's possibly a feature on later releases, that also got into MariaDB.

    It's just something I stumbled onto when mistyping my passwords. But, back to the real work now.

    but I'm using OpenELEC at the moment...that the difference?

    As far as I know, OpenELEC only supported SMBv1. Unfortunately, the OpenELEC maintainer has been M-I-A for almost 2 years now. Microsoft has done plenty of changes to the whole samba sharing via its Windows updates, and it's too bad the user-interface as far as networking goes for the average Windows user, hasn't improved in terms of user-friendliness or clearness.

    I've been using Ubuntu Linux as my daily driver for almost 10 years now, as well as the NFS protocol for my Kodi file needs. So, no I don't have all the Windows answers.

    vpeter Me again... :blush:

    The database is still doing fine, but I have some more questions:

    - Having enabled the log function and store it locally is not working. Or the log function is not working at all. No log file is created. Is it possible MariaDB is still using a my.cnf in a different location?

    Code
    # * Logging and Replication
    #
    # Both location gets rotated by the cronjob.
    # Be aware that this log type is a performance killer.
    # As of 5.1 you can enable the log at runtime!
    #general_log_file        = /var/log/mysql/mysql.log
    general_log_file        = /storage/.kodi/temp/mariadb.log
    general_log             = 1

    Any way I can verify the log is working? Obviously the default location is not working as there is no '/var/log/mysql' folder to begin with.

    - How do I start/stop/restart the mariadb service? I've tried several names but none seem to work. Otherwise I need to reboot the RPi to have the changes in the config file activated.

    - I have given the kodi user for the mariadb also 'kodi' (call me lazy), but apparently I cannot connect via SSH with those full credentials.

    When I use mysql -u kodi -p and enter the password, I get an ERROR 1045 (28000): Access denied for user 'kodi' localhost (using password: YES).

    When I use mysql -u kodi without typing the password but just go ENTER, I get logged into the MariaDB server.

    It's like an opposite situation.

    Is this a quirky bug when having the same values for user and password? When using 'root' (which has a unique password), it have to type the password to log in normally.

    Please provide a full debug log.

    How to post a log (wiki)

    1. Enable debugging in Settings>System Settings>Logging
    2. Restart Kodi
    3. Replicate the problem
    4. Generate a log URL (do not post/upload logs to the forum)

    use "Settings > LibreELEC > System > Paste system logs" or run "pastekodi" over SSH, then post the URL link

    You're about the 264,983th Kodi user complaining that Samba is no longer working... ;)

    It's 99% because of the change in SMB version. So whatever is still working now, is probably still using the old insecure SMBv1 protocol.

    Until last year, lots of network devices used SMBv1. After the whole WannaCry disaster, Microsoft finally defaulted SMBv2 as the successor of SMBv1 in the 1803 update, with among the changes:

    - Windows users require a password for SMB access

    - SMB network browsing is no longer supported.

    So, once your Windows "server" has SMBv2 enabled, you can use the "Add a network location.." option in Kodi, enter full credentials, and "things should work" (tm).

    There are plenty of other threads on this and the Kodi forum on this topic, so feel free to do some extra reading.

    If you cannot uninstall it, the easiest option for now would be to simply not use it anymore.

    You could go to the video/movie source in Kodi, open the context menu, select the "Set content" option, and empty the selection.

    Then re-open the "Set content", and the enter the correct details, with a different movie information provider, and have Kodi rescan your video collection.

    I had a feeling, that would be the case. I just wondered, that's all. I still use(d) MySQL 5.5.62 on Ubuntu 14.04 myself *cough*.

    One thing about the passwords in the MariaDB addon settings:

    Will the current passwords simply be overwritten in the running database setup by newly entered passwords?

    Okay... So far two consecutive days 24/7 of problem-free MariaDB usage. :cool:

    I still need to investigate the Recently Added timeout via the Mariadb logfile, though.

    vpeter Are you planning on maintaining the add-on as well, as MariaDB updates are released? Perhaps only the bigger updates?

    Or will it be the "If it ain't broken, don't fix it" approach?