6c11cd7657d49b39919a9848447e359542877cab
[sip-router] / doc / serfaq / db_faq.sgml
1 <!-- $Id$ -->
2
3 <chapter>
4     <title>Database Related Questions</title>
5     <qandaset>
6         <qandaentry>
7             <question>
8                 <simpara>
9                     Mar 10 16:46:33 ttalksvr /usr/sbin/ser[6592]: connect_db(): Can't connect to
10                     local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
11                 </simpara>
12             </question>
13             <answer>
14                 <simpara>
15                     Make sure your MySQL server is running.
16                 </simpara>
17             </answer>
18         </qandaentry>
19
20         <qandaentry>
21             <question>
22                 <simpara>
23                     I get the following error:
24                 </simpara>
25                 <screen format="linespecific">
26 0(5164) db_init(): Error while trying to connect database
27 0(5164) mod_init(): Error while connecting database
28 0(5164) init_modules(): Error while initializing module usrloc
29 </screen>
30                 <simpara>
31                 </simpara>
32             </question>
33             <answer>
34                 <simpara>
35                     Modules using database have variable called db_url which contains username,
36                     password, hostname, and name of the database. Make sure the settings are
37                     correct. See module documentation for more information.
38                 </simpara>
39             </answer>
40         </qandaentry>
41
42         <qandaentry>
43             <question>
44                 <simpara>
45                     Does MySQL/Postgres/Whatever have to reside on localhost?
46                 </simpara>
47             </question>
48             <answer>
49                 <simpara>
50                     No.
51                     </simpara>
52             </answer>
53         </qandaentry>
54
55         <qandaentry>
56             <question>
57                 <simpara>
58                     Why do I need a database ?
59                 </simpara>
60             </question>
61             <answer>
62                 <simpara>
63                     Many modules need the database. Authentication modules retrieve users'
64                     crecentials from the database, user location module can be configured to store
65                     registered bindings into the database, accounting module can use database to
66                     store CDR and so on.
67                 </simpara>
68             </answer>
69         </qandaentry>
70         <qandaentry>
71             <question>
72                 <simpara>
73                     Which database engines are supported ?
74                 </simpara>
75             </question>
76             <answer>
77                 <simpara>
78                     Currently we support MySQL, Postgres and plaintext files.
79                 </simpara>
80             </answer>
81         </qandaentry>
82         
83         <qandaentry>
84             <question>
85                 <simpara>
86                     Which database engine should I use ?
87                 </simpara>
88             </question>
89             <answer>
90                 <simpara>
91                     That depends on your requirements. Performance aspects are probably not very
92                     important. The most stable and proven is MySQL module. Also serctl utility works
93                     well with this database.
94                 </simpara>
95                 <simpara>
96                     Another option is postgres support which was donated by Greg Faustak. The module
97                     still new and not that mature (read proven) yet. People using the module
98                     reported that it worked well.
99                 </simpara>
100                 <simpara>
101                     Last option is dbtext module which uses plaintext files to store the data. This
102                     module is somewhat experimental and shouldn't be used for any serious
103                     deployment. The module is quite slow, but it can fit well into small
104                     instalations containing only a couple of users or demos where you need to change
105                     the content of the database often by hand.
106                 </simpara>
107             </answer>
108         </qandaentry>
109
110     </qandaset>
111 </chapter>
112
113
114 <!-- Keep this element at the end of the file
115 Local Variables:
116 sgml-parent-document: ("serfaq.sgml" "Book" "chapter")
117 End:
118 -->