<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=big5">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Georgia size=2>HI, I'm using Debian Linux(while I have no idea
how to check its version), and running SER on my PC.</FONT></DIV>
<DIV><FONT face=Georgia size=2>I installed MySQL 4.1.14 and SER 0.9.4,
chmoded the /tmp directory to 777, and the MySQL server runs well.</FONT></DIV>
<DIV><FONT face=Georgia size=2>But when I start SER, it does not run and leaves
some error message in syslog like this:</FONT></DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2>Oct 10 14:31:03 Serverhost /usr/sbin/ser[6525]: Maxfwd module-
initializing<BR>Oct 10 14:31:03 Serverhost /usr/sbin/ser[6525]:
new_connection(): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)<BR>Oct 10 14:31:03 Serverhost
/usr/sbin/ser[6525]: db_init(): Could not create a connection<BR>Oct 10 14:31:03
Serverhost /usr/sbin/ser[6525]: ERROR: auth_db_ver: unable to open database
connection<BR>Oct 10 14:31:03 Serverhost /usr/sbin/ser[6525]:
auth_db:str_fixup(): Error while querying table version<BR>Oct 10 14:31:03
Serverhost /usr/sbin/ser[6525]: ERROR: fix_expr : fix_actions
error<BR>--------------------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2><FONT face=Georgia>The file /var/run/mysqld/mysqld.sock doest
not exist, but the MySQL still runs well. I also don't know if it is
correct.</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Georgia>Does anyone know how to resolve this? Thank
you!</FONT></FONT></DIV>
<DIV><FONT size=2><FONT face=Georgia></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT face=Georgia>ser.cfg, "gulab.twbbs.org" is my
domain.</FONT></FONT></DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2>#<BR># $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp
$<BR>#<BR># simple quick-start config script<BR>#</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># ----------- global configuration parameters
------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>#debug=3 #
debug level (cmd line:
-dddddddddd)<BR>#fork=yes<BR>#log_stderror=no
# (cmd line: -E)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>/* Uncomment these lines to enter debugging
mode<BR>fork=no<BR>log_stderror=yes<BR>*/</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>check_via=no # (cmd. line:
-v)<BR>dns=no #
(cmd. line: -r)<BR>rev_dns=no # (cmd. line:
-R)<BR>#port=5060<BR>#children=4<BR>fifo="/tmp/ser_fifo"</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># Uncomment this if you want to use SQL database<BR>loadmodule
"/usr/lib/ser/modules/mysql.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>loadmodule "/usr/lib/ser/modules/sl.so"<BR>loadmodule
"/usr/lib/ser/modules/tm.so"<BR>loadmodule
"/usr/lib/ser/modules/rr.so"<BR>loadmodule
"/usr/lib/ser/modules/maxfwd.so"<BR>loadmodule
"/usr/lib/ser/modules/usrloc.so"<BR>loadmodule
"/usr/lib/ser/modules/registrar.so"<BR>loadmodule
"/usr/lib/ser/modules/textops.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># Uncomment this if you want digest authentication<BR>#
mysql.so must be loaded !<BR>loadmodule
"/usr/lib/ser/modules/auth.so"<BR>loadmodule
"/usr/lib/ser/modules/auth_db.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># ----------------- setting module-specific parameters
---------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># -- usrloc params --</FONT></DIV>
<DIV> </DIV><FONT size=2>
<DIV><BR>#modparam("usrloc", "db_mode", 0)</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use SQL database<BR># for persistent
storage and comment the previous line<BR>modparam("usrloc", "db_mode", 2)</DIV>
<DIV> </DIV>
<DIV># -- auth params --<BR># Uncomment if you are using auth
module<BR>#<BR>modparam("auth_db", "calculate_ha1", yes)<BR>#<BR># If you set
"calculate_ha1" parameter to yes (which true in this config),<BR># uncomment
also the following parameter)<BR>#<BR>modparam("auth_db", "password_column",
"password")</DIV>
<DIV> </DIV>
<DIV># -- rr params --<BR># add value to ;lr param to make some broken UAs
happy<BR>modparam("rr", "enable_full_lr", 1)</DIV>
<DIV> </DIV>
<DIV># ------------------------- request routing logic
-------------------</DIV>
<DIV> </DIV>
<DIV># main routing logic</DIV>
<DIV> </DIV>
<DIV>route{</DIV>
<DIV> </DIV>
<DIV> # initial sanity checks --
messages with<BR> # max_forwards==0,
or excessively long requests<BR> if
(!mf_process_maxfwd_header("10"))
{<BR>
sl_send_reply("483","Too Many
Hops");<BR>
break;<BR>
};<BR> if (msg:len >= 2048 )
{<BR>
sl_send_reply("513", "Message too
big");<BR>
break;<BR> };<BR></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> # we record-route all messages
-- to make sure that<BR> # subsequent
messages will go through our proxy;
that's<BR> # particularly good if
upstream and downstream entities<BR> #
use different transport protocol<BR>
if (!method=="REGISTER") record_route();</DIV>
<DIV> </DIV>
<DIV> # subsequent messages withing a
dialog should take the<BR> # path
determined by record-routing<BR> if
(loose_route())
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
rr-enforced\r\n");<BR>
route(1);<BR>
break;<BR> };</DIV>
<DIV> </DIV>
<DIV> if (!uri==myself)
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
outbound\r\n");<BR>
route(1);<BR>
break;<BR> };</DIV>
<DIV> </DIV>
<DIV><BR> # if the request is for
other domain use UsrLoc<BR> # (in
case, it does not work, use the following
command<BR> # with proper names and
addresses in it)<BR> if
(uri=~"gulab.twbbs.org") {</DIV>
<DIV> </DIV>
<DIV>
if (method=="REGISTER") {</DIV>
<DIV> </DIV>
<DIV># Uncomment this if you want to use digest
authentication<BR>
if (!www_authorize("gulab.twbbs.org", "subscriber"))
{<BR>
www_challenge("gulab.twbbs.org",
"0");<BR>
break;<BR>
};<BR><BR>
save("location");<BR>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
lookup("aliases");<BR>
if (!uri==myself)
{<BR>
append_hf("P-hint: outbound
alias\r\n");<BR>
route(1);<BR>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
# native SIP destinations are handled using our USRLOC
DB<BR>
if (!lookup("location"))
{<BR>
sl_send_reply("404", "Not
Found");<BR>
break;<BR>
};<BR>
};<BR> append_hf("P-hint: usrloc
applied\r\n");<BR>
route(1);<BR>}</DIV>
<DIV> </DIV>
<DIV>route[1]<BR>{<BR> # send it out
now; use stateful forwarding as it works
reliably<BR> # even for
UDP2TCP<BR> if (!t_relay())
{<BR>
sl_reply_error();<BR> };<BR>}</DIV>
<DIV></FONT> </DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2><FONT face=Georgia>my.cnf</FONT></FONT></DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT size=2>#<BR># The MySQL database server configuration file.<BR>#<BR>#
You can copy this to one of:<BR># - "/etc/mysql/my.cnf" to set global
options,<BR># - "/var/lib/mysql/my.cnf" to set server-specific options or<BR># -
"~/.my.cnf" to set user-specific options.<BR>#<BR># One can use all long options
that the program supports.<BR># Run program with --help to get a list of
available options and with<BR># --print-defaults to see which it would actually
understand and use.<BR>#<BR># For explanations see<BR># <A
href="http://dev.mysql.com/doc/mysql/en/server-system-variables.html">http://dev.mysql.com/doc/mysql/en/server-system-variables.html</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># This will be passed to all mysql clients<BR># It has been
reported that passwords should be enclosed with ticks/quotes<BR># escpecially if
they contain "#" chars...<BR># Remember to edit /etc/mysql/debian.cnf when
changing the socket
location.<BR>[client]<BR>port
= 3306<BR>socket =
/var/run/mysqld/mysqld.sock<BR><BR># Here is entries for some specific
programs<BR># The following values assume you have at least 32M ram</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2># This was formally known as [safe_mysqld]. Both versions are
currently
parsed.<BR>[mysqld_safe]<BR>socket
=
/var/run/mysqld/mysqld.sock<BR>nice
= 0</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>[mysqld]<BR>#<BR># * Basic
Settings<BR>#<BR>user
= mysql<BR>pid-file =
/var/run/mysqld/mysqld.pid<BR>socket
=
/var/run/mysqld/mysqld.sock<BR>port
= 3306<BR>basedir =
/usr<BR>datadir =
/var/lib/mysql<BR>tmpdir =
/tmp<BR>language =
/usr/share/mysql/english<BR>skip-external-locking<BR>#<BR># For compatibility to
other Debian packages that still use<BR># libmysqlclient10 and
libmysqlclient12.<BR>old_passwords = 1<BR>#<BR># Instead of
skip-networking the default is now to listen only on<BR># localhost which is
more compatible and is not less
secure.<BR>bind-address
= 127.0.0.1<BR>#<BR># * Fine
Tuning<BR>#<BR>key_buffer
= 16M<BR>max_allowed_packet =
16M<BR>thread_stack
= 128K<BR>#<BR># * Query Cache
Configuration<BR>#<BR>query_cache_limit =
1048576<BR>query_cache_size =
16777216<BR>query_cache_type =
1<BR>#<BR># * Logging and Replication<BR>#<BR># Both location gets rotated by
the cronjob.<BR># Be aware that this log type is a performance
killer.<BR>#log
=
/var/log/mysql.log<BR>#log
= /var/log/mysql/mysql.log<BR>#<BR># Error logging goes to syslog. This is a
Debian improvement :)<BR>#<BR># Here you can see queries with especially long
duration<BR>#log-slow-queries =
/var/log/mysql/mysql-slow.log<BR>#<BR># The following can be used as easy to
replay backup logs or for
replication.<BR>#server-id
=
1<BR>log-bin
= /var/log/mysql/mysql-bin.log<BR># See /etc/mysql/debian-log-rotate.conf for
the number of files
kept.<BR>max_binlog_size =
104857600<BR>#binlog-do-db
= include_database_name<BR>#binlog-ignore-db
= include_database_name<BR>#<BR># * BerkeleyDB<BR>#<BR># According to an MySQL
employee the use of BerkeleyDB is now discouraged<BR># and support for it will
probably cease in the next versions.<BR>skip-bdb<BR>#<BR># * InnoDB<BR>#<BR>#
InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.<BR># Read
the manual for more InnoDB related options. There are many!</FONT></DIV>
<DIV><FONT size=2>#<BR># * Security Features<BR>#<BR># Read the manual, too, if
you want chroot!<BR># chroot = /var/lib/mysql/<BR>#<BR># If you want to enable
SSL support (recommended) read the manual or my<BR># HOWTO in
/usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz<BR>#
ssl-ca=/etc/mysql/cacert.pem<BR># ssl-cert=/etc/mysql/server-cert.pem<BR>#
ssl-key=/etc/mysql/server-key.pem<BR></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>[mysqldump]<BR>quick<BR>quote-names<BR>max_allowed_packet
= 16M</DIV>
<DIV> </DIV>
<DIV>[mysql]<BR>#no-auto-rehash # faster start of mysql but no tab
completition</DIV>
<DIV> </DIV>
<DIV>[isamchk]<BR>key_buffer
= 16M<BR><BR>#<BR># * NDB Cluster<BR>#<BR># See
/usr/share/doc/mysql-server-*/README.Debian for more information.<BR>#<BR># The
following configuration is read by the ndbd storage daemons,<BR># not from the
ndb_mgmd management daemon.<BR>#<BR># [MYSQL_CLUSTER]<BR>#
ndb-connectstring=127.0.0.1<BR></FONT></DIV>
<DIV><FONT
size=2>--------------------------------------------------------------------------------------------</DIV></FONT></BODY></HTML>