E-ManN

Thanks for the reply snusnu ... I finally got to run the script ... the command is "phython3" ... not "pyhton". So from the UNRAID server console in the Test share (I aslo tried copying the script to the /appdata/ombi folder and running it there - same error).... python3 ombi_sqlite2mysql.py -c /etc/Ombi --force --host MYServerIP --db Ombi --user ombi --passwd MyPassword or python3 ombi_sqlite2mysql.py -c /etc/Ombi --only_db_json --host MYServerIP --db Ombi --user ombi --passwd MyPassword now calls python 3, but now I am getting error ... Error load MySQLdb, check if MySQLdb is installed! I am trying to figure out how to install the MYSQL client on my UNRAID server ...google eveyhwere and Community app seems to only have the full DB server version. I seem to only be seeing the MYSQL DB, which I Do not want to install the entire DB if posssibe. any suggestions ?

OK ... so I am taking another stab at this .... following these instuctions on my UNRAID server, the linux steps from UNRAID console session. https://docs.ombi.app/guides/migrating-databases/#2-download-script-and-install-dependencies 1) Completed ... installed Python using nerd pack ... enabled version 3 of python, PIP and Python tools. 2) Downloaded the scripts and saved them in a UNRAID Share called Test. Extracted the files with ... - git clone https://github.com/vsc55/ombi_sqlite_mysql.git ombi_sqlite_mysql - cd ombi_sqlite_mysql - chmod +x *.py 3) Stopped OMBI UNRAID Docker container ... Create or Modify database.json to use mysql (all 3dbs into 1 OMBI DB on maria DB server) ... { "OmbiDatabase": { "Type":"MySQL", "ConnectionString":"MyServerIP;Port=3306;Database=Ombi;User=ombi;Password=MyPassword" }, "SettingsDatabase": { "Type":"MySQL", "ConnectionString":"MyServerIP;Port=3306;Database=Ombi;User=ombi;Password=MyPassword" }, "ExternalDatabase": { "Type":"MySQL", "ConnectionString":"MyServerIP;Port=3306;Database=Ombi;User=ombi;Password=MyPassword" } } on my UNRAID server console session cd to .... /mnt/user/Test/ombi_sqlite_mysql and ran ... python ombi_sqlite2mysql.py -c /etc/Ombi --only_db_json --host MyServerIP --db Ombi --user ombi --passwd MyPassword getting a bash error ... "bash: python: command not found" any ideas ? do I need to reboot my UNRAID server for the Python nerd tools enablig of python and PIP to take effect ? thanks, E

thanks tidusjar ... that was it ... in OMBI radaar settings I set the default availability to "in cinemas" ... working now. 🙂 as for the DB setup ... I'll try again to get the other 2 OMBI DBs on the Maria DB server. Has anyone got all 3 of thier OMB DBs running on maria DB server under MYSQL .. if so I would like to pick your brains on the setup. thanks, E

