Re: WebDNA and SQL
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51094
interpreted = N
texte = hi,Any further info on getting webcat to work with unixodbc and myodbc on =20=linux?I followed this step by step and get the following error:---- /sql.html SQL Error: 00000=80=EA=1B=08=A0=F3%@=E4!=A6A=FF=FF=FF=FF Found 0 items DONE QUERY MySQL----ThanksOn Tuesday, May 6, 2003, at 02:19 PM, Sal D'anna wrote:> Jim Lanford is working on this step by step. This is a draft he sent =20=> to me.>>> 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 =20> 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)>> I'm a MySQL / ODBC nubie, so there is a good chance that I'm doing =20> something> wrong with the configure / install of unixODBC and / or MyODBC>> - 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 =20=> 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 =20> server> name> - The servers are all remote so I can't use the ODBC GUI stuff.>>> ## ODBC was written by Microsoft so all the books talk about running =20=> it on> Windows> ## and using windows the configure ODBC> ## On Linux, you can use a text editor to edit the odbc.ini files>> ## 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.>>> I've installed WebCatalog / Apache many times on many Linux =20> configurations> (even MacOSX).> http://www.smithmicro.com/isd/webcatalog/> WebCatalog / Apache works fine and will give 'Error: SQL not =20> supported' if> 'WebCatalog Prefs' does not contain the correct path to unixODBC>> - - - - -Edit - WebCatalog Prefs - - - - - - - - - -> SQLLibraryPath/usr/local/unixODBC/lib/libodbc.so> - - - - - - - - - - - - - - - - - - - - ->> I don't get the 'SQL not supported' error, I get the other SQL error =20=> 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.>>> After Apache / WebCat was working, this is what I did:>> ## get the needed software> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> 3.23.38-1> .i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> client-3.> 23.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> shared-3.> 23.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> devel-3.2> 3.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MyODBC/MyODBC-=20> 2.50.37.tar.> gz> lynx http://www.unixodbc.org/unixODBC-2.0.6.tar.gz>> ## 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>>> ## get ready to compile> mv MyODBC-2.50.37.tar.gz /usr/local/> mv unixODBC-2.0.6.tar.gz /usr/local/>> cd /usr/local/> tar xzf MyODBC-2.50.37.tar.gz> tar xzf unixODBC-2.0.6.tar.gz>> 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>>> 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> ##>> ## 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>>> - - - - - - template_file - - - - - - - - -> [Myodbc]> Decription =3D Myodbc> Driver =3D /usr/local/unixODBC/lib/libmyodbc.so> Setup =3D /usr/local/unixODBC/lib/libodbcmyS.so> - - - - - - - - - - - - - - - - - - - - ->> - - - - - - 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>> # repeat for each server> [MySQLtwo]> - - - - - - - - - - - - - - - - - - - - ->> # - - - - - - My SQL setup - - - - - - - - - ->> 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>> 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');>> - - - - - - - - - - - - - - - - - - - - ->> # WebCat html page: one per server> - - - - - - testone.tpl - - - - - - - - - -> > > > [thisURL]
> [sql dsn=3DMySQLone&username=3Dmartin&password=3Dnumber9&statement=3DSEL=ECT *> FROM Beatles;]> Found [NumFound] items
> [FoundItems]> Name =3D [Name], inst =3D [inst]
> [/FoundItems]> [/sql]>
DONE QUERY MySQL > > > - - - - - - - - - - - - - - - - - - - - ->> I wanted to be complete enough so that others could try the same =setup.>>>> TIA>> - Jim>>-------------------------------------------------------------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:
hi,Any further info on getting webcat to work with unixODBC and myODBC on =20=linux?I followed this step by step and get the following error:---- /sql.html SQL Error: 00000=80=EA=1B=08=A0=F3%@=E4!=A6A=FF=FF=FF=FF Found 0 items DONE QUERY MySQL----ThanksOn Tuesday, May 6, 2003, at 02:19 PM, Sal D'anna wrote:> Jim Lanford is working on this step by step. This is a draft he sent =20=> to me.>>> 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 =20> 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)>> I'm a MySQL / ODBC nubie, so there is a good chance that I'm doing =20> something> wrong with the configure / install of unixODBC and / or MyODBC>> - 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 =20=> 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 =20> server> name> - The servers are all remote so I can't use the ODBC GUI stuff.>>> ## ODBC was written by Microsoft so all the books talk about running =20=> it on> Windows> ## and using windows the configure ODBC> ## On Linux, you can use a text editor to edit the ODBC.ini files>> ## 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.>>> I've installed WebCatalog / Apache many times on many Linux =20> configurations> (even MacOSX).> http://www.smithmicro.com/isd/webcatalog/> WebCatalog / Apache works fine and will give 'Error: SQL not =20> supported' if> 'WebCatalog Prefs' does not contain the correct path to unixODBC>> - - - - -Edit - WebCatalog Prefs - - - - - - - - - -> SQLLibraryPath/usr/local/unixODBC/lib/libODBC.so> - - - - - - - - - - - - - - - - - - - - ->> I don't get the 'SQL not supported' error, I get the other SQL error =20=> 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.>>> After Apache / WebCat was working, this is what I did:>> ## get the needed software> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> 3.23.38-1> .i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> client-3.> 23.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> shared-3.> 23.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/MySQL-=20> devel-3.2> 3.38-1.i386.rpm> ncftpget> ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MyODBC/MyODBC-=20> 2.50.37.tar.> gz> lynx http://www.unixODBC.org/unixODBC-2.0.6.tar.gz>> ## 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>>> ## get ready to compile> mv MyODBC-2.50.37.tar.gz /usr/local/> mv unixODBC-2.0.6.tar.gz /usr/local/>> cd /usr/local/> tar xzf MyODBC-2.50.37.tar.gz> tar xzf unixODBC-2.0.6.tar.gz>> 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>>> 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> ##>> ## 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>>> - - - - - - template_file - - - - - - - - -> [MyODBC]> Decription =3D MyODBC> Driver =3D /usr/local/unixODBC/lib/libmyODBC.so> Setup =3D /usr/local/unixODBC/lib/libODBCmyS.so> - - - - - - - - - - - - - - - - - - - - ->> - - - - - - 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>> # repeat for each server> [MySQLtwo]> - - - - - - - - - - - - - - - - - - - - ->> # - - - - - - My SQL setup - - - - - - - - - ->> 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>> 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');>> - - - - - - - - - - - - - - - - - - - - ->> # WebCat html page: one per server> - - - - - - testone.tpl - - - - - - - - - -> > > > [thisurl]
> [sql dsn=3DMySQLone&username=3Dmartin&password=3Dnumber9&statement=3DSEL=ECT *> FROM Beatles;]> Found [NumFound] items
> [founditems]> Name =3D [Name], inst =3D [inst]
> [/FoundItems]> [/sql]> DONE QUERY MySQL
> > > - - - - - - - - - - - - - - - - - - - - ->> I wanted to be complete enough so that others could try the same =setup.>>>> TIA>> - Jim>>-------------------------------------------------------------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/
Dale's Stuff
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:
Smith Micro - no competition (2000)
problems with dos and tracert + webDNA (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Subtotal Not Calculated on Invoice.html (1998)
[WebDNA] showif/sendmail question (2008)
date (2002)
delete credit card number (2002)
[/application] error? (1997)
createfolder permissions (2003)
how do I delete 1 of 2 identical records? (2003)
Need relative path explanation (1997)
PDF Generation and cataloging (2002)
Using [Showif] tag. Mac (1997)
No. of items in shopping cart (2000)
Time limit to WebDNA solution (2001)
Email (1998)
beta 5 - OS X [replacefounditems] syntax & suggestion (2000)
[BULK] [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
Practical Uses (2003)
RE: date (1998)