> Hi Paul > > Got it this time! Now its working. > > Commented out the 'sqlsocket'. Then gave host as 'localhost', instead of > IP Address. > > Changed user to 'root'. > > So this means I may not be able to connect from network? > > My question is, why doesnt 'user=nataraj' work when I have given > > GRANT ALL ON nataraj.* TO [EMAIL PROTECTED] identified by 'mypasswd' ; > > in Mysql client ? >
Did you do a 'flush privileges;' after the grant command? > > regards > > Nataraj > > > > Paul J Stevens wrote: > >>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 >>>>>Dbmail@dbmail.org >>>>>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 >>>Dbmail@dbmail.org >>>https://mailman.fastxs.nl/mailman/listinfo/dbmail >>> >>> >> >> >> >> > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > >
