Your dbmail.conf states: /var/run/mysql.sock
whereas your my.cnf states: /var/run/mysql/mysqld.sock ergo. Nataraj S Narayan wrote: > Hi Micah > > I can manually connect and see the contents of 'dbmail' database using > mysql client. > > I can also connect using mysql-admin ,with server as 'localhost'. > > I am attaching the my.cnf and debian.cnf . > > regards and thanks > > Nataraj > > Micah wrote: > >> >> Can you connect manually (using the mysql client) from the dbmail >> machine? >> >> Nataraj S Narayan wrote: >> >>> Hi Richard >>> >>> This is what i found :- >>> >>> wiredgsis:~# tail /var/log/mail.log >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> found value [dbmail] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> searching value for config item [user] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> found value >>> [root] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> searching value for config item [pass] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> found value >>> [rambo] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> searching valu e for config item [sqlport] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> found value >>> [3306] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> searching value for config item [sqlsocket] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: GetConfigValue(): >>> found value [/ var/run/mysql.sock] >>> Nov 4 17:32:18 localhost dbmail/adduser[4590]: dbmysql.c,db_connect: >>> mysql_real _connect failed: Can't connect >>> to MySQL server on 'ws077' (11 >>> >>> >>> regards >>> >>> Nataraj >>> >>> Richard Barrington wrote: >>> >>>> Hi Nataraj, >>>> >>>> It could be a few things, MySQL not running, bad password, etc, etc, so >>>> please set the dbmail trace level to 5 and post the relevant log >>>> entries. >>>> >>>> Thanks, >>>> Richard. >>>> >>>> On Wed, 2005-11-02 at 17:09 +0000, Nataraj S Narayan wrote: >>>> >>>> >>>>> Hi >>>>> >>>>> I am a new user. Getting the following. Is it a problem with mySql? >>>>> >>>>> I use Mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) >>>>> >>>>> >>>>> [EMAIL PROTECTED]:~/dbmail-2.0.7$ ./dbmail-users -a nataraj -w neetha >>>>> Opening connection to database... >>>>> Failed. Could not connect to database (check log) >>>>> Command failed. >>>>> [EMAIL PROTECTED]:~/dbmail-2.0.7$ Plz help >>>>> >>>>> regards >>>>> >>>>> Nataraj >>>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> _______________________________________________ >>> Dbmail mailing list >>> [email protected] >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> >> >> >> > > > ------------------------------------------------------------------------ > > # > # 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. > # > # For explanations see > # http://dev.mysql.com/doc/mysql/en/server-system-variables.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 > language = /usr/share/mysql/english > #(Unknown option:)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 =127.0.0.1 > #skip-networking = off > # > # * Fine Tuning > # > key_buffer = 16M > max_allowed_packet = 16M > thread_stack=128 > # > # * Query Cache Configuration > # > query_cache_limit = 1048576 > query_cache_size = 16777216 > query_cache_type = 1 > # > # * Logging and Replication > # > # Both location gets rotated by the cronjob. > # Be aware that this log type is a performance killer. > log = /var/log/mysql.log > #log = /var/log/mysql/mysql.log > # > # Error logging goes to syslog. This is a Debian improvement :) > # > # 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 > # See /etc/mysql/debian-log-rotate.conf for the number of files kept. > max_binlog_size = 104857600 > #binlog-do-db = include_database_name > #binlog-ignore-db = include_database_name > # > # * BerkeleyDB > # > # The use of BerkeleyDB is now discouraged and support for it will probably > # cease in the next versions. > #(Unknown option:)skip-bdb > # > # * 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 Feature > # > # 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.gz > # ssl-ca=/etc/mysql/cacert.pem > # ssl-cert=/etc/mysql/server-cert.pem > # ssl-key=/etc/mysql/server-key.pem > innodb_data_file_path = ibdata1:10M:autoextend > > > > > > #Don't allow connections via TCP/IP. > #skip-networking > > > > > > > [mysqldump] > quick > quote-names > max_allowed_packet = 16M > > [mysql] > #no-auto-rehash # faster start of mysql but no tab completition > > [isamchk] > key_buffer = 16M > > > ------------------------------------------------------------------------ > > # Automatically generated for Debian scripts. DO NOT TOUCH! > [client] > host = localhost > user = debian-sys-maint > password = z7U1oEP1xaiFrNx4 > socket = /var/run/mysqld/mysqld.sock > > > ------------------------------------------------------------------------ > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens mailto:[EMAIL PROTECTED] NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] The Netherlands________________________________http://www.nfg.nl
