postgresql database and ATV2
#1
Hi all,

I couldn't find this in any other thread, and hopefully it is in the right forum... Please move if it's not!

I have an ATV2 running the latest nightly (20111104).
I have an Ubuntu server running, with postgresql up and going.
I have created the user/database in postgres already, and it seems to be read by xbmc on startup, but not actioned...

Code:
17:03:51 T:107352064  NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)
17:03:51 T:107352064  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
17:03:51 T:107352064  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>postgresql</type>
                                                <host>10.0.0.1</host>
                                                <port>5432</port>
                                                <user>xbmc</user>
                                                <pass>PASSWORD</pass>
                                                <name>xbmc_video</name>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>postgresql</type>
                                                <host>10.0.0.1</host>
                                                <port>5432</port>
                                                <user>xbmc</user>
                                                <pass>PASSWORD</pass>
                                                <name>xbmc_music</name>
                                              </musicdatabase>
                                            </advancedsettings>
17:03:51 T:107352064 WARNING: VIDEO database configuration is experimental.

The problem is every connection is still trying sqlite on the ATV2, e.g
Code:
17:57:47 T:105521152   DEBUG: Connecting to sqlite:/var/mobile/Library/Preferences/XBMC/userdata/Database/:MyVideos57.db

Any ideas how I can get XBMC on ATV2 to link to a postgres db?
Reply
#2
i don't think we support postgresql ... only masql and sqlite afaik
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply
#3
Memphiz Wrote:i don't think we support postgresql ... only masql and sqlite afaik

Well this is crappy Smile
Can you point a beginner to what needs to be updated? There wouldn't be too many changes needed between mysql and postgres. I am happy to hack something out till it works... And once something is there, maybe someone will pick it up and tweak it a bit more anyway Smile

Cheers
Reply
#4
maybe you should ask in the generic development forum ...
AppleTV4/iPhone/iPod/iPad: HowTo find debug logs and everything else which the devs like so much: click here
HowTo setup NFS for Kodi: NFS (wiki)
HowTo configure avahi (zeroconf): Avahi_Zeroconf (wiki)
READ THE IOS FAQ!: iOS FAQ (wiki)
Reply

Logout Mark Read Team Forum Stats Members Help
postgresql database and ATV20