http://pastebin.com/TXLYsdWa
i renamed my database folder in userdata to databaseold just to try getting it to rebuild it but these are the results
You don't have permission to create databases for your mysql user. Grant it said permissions.
from bad to worse.
couldnt remember my mysql root password so i wiped out mysql and reinstalled. now i get this
http://pastebin.ubuntu.com/841835/
i can get into xbmc now, but cant scan any content to the library
You've created empty databases. Don't. All you need to do is grant your mysql user access to create databases - XBMC will do the rest.
jmarshall Wrote:You've created empty databases. Don't. All you need to do is grant your mysql user access to create databases - XBMC will do the rest.
i followed this
http://lifehacker.com/5634515/how-to-syn...-the-house
which i used in the dharma days, and did work.
all those databases that are the the xbmc log dont exist in mysql. in mysql it shows xbmc_video and xbmc_music. xbmc is going nuts looking for and adding numbers to the end in search of something. all i want to do is restart it all, rebuild the library and have mysql be happy. for now, i have removed advancedsettings.xml from the computer with mysql on it and xbmc works great. when i add advancedsettings.xml is when it goes to hell.
You should remove the <name> </name> section from the advanced settings, it is no longer needed in eden.
Mar16 Wrote:You should remove the <name> </name> section from the advanced settings, it is no longer needed in eden.
did this, it did not resolve the issue though
Kill the database you created. It's empty. Eden cannot understand it.
Eden's requirements are different than Dharma's.
jmarshall Wrote:Kill the database you created. It's empty. Eden cannot understand it.
Eden's requirements are different than Dharma's.
just drop the xbmc_music & xbmc_video from mysql?
jmarshall Wrote:Yes.
did that, still experiencing the same issue. do you need a new log?
I need you to do the following:
1. Drop the xbmc_video and xbmc_music db's from mysql.
2. Ensure the mysql user has the appropriate permissions to create databases.
3. Run XBMC and grab the debug log on boot.
I need the log from the very first run of XBMC after you've dropped the databases.
Cheers,
Jonathan
jmarshall Wrote:I need you to do the following:
1. Drop the xbmc_video and xbmc_music db's from mysql.
2. Ensure the mysql user has the appropriate permissions to create databases.
3. Run XBMC and grab the debug log on boot.
I need the log from the very first run of XBMC after you've dropped the databases.
Cheers,
Jonathan
here you go.
http://pastebin.com/eZGf5UsX
This is the log after following your instructions
Unfortunately it looks like you don't have debug logging on (Settings->System->Debugging)
What (if any) databases were created in sql from that run? Any at all?