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:

    
  1. WebDNA and SQL - encrypted passwords ( Larry Hewitt 2006)
  2. Re: WebDNA and SQL (Jay Van Vark 2003)
  3. Re: WebDNA and SQL (Dale's Stuff 2003)
  4. Re: WebDNA and SQL (Gary Krockover 2003)
  5. Re: WebDNA and SQL (Alain Russell 2003)
  6. Re: WebDNA and SQL (Phillip Bonesteele 2003)
  7. Re: WebDNA and SQL (Alain Russell 2003)
  8. Re: WebDNA and SQL (Alain Russell 2003)
  9. Re: WebDNA and SQL (Clint Davis 2003)
  10. Re: WebDNA and SQL (Alain Russell 2003)
  11. Re: WebDNA and SQL (Sal D'anna 2003)
  12. Re: WebDNA and SQL (Clint Davis 2003)
  13. Re: WebDNA and SQL (Jay Van Vark 2003)
  14. Re: WebDNA and SQL (Jay Van Vark 2003)
  15. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  16. Re: WebDNA and SQL (Alain Russell 2003)
  17. Re: WebDNA and SQL (Clint Davis 2003)
  18. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  19. Re: WebDNA and SQL (Gary Krockover 2003)
  20. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  21. Re: WebDNA and SQL (Alain Russell 2003)
  22. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  23. Re: WebDNA and SQL (Alain Russell 2003)
  24. Re: WebDNA and SQL (Nitai @ ComputerOil 2003)
  25. Re: WebDNA and SQL (Alain Russell 2003)
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)