Skip to Content.
Sympa Menu

en - [sympa-users] patch for include_sql_query for Informix

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Ryan Fox <address@concealed>
  • To: address@concealed
  • Subject: [sympa-users] patch for include_sql_query for Informix
  • Date: Thu, 02 Oct 2008 15:22:05 -0400

Informix wants the DBI->connect in a slightly different format than the default (database@host as opposed to database:host). Would you kindly intergrate this patch for SQLSource.pm? This is against sympa-5.4.3.


bash-3.00# diff -u SQLSource.pm.orig SQLSource.pm --- SQLSource.pm.orig Thu Oct 2 15:16:10 2008
+++ SQLSource.pm Thu Oct 2 15:17:00 2008
@@ -138,6 +138,8 @@
$connect_string = "DBI:Sybase:database=$param->{'db_name'};server=$param->{'db_host'}";
}elsif ($param->{'db_type'} eq 'SQLite') {
$connect_string = "DBI:SQLite:dbname=$param->{'db_name'}";
+ }elsif ($param->{'db_type'} eq 'Informix') {
+ $connect_string = "DBI:Informix:".$param->{'db_name'}."@".$param->{'db_host'};
}else {
$connect_string = "DBI:$param->{'db_type'}:$param->{'db_name'}:$param->{'db_host'}";
}

Thanks,
Ryan


begin:vcard
fn:Ryan Fox
n:Fox;Ryan
org:The University of Findlay;Information Technology Services
adr:128 Old Main;;1000 Main St;Findlay;OH;45840;USA
email;internet:address@concealed
title:Network Systems Manager
tel;work:419-434-4348
x-mozilla-html:TRUE
version:2.1
end:vcard



  • [sympa-users] patch for include_sql_query for Informix, Ryan Fox, 10/02/2008

Archive powered by MHonArc 2.6.19+.

Top of Page