opened a ticket with OMBI ghithub. Thank you ghithub for all your support and thank you too, to the creators of all this open source knowing that this is a passionate hobby you do in you spare time and share with us. 🙂 To make a long story short I ended up re-doing just about everything .... I was able to get ombi.db on maria DB server under MYSQL I was not able to get my OmbiExternal.db & OmbiSettings.db to run on mariaDB server under MYSQL details of my hack and slash methods ... I’m not a DB or linux guy … my speciality is Windows, Windows AD & VMWare vShpere 7 administration & configuration and the support of VMs running on it. So please forgive me for this hack and slash method, but I am learning some stuff here. 🙂 I ended up redoing most of my setup. I got it working now but config is same as before. I was not able to get the ombi DBs à OmbiExternal.db & OmbiSettings.db to work on Maria DB server. The ombi DB is the only DB I have working on maria DB and the other 2 DBs remain in the UNRAID /appdata/ombi folder. If your curious this is what I tried … all these steps did not work as when I tried to launch the mgmt. GUI for OMBI it timed out. · Renamed my OMBI DB on my maria DB server to OMBI-old · On Maria DB using adminer docker app to connect to the DB on Maria DB server, Under privileges for users ran SQL command à drop user ombi (to delete OMBI local account) .. for the life of me could not figure out how to drop the user from the Adminer GUI. Lol J · Created the new Ombi DB on the maria server using adminer GUI · Created a new local db user called ombi & gave it full privs and grant rights to Ombi DB using Adminer GUI UNRAID Docker · I then created OmbiExternal.db & OmbiSettings.db DBs on maria DB server using Adminer GUI UNRAID Docker (so all 3 were MYSQL DBs) · For the life of me again I did not know how to grant local db user ombi access to the other 2 databases so then I did from SQL command prompt in the user privs section using Adminer docker GUI o GRANT ALL PRIVILEGES ON `Ombi_Settings`.* TO 'ombi'@'%' WITH GRANT OPTION o GRANT ALL PRIVILEGES ON `Ombi_External`.* TO 'ombi'@'%' WITH GRANT OPTION · Then In the GUI I ensured all 3 DBs had local DB user ombi with full rights and grant perms · Uninstalled OMBI and removed the image on unraid server · RE-installed OMBI · Launced OMBI to make sure it could connect to the local website … but stopped at the 1st page of the wizard screen · Stopped OMBI container. Now according to this article … https://docs.ombi.app/info/alternate-databases/#create-database-and-user I tried putting all 3 DBs on the maria server into 1 ombi DB with this database.json file … (please excuse any syntax errors with my copy and paste as I am a little bug eyed at the time of this writing.) { "OmbiDatabase": { "Type":"MySQL", "ConnectionString":"MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password=MyPassword" }, "SettingsDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password= MyPassword " }, "ExternalDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password= MyPassword " } } Did not work … so then I tried putting the 3 obi DBs on the Maria DB server with 3 different DBs and 3 different OMBI db local accounts … create local db users ombi2 & ombi3 and all 3 accounts respective full access and grant privs to their respective DBs. This was the databae.json file I used with this setup. { "OmbiDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password= MyPassword " }, "SettingsDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database= Ombi_Settings;User=ombi2;Password= MyPassword " }, "ExternalDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database= Ombi_External;User=ombi3;Password= MyPassword " } } This didn’t work either .. so I tried another method where 3 DBs on maria DB server but with 1 local db user ombi full access & grant privs to all 3 DBs. This is the database. Json file I used for this setup { "OmbiDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password= MyPassword " }, "SettingsDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database= Ombi_Settings;User=ombi;Password= MyPassword " }, "ExternalDatabase": { "Type":"MySQL", "ConnectionString":" MY-Server-IP;Port=3306;Database= Ombi_External;User=ombi;Password= MyPassword " } } So finally I went back to my original config … ombi db on maria DB server using MYSQL .. the other 2 dbs in UNRAID /appdat/ombi folder using SQLite … { "OmbiDatabase": { "Type":"MySQL", "ConnectionString":"Server=MY-Server-IP;Port=3306;Database=Ombi;User=ombi;Password=MYPasword" }, "SettingsDatabase": { "Type":"sqlite", "ConnectionString":"Data Source=Settings.db" }, "ExternalDatabase": { "Type":"sqlite", "ConnectionString":"Data Source=External.db" } } This last one worked … back to my original config. I ran thru the wizard and set up OMBI again. Had to redo almost all my OMBI settings including sonaar & radaar. It’s back up and working. Just one last issue to fix. For some reason after movie request has been approved it no longer goes into radarr (radaar and OMBI both version 4, but seeing errors in OMBI log referencing radaar movies calling API Ver 3 not sure why or if this is normal) …. Checked all the settings and tested connectivity from OMBI to radar .. successful. Sonarr works as expected .. no issues with sonaar. I will continue to dig deep on that … perhaps fixed in the next update of Radaar. 🙂 not sure if this will help any of you but wanted to share as you all have shared so much. I have been using UNRAID for a little under a year now and thanks to this forum I feel I am reaching a comfortable level of being a UNRAID admin. thanks all, E

hi all, Is it possible to just restore one app from a backup ? I have a good backup from last week and and I wish to just bring back one app OMBI... as the last OMBI update broke my OMBI. I am trying to avoid messing up my plex wathced DB. Last time I restored from backup I had to go into Plex and manaully mark all my TV show and Movie as watched that I had watched in the past 2 weeks after that backups restore date.

