View | Details | Raw Unified
Collapse All | Expand All

(-) doc/mysql_drv.txt (+19 lines)
 Lines 2489-2494    Link Here  
    goto FAILURE;
    goto FAILURE;
  }
  }

            

              
              
#if MYSQL_VERSION_ID >= 50013

            

            

              
              
  /* enable automatic reconnect for MySQL >= 5.0.13 */

            

            

              
              
  snprintf(attrib, sizeof(attrib), "%sReconnect", prefix);

            

            

              
              
  if (_ds_match_attribute(CTX->config->attributes, attrib, "true"))

            

            

              
              
  {

            

            

              
              
      my_bool reconnect = 1;

            

            

              
              
      mysql_options(dbh, MYSQL_OPT_RECONNECT, &reconnect);

            

            

              
              
  }

            

            

              
              
#endif

            

            

              
              

            

        
  if (hostname[0] == '/')
  if (hostname[0] == '/')

        
  {
  {

        
    if (!mysql_real_connect (dbh, NULL, user, password, db, 0, hostname, 
    if (!mysql_real_connect (dbh, NULL, user, password, db, 0, hostname, 

  

    

    

       Lines 305-310
       
    
  Link Here 
    

  

        
#MySQLPass    		changeme
#MySQLPass    		changeme

        
#MySQLDb      	  	dspam
#MySQLDb      	  	dspam

        
#MySQLCompress		true
#MySQLCompress		true

            

              
              
#MySQLReconnect		true

            

        

        
# If you are using replication for clustering, you can also specify a separate
# If you are using replication for clustering, you can also specify a separate

        
# server to perform all writes to.
# server to perform all writes to.

  

    

    

       Lines 315-320
       
    
  Link Here 
    

  

        
#MySQLWritePass		changeme
#MySQLWritePass		changeme

        
#MySQLWriteDb		dspam_write
#MySQLWriteDb		dspam_write

        
#MySQLCompress		true
#MySQLCompress		true

            

              
              
#MySQLReconnect		true

            

        

        
# If your replication isn't close to real-time, your retraining might fail if 
# If your replication isn't close to real-time, your retraining might fail if 

        
# the  signature isn't found. One workaround for this is to use the write
# the  signature isn't found. One workaround for this is to use the write

  

    

    

       Lines 486-491
       
    
  Link Here 
    

  

        
#MySQLPass.DECAlpha     changeme
#MySQLPass.DECAlpha     changeme

        
#MySQLDb.DECAlpha       dspam
#MySQLDb.DECAlpha       dspam

        
#MySQLCompress.DECAlpha true
#MySQLCompress.DECAlpha true

            

              
              
#MySQLReconnect.DECAlpha	true

            

        
#
#

        
#Profile Sun420R
#Profile Sun420R

        
#MySQLServer.Sun420R    10.0.0.2
#MySQLServer.Sun420R    10.0.0.2

  

    

    

       Lines 494-499
       
    
  Link Here 
    

  

        
#MySQLPass.Sun420R      changeme
#MySQLPass.Sun420R      changeme

        
#MySQLDb.Sun420R        dspam
#MySQLDb.Sun420R        dspam

        
#MySQLCompress.Sun420R  false
#MySQLCompress.Sun420R  false

            

              
              
#MySQLReconnect.Sun420R	true

            

        
#
#

        
#DefaultProfile DECAlpha
#DefaultProfile DECAlpha

        

  

    

    

       Lines 127-132
       
    
  Link Here 
    

  

        
MySQLPass      changeme
MySQLPass      changeme

        
MySQLDb        dspam
MySQLDb        dspam

        
MySQLCompress  true
MySQLCompress  true

            

              
              
MySQLReconnect true

            

            

              
              

            

            

              
              
If you are using MySQL >= 5.0.13 and have problems with DSPAM dropping the 

            

            

              
              
connection to your MySQL instance, then set MySQLReconnect to true to allow 

            

            

              
              
the mysql_drv to try to re-establish stale and/or dead connections.

            

        

        
Or if you'd like to connect via TCP, use the IP address and port of the 
Or if you'd like to connect via TCP, use the IP address and port of the 

        
MySQL server. DSPAM checks to see if the first character of the HOSTNAME field 
MySQL server. DSPAM checks to see if the first character of the HOSTNAME field