How to clear the Music or Movies database in XBMC

If you want to start from scratch with adding new music or movies to the XBMC meta database, you can remove the MyMusic7.db or MyVideos34.db

In my case I had to remove it from two places

C:\Users\user1\AppData\Roaming\XBMC\userdata\Database

and in

C:\Program Files (x86)\XBMC\portable_data\userdata\Database

This was due to multiple beta installations of XBMC

Using XBMC on my ASUS EEE Box 1012P

 

Because the ASUS EEE Box 1012P is shipped with Windows 7, I first installed XBMC 10.0 (released 19-dec-1010). on Windows 7.

Installation

– Download XBMC 10.0 from http://xbmc.org/download/

– Next Next Finish installation.

 

Network Share

– Create a network share, so all sources in the XBMC database will be pointed to the network share. This ensures you are able to use a shared MySQL database on all XBMC installations in you’re house.

– Created the following folders on the network share

  • Internet Radio (pls files)
  • Movie (Cinema movies)
  • Music (Constains a folder per album with the name Artist – Albumname)
  • Pictures (Contains all pictures)
  • Videos (contains home video’s)

 

 

XBMC > Settings

 

Setting Value
Add-Ons > Album information AllMusic
Add-Ons > Album information Last.FM
Add-Ons > Artist information AllMusic
Add-Ons > Artist information Last.FM
Add-Ons > Movie information IMDb
Add-Ons > Movie information Moviemeter
Add-Ons > Program Add-Ons XBMC Library Auto Update
Add-Ons > Skins Transparency!
Add-Ons > Subtitles XBMC Subtitles
Add-Ons > TV information The TVDB
Appearance > Skin Transparency!
Appearance > International > Region Central Europe
Appearance > File lists Allow file renaming and deletion
Appearance > Screensaver Use visualization if playing audio [Disable]
Music > Library Download additional information during updates
Music > Library Update library on startup
Music > Playback > Visualization None
Music > Audio CDS Play adio CDs automatically
Music > Audio CDS > Bitrate 320 kbs
Network > Services Share video and music libraries through UPnP
Network > Services Allow control of XBMC via UPnP
Network > Services Allow control of XBMC via HTTP
Network > Services Allow programs on other systems to control XBMC
Pictures > File Lists Show video files in listings
Pictures > Slideshow Disable "Use pan and zoom effects"
Skin Settings > General Enable auto scrolling for plot & review
Skin Settings > General Movies – Use extra fanart
Skin Settings > General Movies – Use extra thumbs
Skin Settings > General TV shows – Use posters
Skin Settings > General TV shows – Use extra fanart
Skin Settings > General Music – Use extra fanart
Skin Settings > General Show fanart slideshow instead of visualization
– Disable pan and zoom effects
Skin Settings > General Enable touchscreen modus
Skin Settings > Scripts Show subtitle script button in OSD
Select script: XBMC Subtitles
Skin Settings > Menu Favorites
System > Audio Ouput > Audio output Optical/Coax
System > Audio Ouput > Speaker Configuration 5.1
System > Audio Ouput > Audio output device default
System > Input devices Remote control sends keyboard presses
System > Video output Fullscreen
System > Power Saving Shutdown function: Suspend
Video > DVDs Play DVDs automatically
Video > DVDs Attempt to skip introduction before DVD menu
Weather Breda
Bergen op Zoom
De Bilt

 

 

 

.

Using XBMC on mine ASROCK 330 Pro

 

Replacing the stock fans
First thing I did was updating the bios to the latest version and replacing the stock fans by more silent fans, because this reduced the sound level significantly. I used the  Noiseblocker BlackSilent XM2, 40mm and Noiseblocker BlackSilent XM1, 40mm. Used the XM1 to blow air out of the asrock 330 Pro and de XM2 to blow air over the cpu and gpu.

 

Create XBMC Live DVD
I downloaded the XBMC Live CD from the [http://xbmc.org/download/]. Right click the ISO and choose [Open with] > Windows Disc Image Burner and burn the ISO to a DVD. Start the Asrock 330 Pro and boot from the DVD.

 

Rember username and password
Remember the Username and Password you enter during setup. It will be needed when you want to access XBMC remotely with SFTP.

 

Setting up SFTP root access, step 1
– Download putty from: "http://www.putty.org/"
– Start Putty and type in the IP address of XBMC to connect.
– Username: As entered during installation of XBMC live
– Password: As entered during installation of XBMC live
– Enter the commando: sudo passwd root
This will prompt you to change the root password, use the same password as entered during installation of XBMC live.
– Close Putty.

 

Setting up SFTP root access, step 2

Start a free program like WinScp or FileZilla and connect to XBMC live:
Host: sftp://xxx.xxx.xxx.xxx (IP address can be found in XBMC live on the System > Network)
Port: 22
Username: root
Password: As entered during installation of XBMC live

You now have root access to XBMC Live and can see/edit any folder on the system.

image

 

XBMC Settings

Setting Value
System > Appearance > Skin Transparency!
System > Appearance > International > Region Central Europe
System > Appearance > File lists Allow file renaming and deletion
System > Appearance > Screensaver Use visualization if playing audio [Disable]
System > Input devices Remote control sends keyboard presses
System > Audio Ouput > Audio output Optical/Coax
System > Audio Ouput > Speaker Configuration 5.1
System > Audio Ouput > Audio output device iec958
Network > Services Share video and music libraries through UPnP
Network > Services Allow control of XBMC via UPnP
Network > Services Allow control of XBMC via HTTP
Network > Services Allow programs on other systems to control XBMC
Weather Breda

 

 

Enable SAMBA
If you want to access the internal hard disk of the asrock 330 pro, from you’re Windows pc, you can use SAMBA

Start putty and connect to XBMC live in my case: 192.168.1.19
Username: root
Password: As entered during installation of XBMC live

Enter commandos

apt-get update
To update sources

sudo apt-get install samba
This will install samba and start it running

nano /etc/samba/smb.conf
This will open the samba configuration for editing

Copy and paste the following lines at the end of the file
[xbmc home]
comment = XBMC Home Share
path = /home/xbmc
force user = xbmc
inherit permissions = yes
read only = No
guest ok = Yes

[xbmc system]
comment = XBMC System Share
path = /home/xbmc/.xbmc
force user = xbmc
inherit permissions = yes
read only = No
guest ok = Yes

Ctrl + x followed by Y to save the file
– After rebooting the XBMC live, you can access the two shares created in Windows explorer by just entering the IP address, like \\192168.1.19

More info
Most information I found at: [http://redherring2.wordpress.com/2009/06/11/xbmc-live-asrock-ion-330-setup-guide/]
– After applying the "Judder free video improvements" patch described on this blog post my mkv files played flowless.

Dutch internet radio play list for XMBC

If you want to listen to Internet Radio in XBMC, you can save one of the *.pls or *.m3u files on the site [http://www.harmfrielink.nl/wiki/index.php/Internet_Radio], to a location where XBMC can open the file. Like a network share or local disk folder.

 

To add the Q-Music internet radio stream to XBMC:

image

  • Click on Add source

image

  • Add the folder containing the *.pls or *.m3u file and click on OK

image

  • Now click in the new folder, in my case [Internet Radio]

image

 

  • Click on the added *.pls or *.m3u playlist

image

 

 

For more information, see: http://wiki.xbmc.org/index.php?title=HOW-TO_play_internet_video_and_audio_streams