Hi all,
Question for you. I’ve been racking my brains over
this one for most the day without much success, and it seems my Google-Fu is no
match for this one. I’m hoping you can help.
I’m attempting to setup OpenLDAP (2.4.13) with
back-sql running as a module, relying on a MySQL server as a backend.
My problem appears to be due to the fact I’m trying to
run the database server on a remote host, not the same box as OpenLDAP.
Attempting to start OpenLDAP gives the following error:
==>backsql_get_db_conn()
==>backsql_open_db_conn()
backsql_open_db_conn: SQLConnect() to database
"ldap" as user "dc1auth1" failed:
Return code: -1
Native error code: 2002
SQL engine state: 08S01
Message:
[MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
backsql_get_db_conn(): could not get connection handle --
returning NULL
backsql_db_open(): connection failed, exiting
However, obdc.ini (which has been separately tested) is
configured to connect to the MySQL server on 192.168.1.34. My understanding is
that the dbhost attribute in slapd.conf is ignored – we’ve set this
anyway just to make sure.
Extracts from each:
Slapd.conf
database sql
suffix
"dc=imagingthesouth,dc=com,dc=au"
rootdn
"cn=Hostmaster,dc=imagingthesouth,dc=com,dc=au"
rootpw
stat1c
dbname
ldap
dbhost
192.168.1.36
dbuser
dc1auth1
dbpass
dc1auth1
subtree_cond "ldap_entries.dn LIKE
CONCAT('%',?)"
insentry_query "INSERT INTO ldap_entries
(dn,oc_map_id,parent,keval) VALUES (?,?,?,?)"
odbc.ini
[ldap]
Description = MySQL connection to Rhapsody
Driver = MySQL
DSN = ldap
Host = 192.168.1.34
Server = 192.168.1.34
Servername = 192.168.1.34
USER = dc1auth1
PASSWORD = passgoeshere
Database = rhapsody
Port = 3306
Option =
Stmt =
I’m slightly out of my depth here – any assistance
would be greatly appreciated!
Many thanks,
Jason.