[Xapian-discuss] Hack for dbi2omega: missing multi-socket configuration...

Kevin Duraj kevin.softdev at gmail.com
Wed Feb 20 00:46:38 GMT 2008


dbi2omega hack for users with multiple MySQL instances using
mysqlmanager on multiple sockets

/etc/my.cnf
[mysql.server]
use-manager

[manager]
default-mysqld-path     = /usr/libexec/mysqld
socket                  = /tmp/manager.sock
pid-file                = /tmp/manager.pid
password-file           = /etc/mysqlmanager.passwd
monitoring-interval     = 7
port                    = 3305

[mysqld1]
server_id               = 1
socket                  = /var/lib/mysql/mysql.sock1
port                    = 3306
user                    = mysql
mysqld-path             = /usr/libexec/mysqld
datadir                 = /var/lib/mysql

[mysqld2]
server_id               = 2
socket                  = /var/lib/mysql/mysql.sock2
port                    = 3307
user                    = mysql
mysqld-path             = /usr/libexec/mysqld
datadir                 = /var/lib/mysql

/usr/libexec/mysqlmanager START INSTANCE

xapian-omega-1.0.5/dbi2omega is missing socket configuration

my $dbh = DBI->connect("DBI:$driver:$database", $username, $password)
  or die "Couldn't connect to database: " . DBI->errstr;


Happy Hacking ... xapian-omega-1.0.5/dbi2omega
--------------------------------------------------------------

$dbh = DBI->connect('DBI:mysql:mysql_socket=/var/lib/mysql/mysql.sock1;database=mydatabase'
,'user', 'password',
                       { PrintError => 1, RaiseError => 1 }
                   ) or die "Can't connect to the database: $DBI::errstr\n";

-- 
Kevin Duraj
http://UncensoredWebSearch.com



More information about the Xapian-discuss mailing list