egghelp/eggheads community

MySQL instead of Eggdrops userfile?

2007-03-08T13:40:43-04:00

Currently, the user database is very much integrated in the core application, making it impossible to switch the non-volatile datastorage without extensive patching of the core.
That said, what can currently be done with scripts or modules, is to export a copy of the userfile into xml-data, mysqldump-data, or whatever flavor you desire. Performing this would be quite simple. This however, will not allow you to modify the user database from "outside" your eggdrop (that is, you'd still have to rely on eggdrops user database API in order to alter the database in any way).

The outlines for a script to export the database would be something like this, I suppose:

Code:

proc exportdatabase {stream} { foreach u [userlist -b] {  #hosts, laston, info, xtra, comment, email, url, handle, pass  puts $stream "user: $u"  puts $stream "hosts: [getuser $u hosts]"  puts $stream "laston: [getuser $u laston"  #and so on... } foreach u [userlist +b] {  #botfl, botaddr,hosts, laston, info, xtra, comment, email, url, handle, pass  #same for bots, except they have two additional fields }}

The above proc will expect an already opened file-stream (from either open or socket), and will probably require some tailoring to suit individual needs

Statistics: Posted by nml375 — Thu Mar 08, 2007 1:40 pm

MySQL instead of Eggdrops userfile?

2007-03-08T12:54:17-04:00

I this is a really old post but Its exactly what I am looking for - does anyone know of a script / module to make this happen?

Cheers

Statistics: Posted by whittinghamj — Thu Mar 08, 2007 12:54 pm

MySQL instead of Eggdrops userfile?

2006-12-14T13:41:27-04:00

it would definitely make editing the userfile by hand easier, at least for novices (have you tried XML Notepad?)

but I actually meant another, more important advantage - now that people are used to mySQL db's storing and manipulating all kinds of webpage data, import/export & process eggdrop userfile in XML format would be possible with one-liner tools without any need of special SQL interface in eggdrop

and yes, it is an antiquated software - or to put it mildly, it isn't exactly what you call the bleeding edge of software development or at least a modern day software (my understanding is that there are some developments in integrating modern era technologies - 1.9 branch? - but given the pace of eggheads, we won't be seeing those released in stable builds anytime soon - if ever)

Statistics: Posted by demond — Thu Dec 14, 2006 1:41 pm

MySQL instead of Eggdrops userfile?

2006-12-14T13:17:40-04:00

Using xml might make it easier to alter the user database by hand. But you'd still have the issue of the userfile only being read once, and written every hour or so (making manually editing the userfile pretty pointless in most cases). In the rare occasion you'd have to repair your database manually, I'd probably think current format would be easier to fix by hand than xml. I'm sure there are a few good reasons to edit the database using various xml-tools, tho I'd considder those extremely rare (during my years since 1.0p and numerous botnets, I can count the number of times I've had to edit a userfile by hand on the fingers of my right hand...)

And since the data in the userfile always should be considdered old while your eggie is running, there really would'nt be much point in using any external tools to extract data while the eggie is running...

And as for mysql, I'm not too keen on having to install a mysqld and setting up databases and accounts with proper privileges, just in order to run an eggie.

Oh, and should I someday find a huge need to be able to modify my userlist from a fancy webpage with all the bells and whistles.. I'd just write a tiny script using sockets to allow my php-script to interface with my eggie under controlled conditions...

Statistics: Posted by nml375 — Thu Dec 14, 2006 1:17 pm

MySQL instead of Eggdrops userfile?

2006-12-14T11:05:29-04:00

using SQL is an overkill for the simple task of reading userfile ONCE (on (re)start) and writing it back ONCE an hour

another matter is that the proprietary text format eggdrop uses should be replaced with XML schema, thus allowing for easy userfile manipulation by external tools; but eggdrop is an antiquated piece of software anyway and that won't happen

What do you mean about 'eggdrop is an antiquated piece of software'? Is there something better.

Even xml is better than usual textfile.

Statistics: Posted by innu — Thu Dec 14, 2006 11:05 am

MySQL instead of Eggdrops userfile?

2006-12-14T00:53:24-04:00

using SQL is an overkill for the simple task of reading userfile ONCE (on (re)start) and writing it back ONCE an hour

another matter is that the proprietary text format eggdrop uses should be replaced with XML schema, thus allowing for easy userfile manipulation by external tools; but eggdrop is an antiquated piece of software anyway and that won't happen

Statistics: Posted by demond — Thu Dec 14, 2006 12:53 am

MySQL instead of Eggdrops userfile?

2006-12-13T18:14:57-04:00

Im currently making such a modification at the moment using TCL to overwrite the main proc's and to use a mysql module for the mysql crap. I might make it in C as a proper eggdrop module. I will finish it and release it for testing soon.

Any new information?

Statistics: Posted by innu — Wed Dec 13, 2006 6:14 pm

MySQL instead of Eggdrops userfile?

2006-11-12T20:54:32-04:00

Im currently making such a modification at the moment using TCL to overwrite the main proc's and to use a mysql module for the mysql crap. I might make it in C as a proper eggdrop module. I will finish it and release it for testing soon.

Statistics: Posted by r0t3n — Sun Nov 12, 2006 8:54 pm

MySQL instead of Eggdrops userfile?

2006-11-12T13:07:15-04:00

Skirmis: Did you release this modification for the public, is it available?

Statistics: Posted by rosc2112 — Sun Nov 12, 2006 1:07 pm

Re: MySQL instead of Eggdrops userfile?

2006-11-12T09:14:06-04:00

Hello,
Could anyone tell me if there are some solutions available what would enable to use mySQL database instead of Eggdrops userfile? I mean that eggdrop gets everything concerding the users from a mySQL database and saves everything there too + the old userfile system would be no longer used.
I would appreciate any information concerning this problem

Hello, I did that.

Everything is in the Mysql DB:
- Users, passwords, extra info
- Bots CFG files
- Login sessions managment
- Permisions managment ( global and local channel )
- Bans managment
- Various statistics ( chan top10, seen, join/parts etc. )
- Gather managment and statistic
- Channel managment
- New Bot creation and configuration via WEB
- Login via WEB
- Etc.

Mysql does'nt slow down the bot. Now are runing about 45 bots that shares the same Mysql DB and about 1000 registered users. Bots does about 1 milinion queries per day and about 10/s. In future in think to do that some information will be in memory and after a while everything is saved into Mysql DB to save CPU power. Now Server CPU is used at 1-3% ( XP Athlon 1900+ ). Sorry for my bad english language.

SkIRmis

Statistics: Posted by SkIRmiS — Sun Nov 12, 2006 9:14 am

MySQL instead of Eggdrops userfile?

2006-11-10T18:38:37-04:00

IMHO mysql is universal, easy access for every other program too besides eggdrop + everything is organized in tables.

Being that the userfile is a text format, it's not that hard to create parsers for it. Personally, I found learning sql *painful* and thankfully I do not remember a single thing about it anymore (it was a job that required me to learn it ;/ )

Statistics: Posted by rosc2112 — Fri Nov 10, 2006 6:38 pm

I think...

2006-11-10T14:24:29-04:00

I think textfile is better and simple more than SQL database coz it's have minimum risky!

Statistics: Posted by ZEXEL — Fri Nov 10, 2006 2:24 pm

MySQL instead of Eggdrops userfile?

2006-11-10T13:11:34-04:00

SQL and ODBC might be universal.
Even so, many sql-engines have different features and extensions, not always 100% compatible with eachother. And to be honest, do I really want other programs tampering with my user database? Probably not..

Abit off-topic there I guess, so lets get back on topic:
First of all, I would'nt wanna bug admins to install an sql (mysql or any other) server just in order for me to run an eggie.
Next there's the immense queries you'd risk ending up with on even an average populated channel.. Whenever any user-permissions are checked, you'd be required to send queries (which would include, but not be limited to, any binding supporting flags, etc)

You could always manually dump the userlist data into a sql-database every 5minutes or so I guess, assuming that you do not intend to use sql-queries to alter data. Should'nt be too hard to accomplish with either a commandline client (such as mysqlclient), or some extensions such as libmytcl (or something like that, should be able to find a few threads on compiling such with eggies on the forum)

Statistics: Posted by nml375 — Fri Nov 10, 2006 1:11 pm

MySQL instead of Eggdrops userfile?

2006-11-10T11:03:34-04:00

IMHO mysql is universal, easy access for every other program too besides eggdrop + everything is organized in tables.

Statistics: Posted by kmail — Fri Nov 10, 2006 11:03 am

MySQL instead of Eggdrops userfile?

2006-11-09T19:29:19-04:00

What's so bad about using the existing method (textfile format)?

Statistics: Posted by rosc2112 — Thu Nov 09, 2006 7:29 pm