Guest
|
Posted: Mon Jul 12, 1999 2:28 pm Post subject: Re: [iHTML] Problem using unixODBC and MyODBC |
|
|
Here's a copy of a post from the iHTML list. It may provide a clue for you:
~FINALLY! It works!
~
~Here's the short form: The binary copy of libmyodbc_mysql.so Jon sent me
~was corrupted during the transfer. However, I had no way to verify its
~operation.
~
~The longer form for those who are still having trouble:
~
~First Apache wouldn't work with iHTML. So I recompiled according to
~Inline's instructions, and used iHTML 2.18b3. That solved that. But now
~it wouldn't talk to MySQL. Since iODBC returns no helpful error
~information, I couldn't be sure where the problem was. iHTML worked, but
~wouldn't talk to MySQL. Possible suspects were Linux and MySQL access
~permissions, the configuration of my iodbc.ini file, and
~libmyodbc_mysql.so.
~
~I initially tried playing with all the other suspects. I exhausted
~everything including my patience, and turned to libmyodbc_mysql.so. I
~grabbed the source from tcx.se, and tried to compile it. I came to find
~that this isn't for the faint of heart -- unless you're familiar with
~MySQL's source installer configuration, it's really tough. I'm not.
~
~So I asked Jon about it, and he kindly sent me his binary of
~libmyodbc_mysql.so. However, it wasn't tar'd or zipped. This didn't occur
~to me as a potential problem until later.
~
~So I installed it, the MySQL connection still didn't work, and I just
~kept plugging away like a prison laborer. I revisited all the options,
~checked all the logs, and nothing worked. So I went back to
~libmyodbc_mysql.so as my suspect.
~
~I downloaded the source again, and waded through all the configs to make
~it compile. It could never seem to find a particular header library, I
~emailed the author, he didn't reply, and I was generally hopeless. I
~enlisted the help of a Unix expert friend, and was waiting for him to
~come by when...
~
~I was browsing Dejanews and found a thread in German on
~libmyodbc_mysql.so -- lucky I spent a couple of years there. This guy
~also had a problem compiling it, but listed a link to a good i386 binary:
~
~http://www.uni-koblenz.de/~horn/export/iodbc.tgz
~
~I downloaded it, found the shared object amongst the other stuff in the
~archive, popped it in, and VICTORY!
~
~So now I'm one of, what, two people using this combo? I feel so
~privileged.
~
~Steve Freitas
~Newport Beach, California
_________________________________________________________
At 10:09 AM 7/12/99 -0500, you wrote:
| Quote: |
Thanks - that will come handy when I get that far. I have yet
to get the DSN working - I can't connect to the database using
isql or Datamanager yet.
Gary
[email]dougb (AT) inline (DOT) net[/email] wrote:
You'll need to symlink /usr/lib/libodbc.so to /usr/lib/libiodbc.so.
iHTML expects the driver manager to be named libiodbc.
run ldconfig after you create this symlink.
Doug
On Mon, 12 Jul 1999, you wrote:
Hi!
I hope to use MySQL with iHTML - I am almost there!
I am having problems using unixODBC with MyODBC to connect to a
MySQL database. I am running MySQL 3.22.24 and MyODBC 2.50.24 on
Linux 2.0.36.
- I configured myodbc with:
../configure --with-mysql-sources=/home/mysrces/mysql/mysql-3.22.24
---with-unixODBC=/usr --with-unixODBC-libs=/usr/lib
--with-unixODBC-includes=/usr/include
- the make and make install ran ok, and installed the driver
in /usr/local/lib
- I used ODBCConfig to add the driver using:
Driver Lib: /usr/local/lib/libmyodbc.so
Setup Lib: /usr/lib/libodbcmyS.so.1.0.0 [this is from unixODBC]
- I used ODBCCOnfig to create a system DSN for the test database:
Name: MySQLTest
Host: localhost
Port: 3306
Socket: /tmp/mysql.sock
Database: test
- I ran DataManager and tried to connect but I got:
Login Failed
This may be for one of these reasons:
1. Invalid ID and Password
2. Invalid Data Source Config
3. Improper installation
- I ran "isql MySQLTest" and got:
[ISQL]ERROR: Could not SQLConnect
- I did a DSN trace and found this:
[ODBC][28619][SQLConnect.c][170]Error: IM003
[ODBC][28619][SQLConnect.c][892]
Entry:
Connection = 0x8084390
Server Name = [MySQLTest][length = 9 (SQL_NTS)]
User Name = [testuser][length = 8 (SQL_NTS)]
Authentication = [mypasswd][length = 8
(SQL_NTS)]
[ODBC][28619][SQLConnect.c][170]Error: IM003
- I don't think that it is a permissions problem because I am able
to connect to the database using mysql monitor and the same
user/password combo. In addition, I was able to use the Windows
ODBC driver to connect to the test database using that
username/password
combo.
Any ideas? Thanks in advance!
Gary Wong
[email]gary.wong (AT) spingroup (DOT) com[/email]
To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.
--
----------------------------------
Doug Bell
Software Developer
Inline Internet Systems Inc.
----------------------------------
To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.
To unsubscribe from this mailing list send an email to [email]custserv (AT) ihtml (DOT) com[/email]
asking to be removed.
|
-------------------
Hood Gardner - Webmaster/Network Admin for Osment Models, Inc.
[email]webmaster (AT) woodlandscenics (DOT) com[/email]
http://www.woodlandscenics.com/
http://www.dpmkits.com
http://www.pinecar.com/
|
|