Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51111
interpreted = N
texte = Can you connect using ISQL - and the DSN that you are trying to get WebCatalog to use...?On 6/14/03 11:36 AM, Dale's Stuff
wrote:> hi, >=20 > Any further info on getting webcat to work with unixodbc and myodbc on > linux? >=20 > I followed this step by step and get the following error: >=20 > ---- > /sql.html >=20 >=20 > SQL Error: 00000 > =E2=82=AC=C3=AA=1B=08=C2=A0=C3=B3%@=C3=A4!=E2=88=ABA=C3=BF=C3=BF=C3=BF=C3=BF Found 0 items > DONE QUERY MySQL >=20 > ---- >=20 > Thanks >=20 >=20 >=20 > On Tuesday, May 6, 2003, at 02:19 PM, Sal D'anna wrote: >=20 >> Jim Lanford is working on this step by step. This is a draft he sent >> to me. >>=20 >>=20 >> This is a start of a mini HowTo for getting Linux WebCatalog, unixODBC, >> MyODBC to work with MySQL >> It's a work in progress. The ODBC part worked only on 2 of 4 >> servers. >> Q1: Do I have a config problem with unixODBC or MyODBC ? >> Q2: Is there a way for force the ODBC Libraries to reload / reset (or >> something)? >> Q3: Are there other Linux clients to easily test the ODBC stuff with. >> (that will return a better error message on ODBC conf issues) >>=20 >> I'm a MySQL / ODBC nubie, so there is a good chance that I'm doing >> something >> wrong with the configure / install of unixODBC and / or MyODBC >>=20 >> - I have 4 Linux servers on the Internet 3 RH 6.2 and one RH 7.0 >> - WebCatalog/ Apache work on all 4 >> - MySQL works on all 4 >> - ODBC only works on 2 >> - I set them up the same way by pasting the below commands into a term >> window to avoid typos and be consistent across all 4 servers. >> - Using exact same odbc.ini and WebCatalog templates, the 2 working >> servers >> and talk to all 4 test databases. >> (one of them is local) >> - The 4 databases are the same with an extra record containing the >> server >> name >> - The servers are all remote so I can't use the ODBC GUI stuff. >>=20 >>=20 >> ## ODBC was written by Microsoft so all the books talk about running >> it on >> Windows >> ## and using windows the configure ODBC >> ## On Linux, you can use a text editor to edit the odbc.ini files >>=20 >> ## on Linux, my setup looks like this >> 1) Application (WebCatalog) >> 2) ODBC Driver Manager (unixODBC) >> 3) ODBC Driver (MyODBC) >> --- internet --- >> 4) DB - MySQL server B -- MySQL server C -- etc. >>=20 >>=20 >> I've installed WebCatalog / Apache many times on many Linux >> configurations >> (even MacOSX). >> http://www.smithmicro.com/isd/webcatalog/ >> WebCatalog / Apache works fine and will give 'Error: SQL not >> supported' if >> 'WebCatalog Prefs' does not contain the correct path to unixODBC >>=20 >> - - - - -Edit - WebCatalog Prefs - - - - - - - - - - >> SQLLibraryPath /usr/local/unixODBC/lib/libodbc.so >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> I don't get the 'SQL not supported' error, I get the other SQL error >> which >> is returned for all other SQL problems >> SQL Error: 00000 >> Playing arround with a working system, I can get this error when >> - odbc.ini is setup incorrectly >> - the WebCat .tpl file has an error >> - the remote and local passwords do not match >> - the remote SQL server is down and so on. >>=20 >>=20 >> After Apache / WebCat was working, this is what I did: >>=20 >> ## get the needed software >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> 3.23.38-1 >> .i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> client-3. >> 23.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> shared-3. >> 23.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> devel-3.2 >> 3.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MyODBC/MyODBC- >> 2.50.37.tar. >> gz >> lynx http://www.unixodbc.org/unixODBC-2.0.6.tar.gz >>=20 >> ## install the RPMs >> rpm -Uvh MySQL-shared-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-devel-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-client-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-3.23.38-1.i386.rpm >> on one server I needed: >> rpm -Uvh --nodeps --force MySQL-3.23.38-1.i386.rpm >>=20 >>=20 >> ## get ready to compile >> mv MyODBC-2.50.37.tar.gz /usr/local/ >> mv unixODBC-2.0.6.tar.gz /usr/local/ >>=20 >> cd /usr/local/ >> tar xzf MyODBC-2.50.37.tar.gz >> tar xzf unixODBC-2.0.6.tar.gz >>=20 >> cd /usr/local/unixODBC-2.0.6/ >> ./configure \ >> --prefix=3D/usr/local/unixODBC \ >> --x-include=3D/usr/X11R6/include \ >> --x-libraries=3D/usr/X11R6/lib >> ## this make can take one hour >> make >> make install >>=20 >>=20 >> cd /usr/local/MyODBC-2.50.37 >> ./configure \ >> --prefix=3D/usr/local/unixODBC \ >> --with-mysql-dirs=3D/usr/lib/mysql \ >> --with-mysql-includes=3D/usr/include/mysql \ >> --with-unixODBC=3D/usr/local/unixODBC >> make >> make install >> ## >>=20 >> ## build the odbcinst.ini and odbc.ini files >> ## using the same info from the working server >> cd /usr/local/unixODBC/bin/ >> ./odbcinst -i -d -f template_file >> ./odbcinst -i -s -f template_file1 >>=20 >>=20 >> - - - - - - template_file - - - - - - - - - >> [Myodbc] >> Decription =3D Myodbc >> Driver =3D /usr/local/unixODBC/lib/libmyodbc.so >> Setup =3D /usr/local/unixODBC/lib/libodbcmyS.so >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> - - - - - - template_file - - - - - - - - - >> [MySQLone] >> Description =3D myodbc >> Driver =3D /usr/local/unixODBC/lib/libmyodbc.so >> Trace =3D Yes >> TraceFile =3D sql1.log >> # need IP address for the server below >> Server =3D 192.168.168.1 >> User =3D martin >> Password =3D number9 >> Port =3D 3306 >> Socket =3D >> Database =3D band >>=20 >> # repeat for each server >> [MySQLtwo] >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> # - - - - - - My SQL setup - - - - - - - - - - >>=20 >> Using the MySQL area Webmin >> http://www.webmin.com/webmin/ >> On each server I added a >> - db called band >> - table called Beatles >> With varchar 30 fields: Name and inst >>=20 >> Then I pasted into the 'Execute SQL >> INSERT INTO Beatles VALUES('George','Lead'); >> INSERT INTO Beatles VALUES('John','Rhythm'); >> INSERT INTO Beatles VALUES('Paul','Bass'); >> INSERT INTO Beatles VALUES('Ringo','Drums'); >> and on each server its name >> INSERT INTO Beatles VALUES('Server','NumberOne'); >>=20 >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> # WebCat html page: one per server >> - - - - - - testone.tpl - - - - - - - - - - >> >> >> >> [thisURL]
>> [sql dsn=3DMySQLone&username=3Dmartin&password=3Dnumber9&statement=3DSELECT * >> FROM Beatles;] >> Found [NumFound] items
>> [FoundItems] >> Name =3D [Name], inst =3D [inst]
>> [/FoundItems] >> [/sql] >> DONE QUERY MySQL
>> >> >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> I wanted to be complete enough so that others could try the same setup. >>=20 >>=20 >>=20 >> TIA >>=20 >> - Jim >>=20 >>=20 >=20 >=20 > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 --=20 Jay Van Vark 'Guiding Positive Change in High-Tech Companies' one box voicemail (866) 248-7670 x 6471 efax (801) 659-7952http://www.VanVark.net------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Can you connect using ISQL - and the DSN that you are trying to get WebCatalog to use...?On 6/14/03 11:36 AM, Dale's Stuff wrote:> hi, >=20 > Any further info on getting webcat to work with unixODBC and myODBC on > linux? >=20 > I followed this step by step and get the following error: >=20 > ---- > /sql.html >=20 >=20 > SQL Error: 00000 > =E2=82=AC=C3=AA=1B=08=C2=A0=C3=B3%@=C3=A4!=E2=88=ABA=C3=BF=C3=BF=C3=BF=C3=BF Found 0 items > DONE QUERY MySQL >=20 > ---- >=20 > Thanks >=20 >=20 >=20 > On Tuesday, May 6, 2003, at 02:19 PM, Sal D'anna wrote: >=20 >> Jim Lanford is working on this step by step. This is a draft he sent >> to me. >>=20 >>=20 >> This is a start of a mini HowTo for getting Linux WebCatalog, unixODBC, >> MyODBC to work with MySQL >> It's a work in progress. The ODBC part worked only on 2 of 4 >> servers. >> Q1: Do I have a config problem with unixODBC or MyODBC ? >> Q2: Is there a way for force the ODBC Libraries to reload / reset (or >> something)? >> Q3: Are there other Linux clients to easily test the ODBC stuff with. >> (that will return a better error message on ODBC conf issues) >>=20 >> I'm a MySQL / ODBC nubie, so there is a good chance that I'm doing >> something >> wrong with the configure / install of unixODBC and / or MyODBC >>=20 >> - I have 4 Linux servers on the Internet 3 RH 6.2 and one RH 7.0 >> - WebCatalog/ Apache work on all 4 >> - MySQL works on all 4 >> - ODBC only works on 2 >> - I set them up the same way by pasting the below commands into a term >> window to avoid typos and be consistent across all 4 servers. >> - Using exact same ODBC.ini and WebCatalog templates, the 2 working >> servers >> and talk to all 4 test databases. >> (one of them is local) >> - The 4 databases are the same with an extra record containing the >> server >> name >> - The servers are all remote so I can't use the ODBC GUI stuff. >>=20 >>=20 >> ## ODBC was written by Microsoft so all the books talk about running >> it on >> Windows >> ## and using windows the configure ODBC >> ## On Linux, you can use a text editor to edit the ODBC.ini files >>=20 >> ## on Linux, my setup looks like this >> 1) Application (WebCatalog) >> 2) ODBC Driver Manager (unixODBC) >> 3) ODBC Driver (MyODBC) >> --- internet --- >> 4) DB - MySQL server B -- MySQL server C -- etc. >>=20 >>=20 >> I've installed WebCatalog / Apache many times on many Linux >> configurations >> (even MacOSX). >> http://www.smithmicro.com/isd/webcatalog/ >> WebCatalog / Apache works fine and will give 'Error: SQL not >> supported' if >> 'WebCatalog Prefs' does not contain the correct path to unixODBC >>=20 >> - - - - -Edit - WebCatalog Prefs - - - - - - - - - - >> SQLLibraryPath /usr/local/unixODBC/lib/libODBC.so >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> I don't get the 'SQL not supported' error, I get the other SQL error >> which >> is returned for all other SQL problems >> SQL Error: 00000 >> Playing arround with a working system, I can get this error when >> - ODBC.ini is setup incorrectly >> - the WebCat .tpl file has an error >> - the remote and local passwords do not match >> - the remote SQL server is down and so on. >>=20 >>=20 >> After Apache / WebCat was working, this is what I did: >>=20 >> ## get the needed software >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> 3.23.38-1 >> .i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> client-3. >> 23.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> shared-3. >> 23.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL- >> devel-3.2 >> 3.38-1.i386.rpm >> ncftpget >> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MyODBC/MyODBC- >> 2.50.37.tar. >> gz >> lynx http://www.unixODBC.org/unixODBC-2.0.6.tar.gz >>=20 >> ## install the RPMs >> rpm -Uvh MySQL-shared-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-devel-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-client-3.23.38-1.i386.rpm >> rpm -Uvh MySQL-3.23.38-1.i386.rpm >> on one server I needed: >> rpm -Uvh --nodeps --force MySQL-3.23.38-1.i386.rpm >>=20 >>=20 >> ## get ready to compile >> mv MyODBC-2.50.37.tar.gz /usr/local/ >> mv unixODBC-2.0.6.tar.gz /usr/local/ >>=20 >> cd /usr/local/ >> tar xzf MyODBC-2.50.37.tar.gz >> tar xzf unixODBC-2.0.6.tar.gz >>=20 >> cd /usr/local/unixODBC-2.0.6/ >> ./configure \ >> --prefix=3D/usr/local/unixODBC \ >> --x-include=3D/usr/X11R6/include \ >> --x-libraries=3D/usr/X11R6/lib >> ## this make can take one hour >> make >> make install >>=20 >>=20 >> cd /usr/local/MyODBC-2.50.37 >> ./configure \ >> --prefix=3D/usr/local/unixODBC \ >> --with-mysql-dirs=3D/usr/lib/mysql \ >> --with-mysql-includes=3D/usr/include/mysql \ >> --with-unixODBC=3D/usr/local/unixODBC >> make >> make install >> ## >>=20 >> ## build the ODBCinst.ini and ODBC.ini files >> ## using the same info from the working server >> cd /usr/local/unixODBC/bin/ >> ./ODBCinst -i -d -f template_file >> ./ODBCinst -i -s -f template_file1 >>=20 >>=20 >> - - - - - - template_file - - - - - - - - - >> [MyODBC] >> Decription =3D MyODBC >> Driver =3D /usr/local/unixODBC/lib/libmyODBC.so >> Setup =3D /usr/local/unixODBC/lib/libODBCmyS.so >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> - - - - - - template_file - - - - - - - - - >> [MySQLone] >> Description =3D myODBC >> Driver =3D /usr/local/unixODBC/lib/libmyODBC.so >> Trace =3D Yes >> TraceFile =3D sql1.log >> # need IP address for the server below >> Server =3D 192.168.168.1 >> User =3D martin >> Password =3D number9 >> Port =3D 3306 >> Socket =3D >> Database =3D band >>=20 >> # repeat for each server >> [MySQLtwo] >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> # - - - - - - My SQL setup - - - - - - - - - - >>=20 >> Using the MySQL area Webmin >> http://www.webmin.com/webmin/ >> On each server I added a >> - db called band >> - table called Beatles >> With varchar 30 fields: Name and inst >>=20 >> Then I pasted into the 'Execute SQL >> INSERT INTO Beatles VALUES('George','Lead'); >> INSERT INTO Beatles VALUES('John','Rhythm'); >> INSERT INTO Beatles VALUES('Paul','Bass'); >> INSERT INTO Beatles VALUES('Ringo','Drums'); >> and on each server its name >> INSERT INTO Beatles VALUES('Server','NumberOne'); >>=20 >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> # WebCat html page: one per server >> - - - - - - testone.tpl - - - - - - - - - - >> >> >> >> [thisurl]
>> [sql dsn=3DMySQLone&username=3Dmartin&password=3Dnumber9&statement=3DSELECT * >> FROM Beatles;] >> Found [NumFound] items
>> [founditems] >> Name =3D [Name], inst =3D [inst]
>> [/FoundItems] >> [/sql] >> DONE QUERY MySQL
>> >> >> - - - - - - - - - - - - - - - - - - - - - >>=20 >> I wanted to be complete enough so that others could try the same setup. >>=20 >>=20 >>=20 >> TIA >>=20 >> - Jim >>=20 >>=20 >=20 >=20 > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ >=20 --=20 Jay Van Vark 'Guiding Positive Change in High-Tech Companies' one box voicemail (866) 248-7670 x 6471 efax (801) 659-7952http://www.VanVark.net------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Jay Van Vark
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Authorize.net, SIM, tcpconnect and applescript (2003)
Country & Ship-to address & other fields ? (1997)
GoodPath and MoveFile (2000)
& Aftermath (1999)
RE: protect tag on NT (1997)
error (2000)
2.1b3 --> way slow (1997)
Open Market's Transact & Macintosh (1998)
[protect admin] (1997)
triggers.db (1999)
[WebDNA] how can i grab the contents of a post? (2011)
form data submission gets truncated (1997)
Time comparison question (1998)
Need help with emailer- 2 issues (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
http or https? (2001)
WC2b15 File Corruption (1997)
Ampersand (1997)
A note for NT4 users (1998)
docs for WebCatalog2 (1997)