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:

Press Release hit the NewsWire!!! (1997) Why does 0 divided by 1=1? (2003) Merging databases (1997) Multiple prices (1997) [WebDNA] Was: wiki Now: Object-oriented programmng (2009) Support ?? (1997) Bug Report, maybe (1997) PCS Frames (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) WebTEN vs webSTAR (1998) autocommit problem (1998) reading a email (2000) Simple way to create unique SKU (1997) Which GUI HTML editors work with WC ? (1997) Too many tabs in order file? (1998) Help name our technology! (1997) Hidden or Forbidden? (1998) More on the email templates (1997) shownext problems (1998) WebCatalog2 for NT Beta Request (1997)