LinHES Forums
http://forums.linhes.org/

lircd invaded mythconverg.settings
http://forums.linhes.org/viewtopic.php?f=6&t=22396
Page 1 of 1

Author:  nebulous [ Fri Jan 06, 2012 9:07 am ]
Post subject:  lircd invaded mythconverg.settings

After a recent pacman -Syu which included a lircd upgrade something weird happened. Something that happened once before, but it was in the fog of a major upgrade, so I didn't pursue the issue further.

My settings table is overrun by lircd as if there was a greedy sql update somewhere in an upgrade script. Here's a sample of what I mean:

Code:
+----------------------------------------------------+---------------------+-----------+
| value                                              | data                | hostname  |
+----------------------------------------------------+---------------------+-----------+
| StereoPCM                                          | /var/run/lirc/lircd | specticle |
| LCDHeartBeatOn                                     | /var/run/lirc/lircd | specticle |
| LCDShowGeneric                                     | /var/run/lirc/lircd | specticle |
| TVVidModeResolution0                               | /var/run/lirc/lircd | specticle |
| UseVideoModes                                      | /var/run/lirc/lircd | specticle |
| UseFixedWindowSize                                 | /var/run/lirc/lircd | specticle |
| RunFrontendInWindow                                | /var/run/lirc/lircd | specticle |
| GuiSizeForTV                                       | /var/run/lirc/lircd | specticle |
| ThemePainter                                       | /var/run/lirc/lircd | specticle |
| SelChangeRecThreshold                              | /var/run/lirc/lircd | specticle |
| WatchTVGuide                                       | /var/run/lirc/lircd | specticle |
| EPGShowCategoryColors                              | /var/run/lirc/lircd | specticle |
| BrowseChannelGroup                                 | /var/run/lirc/lircd | specticle |
| ChannelOrdering                                    | /var/run/lirc/lircd | specticle |
| SubtitleCodec                                      | /var/run/lirc/lircd | specticle |
| OSDCC708TextZoom                                   | /var/run/lirc/lircd | specticle |
| OSDSubFont                                         | /var/run/lirc/lircd | specticle |
| Prefer708Captions                                  | /var/run/lirc/lircd | specticle |
| DefaultCCMode                                      | /var/run/lirc/lircd | specticle |
| BrowseAllTuners                                    | /var/run/lirc/lircd | specticle |
| EnableMHEG                                         | /var/run/lirc/lircd | specticle |
| ExactSeeking                                       | /var/run/lirc/lircd | specticle |
| FFRewReposTime                                     | /var/run/lirc/lircd | specticle |
| SmartForward                                       | /var/run/lirc/lircd | specticle |
| PlaybackWLBlackOut                                 | /var/run/lirc/lircd | specticle |
| PlaybackWLMaxAge                                   | /var/run/lirc/lircd | specticle |
| PlaybackWLStart                                    | /var/run/lirc/lircd | specticle |
| DisplayGroupTitleSort                              | /var/run/lirc/lircd | specticle |
| DispRecGroupAsAllProg                              | /var/run/lirc/lircd | specticle |
| RememberRecGroup                                   | /var/run/lirc/lircd | specticle |
| QueryInitialFilter                                 | /var/run/lirc/lircd | specticle |
| PIPLocation                                        | /var/run/lirc/lircd | specticle |
| AdjustFill                                         | /var/run/lirc/lircd | specticle |
| AspectOverride                                     | /var/run/lirc/lircd | specticle |
...


Of course some time in the dark ages of limited hdd space, I turned off database backups, so I'll have to fix it manually. That's fine, this is free, but I'd like to help contribute to a more permanent solution. Anyone else experienced this, or familiar enough with the Arch package system to know where to look?

Author:  jams [ Fri Jan 06, 2012 9:59 am ]
Post subject: 

my guess is it's the lirc.install script that did it.
http://linhes.org/bugs/projects/linhes/ ... rc.install

The post_upgrade section of the script will be run everytime the lircd package is updated via pacman.
Whats it's attempting todo is update the location of the lircd socket, but obviously something went wrong.

Author:  jams [ Fri Jan 06, 2012 10:10 am ]
Post subject: 

From the look of it, the update setting needs a 2nd where clause.
Otherwise it will do exactly as you saw and update all the settings for that host

Author:  nebulous [ Fri Jan 06, 2012 10:40 am ]
Post subject: 

Hah. Ok, yeah that's a pretty simple bug once you pointed out where to look.

Code:
"UPDATE settings SET data = '/var/run/lirc/lircd' WHERE hostname = '${hostname}';"


needs to change to

Code:
"UPDATE settings SET data = '/var/run/lirc/lircd' WHERE value='LircSocket' and hostname = '${hostname}';"


I'm wondering why this hasn't affected lots of other people yet?

Author:  nebulous [ Fri Jan 06, 2012 10:43 am ]
Post subject: 

I'll be happy to file a bug/patch or commit the change to git if given a writable git url. Guess I should see how to go about creating a repo account before blabbing in the forums.

Author:  jams [ Fri Jan 06, 2012 11:15 am ]
Post subject: 

I would create a bug at linhes.org/bugs and someone will apply the change.

Write access to the linhes repo is limited, but read access is not.

Author:  nebulous [ Fri Jan 06, 2012 11:47 am ]
Post subject: 

Filed Bug #810.

Author:  jams [ Fri Jan 06, 2012 12:36 pm ]
Post subject: 

Thanks nebulous.

lircd has been updated in both testing and release.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/