Nataraj S Narayan wrote:
> 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'.
Aaarrghh. Don't do that!
>
> So this means I may not be able to connect from network?
No. It just means dbmail will only talk to mysql running on localhost.
The imap/pop/lmtp daemons will still be reachable.
>
> 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 ?
is nataraj the dbmail database?
if not try something along the lines of:
adduser dbmail
addgroup dbmail
sed -i -e 's/^EFFECTIVE_USER=.*/EFFECTIVE_USER=dbmail/' \
/etc/dbmail.conf
sed -i -e 's/^EFFECTIVE_GROUP=.*/EFFECTIVE_GROUP=dbmail/' \
/etc/dbmail.conf
sed -i -e 's/^user=.*/user=dbmail/' \
/etc/dbmail.conf
chown dbmail:dbmail /etc/dbmail.conf
chmod 600 /etc/dbmail.conf
mysql>GRANT ALL ON dbmail.* TO [EMAIL PROTECTED] identified by 'mypasswd';
etc...
>
>
> 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
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
