egghelp.org community Forum Index
[ egghelp.org home | forum home ]
egghelp.org community
Discussion of eggdrop bots, shell accounts and tcl scripts.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

mysqlnews1.0 + Windrop

 
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help
View previous topic :: View next topic  
Author Message
bleh1234
Voice


Joined: 22 Mar 2007
Posts: 11

PostPosted: Mon Mar 26, 2007 9:38 am    Post subject: mysqlnews1.0 + Windrop Reply with quote

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

Quote:
# 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:
#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!
Back to top
View user's profile Send private message
Sir_Fz
Revered One


Joined: 27 Apr 2003
Posts: 3793
Location: Lebanon

PostPosted: Mon Mar 26, 2007 10:29 am    Post subject: Reply with quote

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:
Quote:
source script /scripts/mysqlnews/mysqlnews.1.0.tcl

Instead, use:
Code:
source scripts/mysqlnews/mysqlnews.1.0.tcl

(Assuming mysqlnews.1.0.tcl is in c:\eggdrop\scripts\mysqlnews\)
_________________
Follow me on GitHub

- Opposing

Public Tcl scripts
Back to top
View user's profile Send private message Visit poster's website
bleh1234
Voice


Joined: 22 Mar 2007
Posts: 11

PostPosted: Mon Mar 26, 2007 12:38 pm    Post subject: Reply with quote

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:
Quote:
source script /scripts/mysqlnews/mysqlnews.1.0.tcl

Instead, use:
Code:
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:
[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)
Back to top
View user's profile Send private message
bleh1234
Voice


Joined: 22 Mar 2007
Posts: 11

PostPosted: Mon Apr 09, 2007 5:44 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
nml375
Revered One


Joined: 04 Aug 2006
Posts: 2857

PostPosted: Mon Apr 09, 2007 8:00 am    Post subject: Reply with quote

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, idling at #eggdrop@IrcNET
Back to top
View user's profile Send private message
bleh1234
Voice


Joined: 22 Mar 2007
Posts: 11

PostPosted: Sun Apr 15, 2007 11:11 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
nml375
Revered One


Joined: 04 Aug 2006
Posts: 2857

PostPosted: Sun Apr 15, 2007 11:36 am    Post subject: Reply with quote

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:
lappend tcl_libPath [file join [pwd] "lib" "mysqltcl"]

_________________
NML_375, idling at #eggdrop@IrcNET
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Forum hosting provided by Reverse.net

Powered by phpBB © 2001, 2005 phpBB Group
subGreen style by ktauber