I tried ... - clearing we browser cache. - Different PC. - removed the .DB files in the OMBI appdata folder and restarted the container. - Tried using tags to point back to the last 2 version tags. All with the same result. Logon screen flashes fast then it goes into a endless Wizard of death (WOD). Forgot to add that it complains about not being able to autheticate with my Plex server, and when I try to create my standard local admin account for ombi, it say it's already there. If I ty to create a new local admin user account I get it complaining about "you need to setup a e-mail account" or something like that. The more I search the web the more I find that this has happened before with previous version upgrades. Exact same issues. I saw a post that it had been fixed but that was on linux forum, not UNRAID. I appear to be @ the mercy of template masters to release a new docker image with a fix. I've put all my settings back to what they were. I'll have to decompress and think some more. I only had the thing running for a couple weeks and was quite impressed and loved it. It's been a bad week. My media request server on the fritz .... my DJI drone messed up due to Tarif trade wars between China and US, US removing and disabling the DJI Fly app on Google play used to fly my drone: somewhat band-aided with a workaround but that too was a pain .... what next ?

good question ... thanks for the sugggestion ...just checked and I still have the database.json file in the OMBI appdata folder. It is correctly pointing to my UNRAID server IP and has the DB credentials set properly to talk to the OMBI DB on the maria DB server. The DB is still in maria DB server and all the tables appear to still be there.

HI Guys, lots of docker update this morning on my URAID SErver in lncluding OMBI, Plex, Sonarr & radarr. I updated all and now OMBI keeps getting stuck at the setup Wizard. Not sure what is going on here as prior to the updates OMBI was setup and working. When I try to launch the OMBI GUI it quickly displays the OMBI LOGON screen before going into the wizard .... no matter what I enter in the wizard it keeps looping back to the starting page of the wizard. I've searched the NET but have not seen a sloution to fix this. I would really hate to have to start all over from scratch as my OMBI server has a maria DB server backed ... lots of work to start all over again. - Plex version V# 4.76.1 - Sonarr V# 3.0.8.1507 - Radaar V# 4.1.0.6175 - OMBI V# 54d8..f74a - not entirely sure as I cannot luanch it ... this version # I grabbed from the update e-mail alert from my UNRAID server - MARIA DB V# MySQL version: 5.5.5-10.5.16-MariaDB-log any help or suggestions would be much appreciated. thanks, E

for those of you looking on my behalf please stop. Your efforts are much appreciated. Got it working. Found the API keys in sonarr & radarr in the ... Settings | General | Security | API field .. just copied and pasted this key into OMBI. AH-duh ! Searching all this time and did not see this info anywhere on the web. Guess because I was searching for OMBI and PLex API... should have searched for Radarr and Sonarr API. Maybe then I would have seen this option and could have saved myself 2 days of suffering from whitepapers rigomortis. 🙂 Weird place to put it, in the General Tab... nevertheless happy as a pig in mud now.

Ombi noobie requires a little help. All docker apps up to date as of today details ... - Unraid V6.9.2 - Plex - Jackett, Radarr , Sonarr, deluge, handbrake all set up and working perfectly - OMBI 80% confogured - email, Conencted to plex server, imported plex users connected to plex server - Ombi website properly setup and punched thru my firewall for remote access to OMBI site issue ... cannot add Sonarr and radarr PVR to Ombi... I have searched hi and low on the net reviewed all kinds of videos and cannot set this up. I cannot find the API settings in PLex under Dashboard advanced view so in the OMBI setup screen for Sonarr & Radaar API, I am trying to add the Jackett API as that is the only API key I can find. Can anynone tell me how to get the API Key settings to show up under dashboards in Plex. This way I can add a custom API key for OMBI in Plex. any suggestions ... thanks, E

Thanks for responding trurl .. I get it now. I was a ltitle confused but your explanation is clear. I too keep my array in good shape and have backups as well. AT work Im IT SYS admin\analyst and we only do stress tests on new standalone disks which have server OS installed even though these disks are mirrored at RAID 1 this the only place we do drive stress test\burnin. But the data drives in the SAN we never stress test, we just pop them in the array. I will go with not pre-clearing as if the drive fails I will simply replace it. Most new drives are pretty stable and very few arrive DOA unless they have been dropped in transit\delivery. My stress test will be the re-population of the data on the new drive. 🙂 thanks again, E Thanks so much.

