libtransport.git Files · docs/guide/mysql.textile

Files @ 0729d364ca25

Branch filter:

Location: libtransport.git/docs/guide/mysql.textile

0729d364ca25 881 B text/plain Show Annotation Show as Raw Download as Raw

Vladimír Matěna

Fix double free in DummyConnectionServer

Do not create shared ptr from this as this lead to double free in
UserRegistryTest::login test. Shared ptr was needed to set event
owner in acceptConnection, actually it is never needed as events
are never filtered by owner. Thus it was removed and there is no
need to create shared ptr from this.

h2. 1. Editing the configuration file

To configure Spectrum 2 to use MySQL database, you have to edit following options in database section:

|_. Section |_. Key |_. Type |_. Change to value |_. Description |
| database| type | string | mysql | Database type - "none", "mysql", "sqlite3", "pqxx". |
| database| database | string | Name of the already create empty database | Database used to store data. |
| database| server | string | Database server | Database server. |
| database| user | string | MySQL user. | MySQL user. |
| database| password | string | MySQL Password. | MySQL Password. |
| database| prefix | string | | Prefix of tables in database. |

h2. 2. Creating the database

Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the MySQL database user you use to connect the SQL.