Open2300 - My SQL Table Name
You are here: Foswiki>Open2300 Web>MySQLTableName (02 Nov 2010, BmDOnline)Edit Attach

MySQL Table Name

Introduction

Actually, when using mysql2300 and mysqlhistlog2300, you can't change the name of the table.

Description of Patch

Like pgsql2300, now you can set the name in open2300.conf

Installation of Patch

4 files have to be updated :

rw2300.h and rw2300.c, where mysql_table parameter is now defined.

rw2300.h.patch, rw2300.c.patch

mysql2300.c and mysqlhistlog2300.c where this parameter is used, instead of "weather" name.

mysql2300.c.patch, mysqlhistlog2300.c.patch

Then, you have to set the right parameter in open2300.conf.

For example :
MYSQL_HOST              localhost         # Localhost or IP address/host name
MYSQL_USERNAME          open2300          # Name of the MySQL user that has access to the database
MYSQL_PASSWORD          mysql2300         # Password for the MySQL user
MYSQL_DATABASE          open2300          # Named of your database
MYSQL_TABLE             open2300_weather  # MySQL table name
MYSQL_PORT              0                 # TCP/IP Port number. Zero means default

Change History of Patch

Discussion and Comments


I Attachment Action Size Date Who Comment
mysql2300.c.patchpatch mysql2300.c.patch manage 355 bytes 02 Nov 2010 - 10:31 UnknownUser replace "weather" by MYSQL_TABLE parameter
mysqlhistlog2300.c.patchpatch mysqlhistlog2300.c.patch manage 941 bytes 02 Nov 2010 - 10:31 UnknownUser replace "weather" by MYSQL_TABLE parameter
rw2300.c.patchpatch rw2300.c.patch manage 1018 bytes 02 Nov 2010 - 10:30 UnknownUser mysql_table parameter definition
rw2300.h.patchpatch rw2300.h.patch manage 351 bytes 02 Nov 2010 - 10:28 UnknownUser mysql_table parameter definition
Topic revision: r2 - 02 Nov 2010, BmDOnline
Copyright © 1999-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.