Hi All, I'm planning to upgrade\increase size of some of the disks in my UNRAID array (regular SATA Drives). I know the process but am reviewing the pre-clear option. I'm running the current stable version of UNRAID V 6.9.2 & the pre-clear I have installed is no lonoger supported on this version. I did some more digging on the forums\youtube and apparently there is no need to pre-clear as when the new drive is added to the array UNRAID automatically does this (pre-clear) in the background and re-populates the new disk and allows you to still access the data using parity and the data on the other disks. came across this thread and I see that some of you are recommending using to install UD, UD Preclear, UD+ to be able to preclear a drive.... at 1st I thought this was as old thread, but I see posts are recent. Just curious as to why one would need to pre-clear if V 6.9.2 does it automatically. Again I'm still quite a newb to UNRAID and all my questions\facts is based on what I troll, so please correct me if I am wrong. My question is, is this all (manual Pre-clear) necessary ? and if so what are the Pros ? Cons ? I'm just trying to find the best method which works for me.

Thanks again for pointing me towards NetData Squid. Awesome app with so much detail with regards to operations on my box. 😁 I have removed cAdvisor as it will install from community app, but does not start up\run for me.

Thanks for the info Squid ... I already tried uninstall and re-install 2x ... app fails to start. I am installing NetData now. Thanks for the info. 😁

My cAdvisor stopped working today. I have this message in the fix common problems app ... "cadvisor (google/cadvisor:latest) has the following comments: This dockerHub repository has been deprecated and will no longer receive any updates. You should uninstall and reinstall the container from SelfHosters which utilizes the correct and updated repository from Google This application has been deprecated from Community Applications for that reason. While still functional, it is no longer recommended to utilize it." anyone else having this issue? I'm still a UNRAID nube so other than using the GUI I am not familiar with how to check this stuff at command prompt level. Appears to no longer be supported. I'm not entirely sure what the app does or if is needed, but I was just following a tutorial ... I believe it was a Space Invader 1 tutorial for must have apps and tuning. thanks, E

I was trying to add the username: "thumbto" ... I tried adding another name "errol", and it worked. I'm not sure what is going on here. I used the username "thumbto" to join to UNRAID server to my windows AD Domain. very strange indeed.

hhhmmm .... log says user already exists. but I don't see the name in the users console. Aug 10 04:00:34 ALLISON93 emhttpd: shcmd (3866): useradd -g users -d / -s /bin/false -c '' 'thumbto' Aug 10 04:00:34 ALLISON93 winbindd[92333]: [2021/08/10 04:00:34.307997, 0] ../../source3/winbindd/idmap_hash/idmap_hash.c:115(idmap_hash_initialize) Aug 10 04:00:34 ALLISON93 winbindd[92333]: idmap_hash_initialize: The idmap_hash module is deprecated and should not be used. Please migrate to a different plugin. This module will be removed in a future version of Samba Aug 10 04:00:34 ALLISON93 root: useradd: user 'thumbto' already exists A

Firefox, opera and edge ... don't work ... I'll continue to poke around the web and see if I can find anything to help me. I only found 1 thread about this issue which was corrected in the latest update .. which is older than the version I am running 6.9.2.

I hear yah Squid ... I figured that as google did not come up with much. Thanks for responding.

thanks for replying Constructor. I tried from 3 other machines on my network ... also tried from a direct console physical session on the UNRAID server itself. all with same result. all have the UNRAID server added to Trusted Sites. I am trying with Chrome. I'll try wth Edge, firefox and Opera and let you know if it works or not.

I'm new to UNRAID and have only been using it for about 4 days now. I'm new to UNRAID but not a newbie in the IT Tech field. MY UNRAID server is joined to my windows AD domain and now I'm trying to add local UNRAID accounts on the server for locked down share access ... as per the yourtube video below ... https://www.youtube.com/watch?v=cEeEr89dSXc I'm having the same issue on UNRAID 6.9.2 ... I cannot add a new user to the UNRAID server. Every time I try to create a new user, it looks like the user is being created as I see the typical UNRAID wave flashing up and down when a change is being made ... but the user account is not created and it yields no error messages. any suggestions ... thanks.