HifiBerry DAC2 HD support

[gregvds]

If I reorder entries by id in cfg_audiodev, should I update the hash again? - Answered: yes!!!

I don't like that the new HiFiBerry DAC2 HD entry is at the back of the list, I'd rather prefer to find it with the other HiFiBerry entries, hence I'm in a small python script to do that :-). But once it's done, should the hash be updated?

Thanks

Edit:

ssh into your moode,
sudo nano /tmp/switchid.py

copy paste the code here under :

Code:

#!/usr/bin/python3

# This script helps to reorganize the entries in the cfg_audiodev to place a new
# entry at a given place in MoOde.
# this script assume there are no current ID + 1000 value in the table! You
# should check first this is true!

import sys, getopt, os

def main(argv):
 currentId = ''
 newId = ''
 try:
    opts, args = getopt.getopt(argv,"c:n:",["cid=","nid="])
 except getopt.GetoptError:
    print ('test.py -c <currentId> -n <newId>')
    sys.exit(2)
 for opt, arg in opts:
    if opt == '-h':
       print ('test.py -c <currentId> -n <newId>')
       sys.exit()
    elif opt in ("-c", "--cid"):
       currentId = arg
    elif opt in ("-n", "--nid"):
       newId = arg
 if currentId == '' or newId == '':
    print ('test.py -c <currentId> -n <newId>')
    sys.exit(2)

 print ('Current ID is ', currentId)
 print ('New ID is ', newId)

 tempId = int(currentId) + 1000
 command = os.popen('sudo sqlite3 /var/local/www/db/moode-sqlite3.db " UPDATE cfg_audiodev SET id = %s WHERE id = %s;"' % (tempId, currentId)).read()
 print(command)

 for id in range(int(currentId)-1, int(newId)-1, -1):
    command = os.popen('sudo sqlite3 /var/local/www/db/moode-sqlite3.db " UPDATE cfg_audiodev SET id = %s WHERE id = %s;"' % (id+1, id)).read()
    print(command)

 command = os.popen('sudo sqlite3 /var/local/www/db/moode-sqlite3.db " UPDATE cfg_audiodev SET id = %s WHERE id = %s;"' % (newId, tempId)).read()
 print(command)


if __name__ == "__main__":
 main(sys.argv[1:])

ctrl + x, enter to save and exit nano.

execute it like this:

python switchid.py -c 75 -n 47 (-c the current id of my entry in cfg_audiodev (HiFiBerry DAC2 HD), -n the place I want to find it in the list of devices in audio config GUI).

You'll have to recreate hash as explained by Mystic here on top of the thread like this:

sudo sqlite3 /var/local/www/db/moode-sqlite3.db "SELECT * FROM cfg_audiodev WHERE drvoptions NOT IN ('slave', 'glb_mclk') AND chipoptions = ''" > /tmp/moode-devices-new.txt
php -r 'echo md5(file_get_contents("/tmp/moode-devices-new.txt"));'

copy-paste the output, this should be something like this c8f05964fff3b968a21d09d0f57c1174

sudo sqlite3 /var/local/www/db/moode-sqlite3.db "DROP TRIGGER ro_columns"
sudo sqlite3 /var/local/www/db/moode-sqlite3.db "UPDATE cfg_hash SET value='YOUR_HASH_VALUE_HERE' WHERE id=8"
sudo sqlite3 /var/local/www/db/moode-sqlite3.db "CREATE TRIGGER ro_columns BEFORE UPDATE OF param, value, [action] ON cfg_hash FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'read only'); END"

and then

sudo reboot

It worked for me on MoOde 7.0.1.

Pay attention that the python script assumes there is no entries with ID = currentId + 1000 value!!!

All the best,

Greg