This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

mysqlnews1.0 + Windrop

Help for those learning Tcl or writing their own scripts.
Post Reply
b
bleh1234
Voice
Posts: 11
Joined: Thu Mar 22, 2007 8:10 pm

mysqlnews1.0 + Windrop

Post by bleh1234 »

I have installed SQL server on WindowsXP system.
Downloaded en configured libMySQLTCL (http://www.xdobry.de/mysqltcl)
* files placed in c:\eggdrop\lib\mysqltcl\
Downloaded en configured mysqlnews1.0 from script archive
* files placed in c:\eggdrop\scripts\mysqlnews\

But there is 1 thing i'm not sure about what to fill in mysqlnews.1.0.tcl
Problem is in RED
# MySQL hostname
set db(host) "localhost"

# MySQL user
set db(id) "USER"

# MySQL password
set db(pass) "PASS"

# MySQL database
set db(dbase) "DATABASE"

# load the mysqltcl interface
load PATH/TO/libmysqltcl.so
I have placed in eggdrop.conf the following statements

Code: Select all

#needed for libMySQLTCL
loadmodule mysqltcl 

#.tcl from libMySQLTCL
source lib/mysqltcl/pkgIndex.tcl
(dunno if this is correct?)

source script /scripts/mysqlnews/mysqlnews.1.0.tcl
Before i rehash bot i would like to know if it's correct because i'm sure when i load it now it will crash!
User avatar
Sir_Fz
Revered One
Posts: 3794
Joined: Sun Apr 27, 2003 3:10 pm
Location: Lebanon
Contact:

Post by Sir_Fz »

Detect where the libmysqltcl.so file exists and replace 'path/to/libmysqltcl.so' with its full path (as it says). And the following line will cause an error:
source script /scripts/mysqlnews/mysqlnews.1.0.tcl
Instead, use:

Code: Select all

source scripts/mysqlnews/mysqlnews.1.0.tcl
(Assuming mysqlnews.1.0.tcl is in c:\eggdrop\scripts\mysqlnews\)
b
bleh1234
Voice
Posts: 11
Joined: Thu Mar 22, 2007 8:10 pm

Post by bleh1234 »

Sir_Fz wrote:Detect where the libmysqltcl.so file exists and replace 'path/to/libmysqltcl.so' with its full path (as it says). And the following line will cause an error:
source script /scripts/mysqlnews/mysqlnews.1.0.tcl
Instead, use:

Code: Select all

source scripts/mysqlnews/mysqlnews.1.0.tcl
(Assuming mysqlnews.1.0.tcl is in c:\eggdrop\scripts\mysqlnews\)
Thx for quick reply but libmysqltcl.xso isn't on system, i'm using WinXp maybe it's a unix file?

I tryed to replace .so with the dll found in libMySQLTCL package but that only gave error's same as other files

Code: Select all

[18:32] Can't load modules mysqltcl: dlopen, Win32 error 126
[18:32] Tcl error in file 'eggdrop.conf':
[18:32] couldn't load library "c:/eggdrop/lib/mysqltcl/libmysqltcl.dll": this li
brary or a dependent library could not be found in library path
    while executing
"load c:/eggdrop/lib/mysqltcl/libmysqltcl.dll"
    (file "scripts/mysqlnews/mysqlnews.1.0.tcl" line 100)
    invoked from within
"source scripts/mysqlnews/mysqlnews.1.0.tcl "
    (file "eggdrop.conf" line 1355)
[18:32] * CONFIG FILE NOT LOADED (NOT FOUND, OR ERROR)
b
bleh1234
Voice
Posts: 11
Joined: Thu Mar 22, 2007 8:10 pm

Post by bleh1234 »

No solution for this problem?

Or is it because i use windrop instead of eggdrop?

Maybe some here has a better solution for e news system script working on windrop?
n
nml375
Revered One
Posts: 2860
Joined: Fri Aug 04, 2006 2:09 pm

Post by nml375 »

Using absolute paths with wineggs is quite often troublesome (as it uses parts of teh cygwin environment to simulate an *nix environment. Unfortunately, this means drive-letters cause some problems).

I'd try "load lib/mysqltcl/libmysqltcl.dll" instead. Also, you really don't have to run the pkgIndex.tcl, as this only creates a function used for the "package"-mechanism in tcl.
NML_375
b
bleh1234
Voice
Posts: 11
Joined: Thu Mar 22, 2007 8:10 pm

Post by bleh1234 »

using absolute paths is't working

[17:07] couldn't load library "lib/mysqltcl/libmysqltcl.dll": this library or a
dependent library could not be found in library path
while executing
"load lib/mysqltcl/libmysqltcl.dll"

did many options but always same msg
n
nml375
Revered One
Posts: 2860
Joined: Fri Aug 04, 2006 2:09 pm

Post by nml375 »

Could you verify that both "libmysqltcl.dll" and "libmySQL.dll" resides within lib/mysqltcl/ directory?
You could alsy try adding this to the code prior the load-command:

Code: Select all

lappend tcl_libPath [file join [pwd] "lib" "mysqltcl"]
NML_375
Post Reply