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.