connectino to mysql server failed....?!?

[GG]

hi
I've gone through the docs and managed to complie the sendmail using sql patch etc.. not so many problems encountered... but when I was trying to start sendmail, I get error in my logs, can anyone tellme what I can do to fix this?

here is the info on my system:

Sep 17 01:22:39 prati sendmail[9413]: Connection to MySQL server failed(Unknown MySQL Server Host '<localhost>' (1))
Sep 17 01:26:51 prati sendmail[9425]: starting daemon (8.12.9/SQL-8.12.9-18): SMTP+queueing@00:15:00
Sep 17 01:26:51 prati sendmail[9425]: started as: /usr/sbin/sendmail -bd -q15m

btw.
I'm running Linux 9.0 and my /etc/mail/sqlmail.conf file looks like:

cat sqlmail.conf
#############################
# MySQL Config for Sendmail #
#############################

MysqlSocket             </var/lib/mysql/mysql.sock>
MysqlHost               <127.0.0.1>
MysqlUsername           <sendmail>
MysqlPassword           <>
MysqlDatabase           <mail_svaka_net>
MysqlUserTable          <users>
MysqlAliasTable         <alias>
#MysqlMapTable           <tables used for maps>
MysqlLHSColumn          <address>
MysqlRHSColumn          <alias>

if I comment out MysqlHost, I get the error:
Sep 17 01:00:52 prati sendmail[9262]: starting daemon (8.12.9/SQL-8.12.9-18): SMTP+queueing@00:15:00
Sep 17 01:00:52 prati sendmail[9262]: started as: /usr/sbin/sendmail -bd -q15m
Sep 17 01:00:52 prati sendmail[9263]: Connection to MySQL server failed(Can't connect to local MySQL server through socket '</var/lib/mysql/mysql.sock>' (2))

yea, and my sendmail.mc file looks like this:

divert(0)dnl
VERSIONID(`BOGOMAIL setup for SVAKA.NET')
OSTYPE(linux)dnl
DOMAIN(generic)dnl
dnl #
dnl ##
define(`confDEF_USER_ID',``8:12'')dnl
define(`confTRUSTED_USER', `smmsp')dnl
define(`confTO_CONNECT', `1m')dnl
define(`confTRY_NULL_MX_LIST',true)dnl
define(`confDONT_PROBE_INTERFACES',true)dnl
define(`PROCMAIL_MAILER_PATH',`/usr/bin/procmail')dnl
define(`UUCP_MAILER_MAX', `2000000')dnl
define(`confPRIVACY_FLAGS', `authwarnings,novrfy,noexpn,restrictqrun')dnl
define(`confMAX_MIME_HEADER_LENGTH', `256/128')
define(`confQUEUE_LA', `15')dnl
define(`confREFUSE_LA', `20')dnl
define(`confTO_IDENT', `1')dnl
define(`STATUS_FILE', `/etc/mail/statistics')dnl
define(`ALIAS_FILE', `/etc/mail/aliases')dnl
FEATURE(`no_default_msa',`dnl')dnl
FEATURE(`smrsh',`/usr/sbin/smrsh')dnl
FEATURE(`mailertable',`mysql -Mmailertable -Ldomain -Rmapping -Dmail_svaka_net')dnl
FEATURE(`virtusertable',`mysql -Mvirtuser -Lemailin -Remailout -Dmail_svaka_net')dnl
FEATURE(`access_db',`hash -T<TMPF> -o /etc/mail/access.db')dnl
FEATURE(`blacklist_recipients')dnl
FEATURE(redirect)dnl
FEATURE(use_cw_file)dnl
define(`confCW_FILE', `-o /etc/mail/local-host-names')dnl
FEATURE(use_ct_file)dnl
dnl #
dnl #
define(`confMAPDEF',`-DMYSQLMAP')
define(`confINCDIRS',`-I/usr/include/mysql')
define(`confLIBDIRS',`-L/usr/lib/mysql')
define(`confLIBS',`-lmysqlclient')
FEATURE(local_procmail,`',`procmail -t -Y -a $h -d $u')dnl
EXPOSED_USER(`root')dnl
DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl
DAEMON_OPTIONS(`Port=submission, Name=MSA, M=Ea')dnl
DAEMON_OPTIONS(`Port=smtps, Name=TLSMTA, M=s')dnl
MAILER(smtp)dnl
MAILER(procmail)dnl

[GG]

ok... I've found out what the problem was...
I had an error in the config file for sql, where I didn't take out the <> from the file, but put the information required inside the <> ,,, instead of leaving the information without it

well, it's working superb

the system I have it working on without problems is
linux redhat 9.0
mysql  Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu (i386)