371 |
371 |
372 MySql configuration |
372 MySql configuration |
373 ``````````````````` |
373 ``````````````````` |
374 Yout must add the following lines in ``/etc/mysql/my.cnf`` file:: |
374 Yout must add the following lines in ``/etc/mysql/my.cnf`` file:: |
375 |
375 |
376 transaction-isolation = READ-COMMITTED |
376 transaction-isolation=READ-COMMITTED |
377 default-storage-engine=INNODB |
377 default-storage-engine=INNODB |
378 default-character-set=utf8 |
378 default-character-set=utf8 |
379 max_allowed_packet = 128M |
379 max_allowed_packet = 128M |
380 |
380 |
381 .. note:: |
381 .. note:: |
382 It is unclear whether mysql supports indexed string of arbitrary lenght or |
382 It is unclear whether mysql supports indexed string of arbitrary lenght or |
383 not. |
383 not. |
384 |
384 |
|
385 SQLServer configuration |
|
386 ----------------------- |
|
387 |
|
388 As of this writing, sqlserver support is in progress. You should be |
|
389 able to connect, create a database and go quite far, but some of the |
|
390 generated SQL is still currently not accepted by the backend. |
|
391 |
|
392 The `source` configuration file may look like this (specific parts |
|
393 only are shown):: |
|
394 |
|
395 [system] |
|
396 db-driver=sqlserver2005 |
|
397 db-user=someuser |
|
398 # database password not needed |
|
399 #db-password=toto123 |
|
400 #db-create/init may ask for a pwd: just say anything |
|
401 db-extra-arguments=Trusted_Connection |
|
402 db-encoding=utf8 |
|
403 |
|
404 |
385 Pyro configuration |
405 Pyro configuration |
386 ------------------ |
406 ------------------ |
387 |
407 |
388 If you use Pyro, it is required to have a name server Pyro running on your |
408 If you use Pyro, it is required to have a name server Pyro running on your |
389 network (by default it is detected by a broadcast request). |
409 network (by default it is detected by a broadcast request). |