104945 2005-09-05 13:21 0000 cl-sql-3.2.1 does not install clsql_mysql.so 2006-01-01 17:19:31 0000 1 1 1 Unclassified Gentoo Linux Development 2005.1 All Linux RESOLVED FIXED P2 normal --- 1 i@digash.com common-lisp@gentoo.org i@digash.com 2005-09-05 13:21:10 0000 cl-sql has an old .so name need to change to clsql_mysql.so also need to add to the LDPATH the directory where clsql_uffi.so and clsql_mysql.so are located. sbcl cannot find them. Reproducible: Always Steps to Reproduce: 1.sbcl 2.(require 'clsql-mysql) 3. Actual Results: Couldn't load foreign libraries "clsql_uffi64", #P"/usr/share/common-lisp/source/clsql-uffi/uffi/clsql_uffi64", "clsql_uffi", #P"/usr/share/common-lisp/source$ [Condition of type SIMPLE-ERROR] WARNING: Error opening shared object "clsql_uffi64.so": clsql_uffi64.so: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.so": clsql_uffi.so: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi64.a": clsql_uffi64.a: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.a": clsql_uffi.a: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi64.o": clsql_uffiWARNING: Error opening shared object "clsql_uffi64.so": clsql_uffi64.so: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.so": clsql_uffi.so: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi64.a": clsql_uffi64.a: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.a": clsql_uffi.a: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi64.o": clsql_uffi64.o: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.o": clsql_uffi.o: cannot open shared object file: No such file or directory. 64.o: cannot open shared object file: No such file or directory. WARNING: Error opening shared object "clsql_uffi.o": clsql_uffi.o: cannot open shared object file: No such file or directory. i@digash.com 2005-09-05 13:59:37 0000 Created an attachment (id=67698) new working ebuild Just fixed my own bug. i@digash.com 2005-09-05 14:04:18 0000 Change hardware to all. Because this problem exists on x86 too. Could somebody check in my fixed ebuild. Thanks. mkennedy@gentoo.org 2005-12-29 15:31:53 0000 I committed a new ebuild for dev-lisp/cl-sql-3.5.2 which should fix any multilib issues. It goes about locating the shared libraries a little differently to how you have done it. Please test. If it works, I'll request arch testers to make it the new stable for x86. i@digash.com 2005-12-30 17:27:24 0000 (In reply to comment #3) > I committed a new ebuild for dev-lisp/cl-sql-3.5.2 which should fix any > multilib issues. It goes about locating the shared libraries a little > differently > to how you have done it. Please test. If it works, I'll request arch testers > to > make it the new stable for x86. > I tried it and it does not work on x86 or x86_64. I get this: STYLE-WARNING: Undefined alien: "clsql_mysql_num_rows" STYLE-WARNING: Undefined alien: "clsql_mysql_affected_rows" STYLE-WARNING: Undefined alien: "clsql_mysql_insert_id" STYLE-WARNING: Undefined alien: "clsql_mysql_data_seek" Error Attempt to call an undefined alien function. When I try to connect execute some SQL. The (connect ...) is succeeding. Need to dig deeper. mkennedy@gentoo.org 2005-12-31 11:21:00 0000 Here is the output of my test in SBCL for dev-lisp/cl-sql-3.5.2: CL-USER> (asdf:oos 'asdf:load-op :clsql-mysql) ... CL-USER> (defpackage #:test (:use #:common-lisp)) #<PACKAGE "TEST"> CL-USER> TEST> (clsql:connect '(nil "database01" "root" "...")) #<CLSQL-MYSQL:MYSQL-DATABASE localhost/database01/root OPEN {A7DBD71}> TEST> (clsql:query "select * from table01") ((1 "first")) ("field01" "field02") TEST> Are you using the latest cl-sql ebuild? ie. 3.5.2? It looks like the clsql_mysql.so is not being loaded. I'll check that out. mkennedy@gentoo.org 2005-12-31 11:49:48 0000 I found a typo in the path to clsql_mysql.so which would prevent it from being loaded. I committed the fix to portage. It should be available via rsync in and hour or so (same ebuild version - 3.5.2) i@digash.com 2006-01-01 15:06:56 0000 (In reply to comment #6) That did it. It works on the x86 and x86_64. Happy New Year! mkennedy@gentoo.org 2006-01-01 17:19:31 0000 Thanks. You too. 67698 2005-09-05 13:59 0000 new working ebuild cl-sql-3.2.1-r1.ebuild application/octet-stream IyBDb3B5cmlnaHQgMTk5OS0yMDA1IEdlbnRvbyBGb3VuZGF0aW9uCiMgRGlzdHJpYnV0ZWQgdW5k ZXIgdGhlIHRlcm1zIG9mIHRoZSBHTlUgR2VuZXJhbCBQdWJsaWMgTGljZW5zZSB2MgojICRIZWFk ZXI6IC92YXIvY3Zzcm9vdC9nZW50b28teDg2L2Rldi1saXNwL2NsLXNxbC9jbC1zcWwtMy4yLjEu ZWJ1aWxkLHYgMS4yIDIwMDUvMDgvMjMgMTg6MTk6MjUgbWtlbm5lZHkgRXhwICQKCmluaGVyaXQg Y29tbW9uLWxpc3AgZXV0aWxzCgpERVNDUklQVElPTj0iQSBtdWx0aS1wbGF0Zm9ybSBTUUwgaW50 ZXJmYWNlIGZvciBDb21tb24gTGlzcCIKSE9NRVBBR0U9Imh0dHA6Ly9jbHNxbC5iOS5jb20vCglo dHRwOi8vcGFja2FnZXMuZGViaWFuLm9yZy91bnN0YWJsZS9kZXZlbC9jbC1zcWwuaHRtbAoJaHR0 cDovL3d3dy5jbGlraS5uZXQvQ0xTUUwiClNSQ19VUkk9Imh0dHA6Ly9maWxlcy5iOS5jb20vY2xz cWwvY2xzcWwtJHtQVn0udGFyLmd6IgpMSUNFTlNFPSJMTEdQTC0yLjEiClNMT1Q9IjAiCktFWVdP UkRTPSJ+YW1kNjQgfnBwYyB+c3BhcmMgeDg2IgpJVVNFPSJwb3N0Z3JlcyBteXNxbCBzcWxpdGUg c3FsaXRlMyBvZGJjIgpERVBFTkQ9ImRldi1saXNwL2NvbW1vbi1saXNwLWNvbnRyb2xsZXIKCXZp cnR1YWwvY29tbW9ubGlzcAoJZGV2LWxpc3AvY2wtbWQ1Cgk+PWRldi1saXNwL2NsLXVmZmktMS40 LjM4Cglwb3N0Z3Jlcz8gKCBkZXYtZGIvcG9zdGdyZXNxbCApCglteXNxbD8gKCBkZXYtZGIvbXlz cWwgKQoJc3FsaXRlPyAoID1kZXYtZGIvc3FsaXRlLTIqICkKCXNxbGl0ZTM/ICggPWRldi1kYi9z cWxpdGUtMyogKQoJb2RiYz8gKCBkZXYtZGIvdW5peE9EQkMgKSIKClM9JHtXT1JLRElSfS9jbHNx bC0ke1BWfQoKIyBIYXZlIHRvIGRvIHRoaXMgaW4gYSBzdGF0aWMgbWFubmVyLCBpdCBzZWVtcy4K CkNMUEFDS0FHRT0nY2xzcWwgY2xzcWwtdWZmaSBjbHNxbC1wb3N0Z3Jlc3FsIGNsc3FsLXBvc3Rn cmVzcWwtc29ja2V0IGNsc3FsLW15c3FsIGNsc3FsLW9kYmMgY2xzcWwtc3FsaXRlIGNsc3FsLXNx bGl0ZTMnCgpzcmNfY29tcGlsZSgpIHsKCW1ha2UgLUMgdWZmaSB8fCBkaWUKCXVzZSBteXNxbCAm JiBtYWtlIC1DIGRiLW15c3FsCn0KCnNyY19pbnN0YWxsKCkgewoJZG9kaXIgJENMU1lTVEVNUk9P VAoJZG9kaXIgJENMU09VUkNFUk9PVAoKCWluc2ludG8gJENMU09VUkNFUk9PVC9jbHNxbC9zcWw7 IGRvaW5zIHNxbC8qLmxpc3AKCWluc2ludG8gJENMU09VUkNFUk9PVC9jbHNxbDsgZG9pbnMgY2xz cWwuYXNkCglkb3N5bSAkQ0xTT1VSQ0VST09UL2Nsc3FsL2Nsc3FsLmFzZCAkQ0xTWVNURU1ST09U L2Nsc3FsLmFzZAoKCWluc2ludG8gJENMU09VUkNFUk9PVC9jbHNxbC11ZmZpL3VmZmk7IGRvaW5z IHVmZmkvKi5saXNwCglpbnNpbnRvICRDTFNPVVJDRVJPT1QvY2xzcWwtdWZmaTsgZG9pbnMgY2xz cWwtdWZmaS5hc2QKCWRvc3ltICRDTFNPVVJDRVJPT1QvY2xzcWwtdWZmaS9jbHNxbC11ZmZpLmFz ZCAkQ0xTWVNURU1ST09UL2Nsc3FsLXVmZmkuYXNkCglleGVpbnRvIC91c3IvJChnZXRfbGliZGly KS9jbHNxbC87IGRvZXhlIHVmZmkvY2xzcWxfdWZmaS5zbwoKCWlmIHVzZSBwb3N0Z3JlczsgdGhl bgoJCWluc2ludG8gJENMU09VUkNFUk9PVC9jbHNxbC1wb3N0Z3Jlc3FsL2RiLXBvc3RncmVzcWw7 IGRvaW5zIGRiLXBvc3RncmVzcWwvKi5saXNwCgkJaW5zaW50byAkQ0xTT1VSQ0VST09UL2Nsc3Fs LXBvc3RncmVzcWw7IGRvaW5zIGNsc3FsLXBvc3RncmVzcWwuYXNkCgkJZG9zeW0gJENMU09VUkNF Uk9PVC9jbHNxbC1wb3N0Z3Jlc3FsL2Nsc3FsLXBvc3RncmVzcWwuYXNkICRDTFNZU1RFTVJPT1Qv Y2xzcWwtcG9zdGdyZXNxbC5hc2QKCWZpCgoJaW5zaW50byAkQ0xTT1VSQ0VST09UL2Nsc3FsLXBv c3RncmVzcWwtc29ja2V0L2RiLXBvc3RncmVzcWwtc29ja2V0Cglkb2lucyBkYi1wb3N0Z3Jlc3Fs LXNvY2tldC8qLmxpc3AKCWluc2ludG8gJENMU09VUkNFUk9PVC9jbHNxbC1wb3N0Z3Jlc3FsLXNv Y2tldAoJZG9pbnMgY2xzcWwtcG9zdGdyZXNxbC1zb2NrZXQuYXNkCglkb3N5bSAkQ0xTT1VSQ0VS T09UL2Nsc3FsLXBvc3RncmVzcWwtc29ja2V0L2Nsc3FsLXBvc3RncmVzcWwtc29ja2V0LmFzZCBc CgkJJENMU1lTVEVNUk9PVC9jbHNxbC1wb3N0Z3Jlc3FsLXNvY2tldC5hc2QKCglpZiB1c2UgbXlz cWw7IHRoZW4KCQlpbnNpbnRvICRDTFNPVVJDRVJPT1QvY2xzcWwtbXlzcWwvZGItbXlzcWw7IGRv aW5zIGRiLW15c3FsLyoubGlzcCBkYi1teXNxbC8qLmMKCQlpbnNpbnRvICRDTFNPVVJDRVJPT1Qv Y2xzcWwtbXlzcWw7IGRvaW5zIGNsc3FsLW15c3FsLmFzZAoJCWRvc3ltICRDTFNPVVJDRVJPT1Qv Y2xzcWwtbXlzcWwvY2xzcWwtbXlzcWwuYXNkICRDTFNZU1RFTVJPT1QvY2xzcWwtbXlzcWwuYXNk CgkJZXhlaW50byAvdXNyLyQoZ2V0X2xpYmRpcikvY2xzcWwvOyBkb2V4ZSBkYi1teXNxbC9jbHNx bF9teXNxbC5zbwoJZmkKCglpZiB1c2Ugb2RiYzsgdGhlbgoJCWluc2ludG8gJENMU09VUkNFUk9P VC9jbHNxbC1vZGJjL2RiLW9kYmM7IGRvaW5zIGRiLW9kYmMvKi5saXNwCgkJaW5zaW50byAkQ0xT T1VSQ0VST09UL2Nsc3FsLW9kYmM7IGRvaW5zIGNsc3FsLW9kYmMuYXNkCgkJZG9zeW0gJENMU09V UkNFUk9PVC9jbHNxbC1vZGJjL2Nsc3FsLW9kYmMuYXNkICRDTFNZU1RFTVJPT1QvY2xzcWwtb2Ri Yy5hc2QKCWZpCgoJaWYgdXNlIHNxbGl0ZTsgdGhlbgoJCWluc2ludG8gJENMU09VUkNFUk9PVC9j bHNxbC1zcWxpdGUvZGItc3FsaXRlOyBkb2lucyBkYi1zcWxpdGUvKi5saXNwCgkJaW5zaW50byAk Q0xTT1VSQ0VST09UL2Nsc3FsLXNxbGl0ZTsgZG9pbnMgY2xzcWwtc3FsaXRlLmFzZAoJCWRvc3lt ICRDTFNPVVJDRVJPT1QvY2xzcWwtc3FsaXRlL2Nsc3FsLXNxbGl0ZS5hc2QgJENMU1lTVEVNUk9P VC9jbHNxbC1zcWxpdGUuYXNkCglmaQoKCWlmIHVzZSBzcWxpdGUzOyB0aGVuCgkJaW5zaW50byAk Q0xTT1VSQ0VST09UL2Nsc3FsLXNxbGl0ZTMvZGItc3FsaXRlMzsgZG9pbnMgZGItc3FsaXRlMy8q Lmxpc3AKCQlpbnNpbnRvICRDTFNPVVJDRVJPT1QvY2xzcWwtc3FsaXRlMzsgZG9pbnMgY2xzcWwt c3FsaXRlMy5hc2QKCQlkb3N5bSAkQ0xTT1VSQ0VST09UL2Nsc3FsLXNxbGl0ZTMvY2xzcWwtc3Fs aXRlMy5hc2QgJENMU1lTVEVNUk9PVC9jbHNxbC1zcWxpdGUzLmFzZAoJZmkKCgkjIGFkZCBwYXRo IHRvIHRoZSBuYXRpdmUgbGlicmFyaWVzCgllY2hvICJMRFBBVEg9L3Vzci8kKGdldF9saWJkaXIp L2Nsc3FsLyIgPiA1MGNsc3FsCglkb2VudmQgNTBjbHNxbAoJZWNobyAiKGNsc3FsLXN5czo6cHVz aC1saWJyYXJ5LXBhdGggXCIvdXNyLyQoZ2V0X2xpYmRpcikvY2xzcWwvXCIpIiA+IGNsc3FsLWlu aXQubGlzcAoJaW5zaW50byAvZXRjCglkb2lucyBjbHNxbC1pbml0Lmxpc3AKCglkb2RvYyBCVUdT IENPTlRSSUJVVE9SUyBDT1BZSU5HKiBDaGFuZ2VMb2cgSU5TVEFMTCBMQVRFU1QtVEVTVC1SRVNV TFRTIE5FV1MgUkVBRE1FIFRPRE8KCWRvZG9jIGRvYy9jbHNxbC5wZGYKCXRhciB4ZnogZG9jL2h0 bWwudGFyLmd6IC1DICR7RH0vdXNyL3NoYXJlL2RvYy8ke1BGfS8KCWRvLWRlYmlhbi1jcmVkaXRz CglpbnNpbnRvIC91c3Ivc2hhcmUvZG9jLyR7UEZ9L2V4YW1wbGVzCglkb2lucyBleGFtcGxlcy8q Cn0K