[Punk_Boy]

This is the result:

tcp 0 0 192.168.1.20:3306 0.0.0.0:* LISTEN 1129/mysqld


is this ok?

[nickr]

EDIT:


Here is my log:

http://xbmclogs.com/show.php?id=12207

can someone help me?

you are getting a lot of this:

DEBUG: VideoInfoScanner: Skipping dir 'smb://XBMCLIVE/Disco Interno HTPC/filmes/Wall-E/' due to no change

Which means you have previously scanned and no change is detected.

[Punk_Boy]

And that should cause any problem with mysql?

[Punk_Boy]

Did a fresh install of my server with xbmcbuntu.

Installed again everything acording the wiki. My advancedsettings.xml is like this:

<advancedsettings>
<useddsfanart>true</useddsfanart>
<cputempcommand>cputemp</cputempcommand>
<gputempcommand>gputemp</gputempcommand>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
<videodatabase>
<type>mysql</type>
<host>192.168.1.20</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.1.20</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>

added the sources again (just my movies), and still nothing. When i type SHOW DATABASES; on mysql it gives me this:

information_schema |
| mysql |
| performance_schema |
| test

So no XBMC databases.

My /etc/mysql/my.cnf is like this:

The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server...ables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 192.168.1.20
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Typed again

sudo netstat -tanp|grep 3306

and the result was the following:

tcp 0 0 192.168.1.20:3306 0.0.0.0:* LISTEN 4365/mysqld

What does this mean? What does LISTEN 4365/mysqld mean?

[nickr]

It means that process number 4365 (which is mysqld the mysql server daemon) is LISTENing for incoming connections on port 3306, on IP addresss 192.168.1.20. It is accepting connections from any IP address - 0.0.0.0:*

Which all looks good to me.

I assume you did this bit from the wiki?

Get into the MySQL command line utility: $mysql -u root -p
Enter the following commands:

Type in: CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; and press return
Type in: GRANT ALL ON *.* TO 'xbmc'; and press return

Close out the command line tool with \q

mysql logs somewhere in /var/log, take a look for the mysql logs and see if there are any clues.

[Punk_Boy]

Yes i have done that. What if instead of using my static ip i used 127.0.0.1 both on advancedsettings.xml and /etc/mysql/my.cnf?

[nickr]

That will work for one computer, but not for your others.

Try to log in to mysql as user xbmc

Code:

mysql -h 192.168.1.20 -u xbmc -p

you will be prompted for a password, it should also be xbmc. Do you then get a mysql prompt and welcome message?

Oh, ctrl-d to exit the mysql prompt.

[Punk_Boy]

Yes... I do that and i get a mysql prompt and welcome message.

Running out of options. Any other idea guys?

[Punk_Boy]

EDIT!!!!


FINALLLLYYY!!! Its working! Tha strangest thing is that i dont know i have done different!

Tks guys for your help!

Just one last question... now do i have to copy to the other htpc xbmc (clientes) only the advancedsettings.xml or do i also have to copy the sources.xml from the HTPC that has the mysql db?

Never mind only advancedsettings is needed.

Thank you all for your replys