I attempted to look for the mysql.sock to mae sure it was in the right place however I don't seem to have one on my machine... Does this matter since I'm locally connecting?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I attempted to edit my.cnf and it didn't work. I edited them both to pont to /var/lib/mysql/mysql.sock, there is no mysql.sock even while mysql server is running though. I'm running MySQL 5.0 though.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
# you're on the right track there...
#
# try cut & paste of this into your shell.
locate mysql.sock
locate mysqld.sock
# now one of the above should have found you its location, if not
# then try this.
find / -name 'mysql*.sock'
# once you know the name...
file $SOCKNAME
# if that did a file not found, or didn't say it was a socket, then
# you have a more serious problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can't initialize mailbox database "cxmain": Service unavailable
My sqlmail.conf is:
MysqlHost localhost
MysqlSocket /var/lib/mysql/mysql.sock
#MysqlNetworkPort 3306
MysqlUsername ******
MysqlPassword ******
MysqlDatabase cxmain
MysqlUserTable bfd_nix_users
MysqlMailboxTable bfd_nix_users
MysqlAliasTable bfd_nix_alias
MysqlMapTable bfd_nix_emailmaps
MysqlLHSColumn default_key_column
MysqlRHSColumn default_value_column
sendmail -d37.4 -bv root
setdefaults: DefUser=mailnull, DefUid=47, DefGid=47
inittimeouts(<NULL>)
fileclass(/etc/mail/local-host-names, fmt=%s)
fileclass(/etc/mail/relay-domains, fmt=%s)
setoption SevenBitInput (7)=False
setoption MinFreeBlocks (b)=100
setoption BlankSub (B)=.
setoption HoldExpensive (c)=False
setoption DeliveryMode (d)=background
setoption TempFileMode (F)=0600
setoption HelpFile (H)=/etc/mail/helpfile
setoption SendMimeErrors (j)=True
setoption ForwardPath (J)=$z/.forward.$w+$h:$z/.forward+$h:$z/.forward.$w:$z/.fo
rward
setoption ConnectionCacheSize (k)=2
setoption ConnectionCacheTimeout (K)=5m
setoption UseErrorsTo (l)=False
setoption LogLevel (L)=9
setoption CheckAliases (n)=False
setoption OldStyleHeaders (o)=True
setoption DaemonPortOptions (O)=Name=MTA
Daemon MTA flags:
setoption DaemonPortOptions (O)=Port=587, Name=MSA, M=E
Daemon MSA flags: <NOETRN>
setoption PrivacyOptions (p)=authwarnings
setoption QueueDirectory (Q)=/var/spool/mqueue
setoption Timeout (r).queuereturn=5d
settimeout(queuereturn = 5d)
setoption Timeout (r).queuewarn=4h
settimeout(queuewarn = 4h)
setoption SuperSafe (s)=True
setoption StatusFile (S)=/etc/mail/statistics
setoption SmtpGreetingMessage (0x90)=$j Sendmail $v/$Z; $b
setoption UnixFromLine (0x91)=From $g $d
setoption OperatorChars (0x92)=.:%@!^/[]+
setoption MaxHeadersLength (0xaa)=32768
setoption MailboxDatabase (0xcb)=cxmain
Can't initialize mailbox database "cxmain": Service unavailable
I attempted to look for the mysql.sock to mae sure it was in the right place however I don't seem to have one on my machine... Does this matter since I'm locally connecting?
if you put information on your mysql.sock in the /etc/mail/sqlmail.conf
you need to have mysql.sock
you can tell mysqld where to set mysql.sock which it creates when you start it, by editing /etc/my.cnf
you put in my.cnf
[mysqld]
socket=/var/lib/mysql/mysql.sock
I attempted to edit my.cnf and it didn't work. I edited them both to pont to /var/lib/mysql/mysql.sock, there is no mysql.sock even while mysql server is running though. I'm running MySQL 5.0 though.
sendmail -d37.4 -bv root
setdefaults: DefUser=mailnull, DefUid=47, DefGid=47
inittimeouts(<NULL>)
fileclass(/etc/mail/local-host-names, fmt=%s)
fileclass(/etc/mail/relay-domains, fmt=%s)
setoption SevenBitInput (7)=False
setoption MinFreeBlocks (b)=100
setoption BlankSub (B)=.
setoption HoldExpensive (c)=False
setoption DeliveryMode (d)=background
setoption TempFileMode (F)=0600
setoption HelpFile (H)=/etc/mail/helpfile
setoption SendMimeErrors (j)=True
setoption ForwardPath (J)=$z/.forward.$w+$h:$z/.forward+$h:$z/.forward.$w:$z/.forward
setoption ConnectionCacheSize (k)=2
setoption ConnectionCacheTimeout (K)=5m
setoption UseErrorsTo (l)=False
setoption LogLevel (L)=9
setoption CheckAliases (n)=False
setoption OldStyleHeaders (o)=True
setoption DaemonPortOptions (O)=Name=MTA
Daemon MTA flags:
setoption DaemonPortOptions (O)=Port=587, Name=MSA, M=E
Daemon MSA flags: <NOETRN>
setoption PrivacyOptions (p)=authwarnings
setoption QueueDirectory (Q)=/var/spool/mqueue
setoption Timeout (r).queuereturn=5d
settimeout(queuereturn = 5d)
setoption Timeout (r).queuewarn=4h
settimeout(queuewarn = 4h)
setoption SuperSafe (s)=True
setoption StatusFile (S)=/etc/mail/statistics
setoption SmtpGreetingMessage (0x90)=$j Sendmail $v/$Z; $b
setoption UnixFromLine (0x91)=From $g $d
setoption OperatorChars (0x92)=.:%@!^/[]+
setoption MaxHeadersLength (0xaa)=32768
setoption MailboxDatabase (0xcb)=cxmain
Can't initialize mailbox database "cxmain": Service unavailable
That is still the error I am getting. I have changed the sendmail to look for the mysql.sock to /temp/mysql.sock where mysql defaultly puts it.
# you're on the right track there...
#
# try cut & paste of this into your shell.
locate mysql.sock
locate mysqld.sock
# now one of the above should have found you its location, if not
# then try this.
find / -name 'mysql*.sock'
# once you know the name...
file $SOCKNAME
# if that did a file not found, or didn't say it was a socket, then
# you have a more serious problem.