From: Vladimir Cherednichenko <che@red-team.org.ua> To: ALT Linux sysadmin discuss <sysadmins@lists.altlinux.org>, sisyphus@lists.altlinux.org Subject: [sisyphus] ldap+odbc+mysql Date: Tue, 16 May 2006 20:26:59 +0300 Message-ID: <446A0B63.6080500@red-team.org.ua> (raw) Hi Есть не стандартная задача, поднять ldap с бакендом в sql, делалось по примерам http://www.openldap.org/faq/data/cache/978.html http://www.flatmtn.com/computer/Linux-LDAP.html google Но ничего не завелось, в логах cldap-a такое: ==>backsql_get_db_conn() May 16 19:23:55 radius slapd[28129]: ==>backsql_open_db_conn(4294967295) May 16 19:23:55 radius slapd[28129]: backsql_open_db_conn(4294967295): SQLConnect() to database "ldap" failed. May 16 19:23:55 radius slapd[28129]: Return code: -1 May 16 19:23:55 radius slapd[28129]: Native error code: 0 May 16 19:23:55 radius slapd[28129]: backsql_get_db_conn(): could not get connection handle -- returning NULL May 16 19:23:55 radius slapd[28129]: backsql_db_open(): connection failed, exiting May 16 19:23:55 radius slapd[28129]: backend_startup_one: bi_db_open failed! (1) #slaptest -v WARNING: No dynamic config support for database sql. config file testing succeeded Вручную ODBC конектится # isql ldap ldap der_paroll +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> Когда используется бакенд hdb ldap работает. Установлены пакеты: - libunixODBC-2.2.11-alt2.2 - unixODBC-2.2.11-alt2.2 - mysql-connector-odbc-3.51-alt1 - libldap2.3-2.3.21-alt1 - libldap-2.2.27-alt1.1 - openldap-2.3.21-alt1 - openldap-doc-2.3.21-alt1 - openldap-servers-2.3.21-alt1 - MySQL-client-5.0.20-alt1 - libMySQL-5.0.20-alt1 - MySQL-server-5.0.20-alt1 Конифиги: /etc/odbc.ini [ODBC Data Sources] ldap = MySQL LDAP DSN [ldap] Driver = MySQL Database = ldap User = ldap PWD = der_paroll Server = 1.2.3.4 Port = 3306 ReadOnly = no Socket = /var/lib/mysql/mysql.sock [ODBC] InstallDir=/usr/lib /etc/odbcinst.ini [ODBC Drivers] MySQL = Installed [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so /etc/openldap/slapd.conf include /etc/openldap/schema/core.schema include /etc/openldap/schema/cosine.schema include /etc/openldap/schema/inetorgperson.schema include /etc/openldap/schema/dhcp.schema # Define global ACLs to disable default read access. # Do not enable referrals until AFTER you have a working directory # service AND an understanding of referrals. #referral ldap://root.openldap.org pidfile /var/run/slapd.pid argsfile /var/run/slapd.args loglevel -1 modulepath /usr/lib/openldap moduleload back_sql.la moduleload back_hdb.la database sql suffix "dc=sql,dc=RU" rootdn "cn=root,dc=sql,dc=RU" rootpw secret dbname ldap dbuser ldap dbpasswd der_paroll subtree_cond "ldap_entries.dn LIKE CONCAT('%',?)" insentry_stmt "INSERT INTO ldap_entries (dn,oc_map_id,parent,keyval) VALUES (?,?,?,?)" has_ldapinfo_dn_ru no Есть подозрение что гдето нестыковка с chroot-ом ldap-a и ODBC... хотя ODBC-шные файлики и либы я ему закинул. Устал бороться, памажите кто-нибуть...., как его победить. Может кто сталкивался. -- WBR, Vladimir Cherednichenko R.E.D Team | Admin Ukraine | Kiev
reply other threads:[~2006-05-16 17:26 UTC|newest] Thread overview: [no followups] expand[flat|nested] mbox.gz Atom feed
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=446A0B63.6080500@red-team.org.ua \ --to=che@red-team.org.ua \ --cc=sisyphus@lists.altlinux.org \ --cc=sysadmins@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Sisyphus discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \ sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru public-inbox-index sisyphus Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.sisyphus AGPL code for this site: git clone https://public-inbox.org/public-inbox.git