On Tue, Dec 21, 2004 at 12:16:57PM +0100, Harald Lammers (Ordina) wrote: > Hello, > > Can anybody help me. I have a computer with Suse 9.1 and I use Tomcat > 5.0.28 and MySql 4.1.7-0 That is working. > > So I want to install MMBase 1.7.1 and everything looks ok. I've got only > a problem with the database. I don't know what I'm doing wrong. > > Can anybody help me. The error message after this message. > > Thanks > Best regards, > > Harald Lammers. > > ************************************************************************ > 2004-12-21 12:00:05,832 INFO mmbase.module.database.JDBC - Module > JDBC started (host: 'localhost' port: '3306' database: 'ryxintra' user: > 'ryxuser' driver: 'com.mysql.jdbc.Driver') > 2004-12-21 12:00:05,856 SERVICE mmbase.module.database.MultiPool - > Creating a multipool for database ryxuser containing : 25 connections, > which will be refreshed after 256 queries > 2004-12-21 12:00:06,021 INFO mmbase.module.database.JDBCProbe - JDBC > probe starting > 2004-12-21 12:00:06,424 ERROR mmbase.module.database.MultiPool - Could > not get all connections (25 failures, multipool size now 0 rather then > 25). First error: Unable to connect to any hosts due to exception: > java.net.ConnectException: Connection refused > > ** BEGIN NESTED EXCEPTION ** > > java.net.ConnectException > MESSAGE: Connection refused > > STACKTRACE: > > java.net.ConnectException: Connection refused
You probably have MySQL configured to only accept connections on Unix domain sockets (instead of via the loopback network). IIRC it's the default configuration on SuSE. JDBC doesn't support UNIX domain sockets. Try changing the "skip-networking" option in my.cnf Below is my version (with rediculously large max_allowed_packet option) which works for me: # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "/var/lib/mysql/my.cnf" to set server-specific options or # - "~/.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. # # 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... [client] #password = my_password 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 = -5 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 # Both location gets rotated by the cronjob. #log = /var/log/mysql.log log = /var/log/mysql/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # The skip-networking option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is "disable" - for security reasons. # skip-networking key_buffer = 16M max_allowed_packet = 60M thread_stack = 128K # # Query Cache Configuration # query_cache_limit = 1048576 query_cache_size = 26214400 query_cache_type = 1 # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin = /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # If you want to enable SSL support (recommended) read the manual or my # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt # 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 = 60M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M -- Joost. _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
