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:
>
>
>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
>
>dougb@stripped 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
>> > gary.wong@stripped
>> >
>> >
>> >
>> > To unsubscribe from this mailing list send an email to custserv@stripped
>> > asking to be removed.
>> --
>> ----------------------------------
>> Doug Bell
>> Software Developer
>> Inline Internet Systems Inc.
>> ----------------------------------
>>
>> To unsubscribe from this mailing list send an email to custserv@stripped
>> asking to be removed.
>
>
>
>To unsubscribe from this mailing list send an email to custserv@stripped
>asking to be removed.
>
>
>
>
-------------------
Hood Gardner - Webmaster/Network Admin for Osment Models, Inc.
webmaster@stripped
http://www.woodlandscenics.com/
http://www.dpmkits.com
http://www.pinecar.com/
| Thread |
|---|
| • Re: [iHTML] Problem using unixODBC and MyODBC | (Hood Gardner) | 12 Jul |
