baiwyc119 / lxmppd

Automatically exported from code.google.com/p/lxmppd
0 stars 0 forks source link

mod_storage_sql wiki page is missing the "port" setting #451

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

This is the example configuration provided:

   storage = "sql"
    sql = {
        driver = "PostgreSQL"; -- May also be "MySQL" or "SQLite3" (case sensitive!)
        database = "prosody"; -- The database name to use. For SQLite3 this the database filename (relative to the data storage directory).
        host = "localhost"; -- The address of the database server (delete this line for Postgre
        username = "prosody"; -- The username to authenticate to the database
        password = "secretpassword"; -- The password to authenticate to the database
    }

on my box I also had to specify the TCP/IP port to connect to via "port". That 
example would look something like this:

   storage = "sql"
    sql = {
        driver = "PostgreSQL"; -- May also be "MySQL" or "SQLite3" (case sensitive!)
        database = "prosody"; -- The database name to use. For SQLite3 this the database filename (relative to the data storage directory).
        host = "localhost"; -- The address of the database server (delete this line for Postgre
        username = "prosody"; -- The username to authenticate to the database
        password = "secretpassword"; -- The password to authenticate to the database
        port = "3306"; -- The optional port for the database server
    }

Perhaps it could be mentioned as a separate item to help prevent copy/paste 
errors for anyone that isn't using TCP/IP connections for MySQL. I think it 
enables 127.0.0.1 by default along with the UNIX socket however.

Original issue reported on code.google.com by deoren.m...@gmail.com on 25 Nov 2014 at 4:56