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:
WebMerchant 1.6 and SHTML (1997)
Help! WebCat2 bug (1997)
relogin same user? (1998)
What abobut variables named max ??? (2000)
Using the sendmail command on CGate Pro (Unix) (2000)
More on the email templates (1997)
Email Formatting (2001)
Sandbox DB permissions (2005)
Re:Emailer setup (1997)
Multiple prices (1997)
Encrypt question. (2000)
Changes to the List (1997)
textarea to page display (1998)
Is there an easier way? (1998)
Not really WebCat (1997)
PCS Frames (1997)
Error Lob.db records error message not name (1997)
[Shell] question (2000)
foriegn characters and webcatalog (1997)
listfiles shows invisible files ... (1999)