# DBRepair development

**URL:** https://forums.plex.tv/t/dbrepair-development/822684
**Category:** Apps & Creations
**Created:** [December 14, 2022, 3:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684 "2022-12-14T03:57:23Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 3:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684/1 "2022-12-14T03:57:23Z")

</div>

Any chance you could make it support binhex-plexpass docker? My library db is 1.4gb and my blobs one is 4.09 gb. #\_# I may need helps lol..

I asked cause I got this error below when attempting to execute it inside my docker container for binhex

Error: Unknown host. Currently supported hosts are: QNAP, Synology, Netgear, Mac, ASUSTOR, WD (OS5) and Linux Workstation/Server

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:10am UTC](https://forums.plex.tv/t/dbrepair-development/822684/2 "2022-12-14T04:10:20Z")

</div>

@Jerky_san

NO PROBLEM.

Would you please go into the container and see what PID 1 is?

I am looking for `/bin/s6-svscan` .

I will gladly add for binhex.

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:14am UTC](https://forums.plex.tv/t/dbrepair-development/822684/3 "2022-12-14T04:14:52Z")

</div>

PID1 is → dumb-init

 ![image](https://global.discourse-cdn.com/plex/original/4X/d/6/4/d64ddf1ef614138cee635322f945c320f7f41a44.png)

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:22am UTC](https://forums.plex.tv/t/dbrepair-development/822684/4 "2022-12-14T04:22:49Z")

</div>

Would you be willing to try this?

I’ve decided to try being _swoopy_ and use cgroup detection. 🤞

I’ve not yet pushed this to github.

[DBRepair.tar](https://forums.plex.tv/uploads/short-url/wk2Tbo2WmVRAlNcoTu7PSnIJ02u.tar) (40 KB)

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:30am UTC](https://forums.plex.tv/t/dbrepair-development/822684/5 "2022-12-14T04:30:55Z")

</div>

still gives

Error: Unknown host. Currently supported hosts are: QNAP, Synology, Netgear, Mac, ASUSTOR, WD (OS5) and Linux Workstation/Server  
Error: Unknown host. Currently supported hosts are: QNAP, Synology, Netgear, Mac, ASUSTOR, WD (OS5) and Linux Workstation/Server

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:32am UTC](https://forums.plex.tv/t/dbrepair-development/822684/6 "2022-12-14T04:32:45Z")

</div>

Please show me the output of

```auto
cat /proc/1/cgroup | grep docker

```

Asking because the detection works here

```auto
root@dockerplex:/# cd /config
root@dockerplex:~# ls
DBRepair.sh Library plexmediaserver_1.29.2.6273-2b1f0cbcd_amd64.deb tmp transcode
root@dockerplex:~# ./DBRepair.sh 
Plex Media Server is currently running, cannot continue.
Please stop Plex Media Server and restart this utility.
root@dockerplex:~# ls /
bin	data glock init lib32 libx32 opt proc	sbin tmp var
boot	dev healthcheck.sh installBinary.sh	lib64 media plex-common.sh root	srv transcode version.txt
config	etc home lib libexec mnt plex_service.sh run	sys usr
root@dockerplex:~# /plex_service.sh -d
root@dockerplex:~# ./DBRepair.sh 
 
 
 
      Plex Media Server Database Repair Utility (Docker)
 
Select
 
  1. Check database
  2. Vacuum database
  3. Reindex database
  4. Attempt database repair
  5. Replace current database with newest usable backup copy
  6. Undo last successful action (Vacuum, Reindex, Repair, or Replace)
  7. Import Viewstate / Watch history from another PMS database
  8. Show logfile
  9. Exit
 
Enter choice: 1
 
Checking the PMS databases
Check complete. PMS main database is OK.
Check complete. PMS blobs database is OK.
^C
root@dockerplex:~# grep cgroup DBRepair.sh 
  elif ["$(grep docker /proc/1/cgroup | wc -l)" -gt 0] && [-d "/config/Library/Application Support"]; then
root@dockerplex:~# 
 

```

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:33am UTC](https://forums.plex.tv/t/dbrepair-development/822684/7 "2022-12-14T04:33:28Z")

</div>

sh-5.1# cat /proc/1/cgroup | grep docker  
13:name=elogind:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
12:pids:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
11:hugetlb:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
10:net\_prio:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
9:perf\_event:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
8:net\_cls:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
7:freezer:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
6:devices:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
5:memory:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
4:blkio:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
3:cpuacct:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
2:cpu:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec  
1:cpuset:/docker/e19802544d10cea249765db2cbc12d74492853c9dfb7128c9e2c56b41ea9c9ec

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:33am UTC](https://forums.plex.tv/t/dbrepair-development/822684/8 "2022-12-14T04:33:55Z")

</div>

OK… so the detection works fine. It knows it’s in a container.

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:34am UTC](https://forums.plex.tv/t/dbrepair-development/822684/9 "2022-12-14T04:34:40Z")

</div>

repeat this? Confirm you have the docker detection?

```auto
root@dockerplex:~# grep cgroup DBRepair.sh 
  elif ["$(grep docker /proc/1/cgroup | wc -l)" -gt 0] && [-d "/config/Library/Application Support"]; then
root@dockerplex:~# 

```

Or isn’t `/config/Library/Application Support` used in binhex ?

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:35am UTC](https://forums.plex.tv/t/dbrepair-development/822684/10 "2022-12-14T04:35:48Z")

</div>

> [@ChuckPa](#):
>
> `grep cgroup DBRepair.sh `

sh-5.1# grep cgroup DBRepair.sh  
elif [“$(grep docker /proc/1/cgroup | wc -l)” -gt 0] && [-d “/config/Library/Application Support”]; then

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:36am UTC](https://forums.plex.tv/t/dbrepair-development/822684/11 "2022-12-14T04:36:25Z")

</div>

something isn’t adding up. Do you have `/config/Library/Application Support` and is it readable by the docker UID ?

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:38am UTC](https://forums.plex.tv/t/dbrepair-development/822684/12 "2022-12-14T04:38:18Z")

</div>

not in the root… i’m searching for where it’s located.

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:43am UTC](https://forums.plex.tv/t/dbrepair-development/822684/13 "2022-12-14T04:43:52Z")

</div>

> [@Jerky\_san](#):
>
> /config/Library/Application Support

So I have /config/Plex Media Server/ which then has

 ![image](https://global.discourse-cdn.com/plex/original/4X/6/e/8/6e8b7276ab64b5815c32dce4af2f55c76df4775a.png)

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:45am UTC](https://forums.plex.tv/t/dbrepair-development/822684/14 "2022-12-14T04:45:07Z")

</div>

LOL… Just _ **HAD** _ to be different, huh? 🤣

How should I list this? " BinHex " or “BINHEX” or ???

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:46am UTC](https://forums.plex.tv/t/dbrepair-development/822684/15 "2022-12-14T04:46:03Z")

</div>

Guess BINHEX or lowercase binhex 🙂 whatevers

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:47am UTC](https://forums.plex.tv/t/dbrepair-development/822684/16 "2022-12-14T04:47:20Z")

</div>

Open the code please and look at this block

```auto
  # Docker (All docker variants)
  elif ["$(grep docker /proc/1/cgroup | wc -l)" -gt 0] && [-d "/config/Library/Application Support"]; then

    PLEX_SQLITE="/usr/lib/plexmediaserver/Plex SQLite"
    AppSuppDir="/config/Library/Application Support"
    PID_FILE="$AppSuppDir/Plex Media Server/plexmediaserver.pid"
    DBDIR="$AppSuppDir/Plex Media Server/Plug-in Support/Databases"
    LOGFILE="$DBDIR/DBRepair.log"
    LOG_TOOL="logger"

    HostType="Docker"
    return 0

```

Except for `AppSuppDir` being different, does the rest match inside your container ?

Of importance: `/usr/lib/plexmediaserver`, `logger`, PID\_FILE

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:49am UTC](https://forums.plex.tv/t/dbrepair-development/822684/17 "2022-12-14T04:49:11Z")

</div>

Use PLEX\_SQLITE appears to be correct  
PID is in the correct location  
DBs in correct location

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:49am UTC](https://forums.plex.tv/t/dbrepair-development/822684/18 "2022-12-14T04:49:36Z")

</div>

standby please. adjusting for maximum 🔥

---

<div class="post-metadata">

### Author: ![Jerky\_san](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jerky\_san](https://forums.plex.tv/u/Jerky_san)
#### Post date: [December 14, 2022, 4:57am UTC](https://forums.plex.tv/t/dbrepair-development/822684/20 "2022-12-14T04:57:19Z")

</div>

It tried to executed(I didn’t have plex stopped) trying to figure out how to force it to stop but does seem to got through the OS checks.

---

<div class="post-metadata">

### Author: ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)
#### Post date: [December 14, 2022, 4:58am UTC](https://forums.plex.tv/t/dbrepair-development/822684/21 "2022-12-14T04:58:09Z")

</div>

My checks are for the main containers so yeah, at this point, it’ll NOT stop if Plex is running.

I _thought_ you had plex stopped so we could develop this ?

Are there any control scripts at the top (root directory) ?

Is there anything in /etc to launch it ?

[Next page](https://forums.plex.tv/t/dbrepair-development/822684.md?page=2)
