libtransport.git Changeset - 6334c256f4fd

Changeset - 6334c256f4fd

Parent rev.

Child rev.

[Not reviewed]

0 3 0

Daniel Henninger - 13 years ago 2013-01-11 16:16:32
daniel@vorpalcloud.org

Fixed up postgres support, needs testing both for compiling and functionality.

3 files changed with 49 insertions and 12 deletions:

docs/guide/postgresql.textile

spectrum/src/sample2.cfg

src/pqxxbackend.cpp

0 comments (0 inline, 0 general)

docs/guide/postgresql.textile

➞

Show inline comments

 h2. 1. Editing the configuration file
-To configure Spectrum 2 to use PostgreSQL database, you have to edit following options in database section:
+To configure Spectrum 2 to use PostgreSQL database, you have to edit some or more of the following options in database section.  Please note that connectionstring overrides everything else (aside from type).
 |_. Section |_. Key |_. Type |_. Change to value |_. Description |
 | database| type | string | pqxx | 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| port | string | Database port | Database port. |
 | database| user | string | PostgreSQL user. | PostgreSQL user. |
 | database| password | string | PostgreSQL Password. | PostgreSQL Password. |
 | database| prefix | string | | Prefix of tables in database. |
 | database| connectionstring | string | Postgres connection string | If you set this, it will ignore all other options above aside from type and prefix.  This allows you to set any typical postgres connection string option, separated by spaces (no semicolons). |
 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 PostgreSQL database user you use to connect the SQL.
@@ \ No newline at end of file @@
 Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the PostgreSQL database user you use to connect the SQL.
 h2. 3. Some examples
 Using connectionstring:
 [database]
 type=pqxx
 connectionstring=host=localhost database=spectrum2 user=myuser password=whatever
 Using traditional options:
 [database]
 type=pqxx
 server=localhost
 database=spectrum2
 user=myuser
 password=whatever

spectrum/src/sample2.cfg

➞

Show inline comments

@@ @@ -96,6 +96,10 @@ type = none @@
 # Prefix used for tables
 #prefix = jabber_
 # Connection string (for pqxx only!)
 # If you set this, it ignores every other database option except for type and prefix.
 #connectionstring = host=localhost user=specturm password=secret
 [registration]
 # Enable public registrations
 enable_public_registration=1

src/pqxxbackend.cpp

➞

Show inline comments

@@ @@ -48,18 +48,34 @@ void PQXXBackend::disconnect() { @@
+}
 bool PQXXBackend::connect() {
 	LOG4CXX_INFO(logger, "Connecting PostgreSQL server " << CONFIG_STRING(m_config, "database.server") << ", user " <<
 		CONFIG_STRING(m_config, "database.user") << ", database " << CONFIG_STRING(m_config, "database.database") <<
 		", port " << CONFIG_INT(m_config, "database.port")
 	);
 	std::string str = "dbname=";
 	str += CONFIG_STRING(m_config, "database.database") + " ";
 	str += "user=" + CONFIG_STRING(m_config, "database.user") + " ";
 	std::string connection_str;
 	connection_str = CONFIG_STRING(m_config, "database.connectionstring");
 	if (!connection_str) {
 		LOG4CXX_INFO(logger, "Connecting PostgreSQL server " << CONFIG_STRING(m_config, "database.server") << ", user " <<
 			CONFIG_STRING(m_config, "database.user") << ", database " << CONFIG_STRING(m_config, "database.database") <<
 			", port " << CONFIG_INT(m_config, "database.port")
 		);
 		connection_str = "dbname=";
 		connection_str += CONFIG_STRING(m_config, "database.database");
 		if (CONFIG_STRING(m_config, "database.server")) {
 			connection_str += " host=" + CONFIG_STRING(m_config, "database.server");
+		}
 		if (CONFIG_STRING(m_config, "database.user")) {
 			connection_str += " user=" + CONFIG_STRING(m_config, "database.user");
+		}
 		if (CONFIG_STRING(m_config, "database.password")) {
 			connection_str += " password=" + CONFIG_STRING(m_config, "database.password");
+		}
 		if (CONFIG_STRING(m_config, "database.port")) {
 			connection_str += " port=" + CONFIG_STRING(m_config, "database.password");
+		}
+	}
 	else {
 		LOG4CXX_INFO(logger, "Connecting PostgreSQL server via provided connection string.");
+	}
 	try {
-		m_conn = new pqxx::connection(str);
+		m_conn = new pqxx::connection(connection_str);
+	}
 	catch (std::exception& e) {
 		LOG4CXX_ERROR(logger, e.what());

0 comments (0 inline, 0 general)