Will I have mysqltcl (version 3 or newer) on shell account?

[Alex'a X Spirit]

I'm not a registered user at that moment so I'm asking before ordering because mysqltcl library is critical for my cgi scripts.

Will I have it?

BTW, what Tcl version are you using on FreeBSD server?

(Sorry for my terrible English)

[zoli]

hi,

tcl version is 8.4, but I haven't found any mysqltcl library (in fact never heard about) Is this some standard library that comes with mysql or tcl?

[Alex'a X Spirit]

Is this some standard library that comes with mysql or tcl?

From MySQL documentation:

"`MySQLtcl' is a simple API for accessing a MySQL database server from the Tcl programming language. It can be found at `http://www.xdobry.de/mysqltcl/'."

It even exists in FreeBSD ports collection.

[Alex'a X Spirit]

You can check if mysqltcl library is already installed by such script:

-----------------
#!/usr/local/bin/tclsh8.4

if [catch {package require mysqltcl} cause] {
puts stderr $cause
} else {
puts "* mysqltcl [package versions mysqltcl] installed"
puts "\n* mysqltcl commands list:\n[info commands ::mysql::*]"
}
-----------------

The output (if everything is fine) must be like this:

-----------------
* mysqltcl 3.01 installed

* mysqltcl commands list:
::mysql::commit ::mysql::state ::mysql::escape ::mysql::moreresult ::mysql::rollback ::mysql::autocommit ::mysql::receive ::mysql::shutdown ::mysql::setserveroption ::mysql::info ::mysql::use ::mysql::exec ::mysql::nextresult ::mysql::map ::mysql::col ::mysql::encoding ::mysql::baseinfo ::mysql::result ::mysql::seek ::mysql::insertid ::mysql::connect ::mysql::fetch ::mysql::sel ::mysql::newnull ::mysql::changeuser ::mysql::endquery ::mysql::ping ::mysql::query ::mysql::close ::mysql::isnull ::mysql::warningcount
-----------------

[DenisF]

Not related to the subject at all, but..

Location: Ukraine, Kiev

That's where i was born ^_^

Zdarov Alex

[zoli]

ok... I instaled it from ports:

# ./test
* mysqltcl 2.14 installed

* mysqltcl commands list:

please note freebsd server will be very soon upgraded to 6.0
I can imagine that dring upgrade some of the ports will not be upgraded or missed... ths is an usual behaviour of BSDs after binary upgrade.

[Alex'a X Spirit]

ok... I instaled it from ports:

You've installed a very old version of mysqltcl

Up from version 3.0 all mysql commands are declared in ::mysql namespace. That is why the test script in your case puts nothing about command names. Similar to it, my scripts cannot co-operate with version 2.14.

On freebsd ftp exits version 3.01 for all current versions of FreeBSD (4.x, 5.x, 6.0). Here are links to the packages (they required mysql-client-4.x and tcl-8.4.x):

ftp://ftp.freebsd.org/pub/FreeBSD/ports ... l-3.01.tgz

ftp://ftp.freebsd.org/pub/FreeBSD/ports ... l-3.01.tbz

ftp://ftp.freebsd.org/pub/FreeBSD/ports ... l-3.01.tbz

[Alex'a X Spirit]

Zdarov Alex

Tebe toje privet, Denis

[zoli]

hi,

This version is default in ports...
I will not put more effort to this version of FreeBSD.
Very soon it will be upgraded to 6.0 and we'll see what can we do then.