Home | Networks | Community | Need Help? 

 
 Quick search

 
 
 RegisterRegister   Log inLog in 

Merging database files

 
Post new topic   Reply to topic    SearchIRC Forum Index -> IRCD & Network Services
Author Message
DjMadness-
Newbie
Newbie


Joined: 10 Jan 2004
Posts: 70

PostPosted: Apr 09, 2004 9:17pm    Post subject: Merging database files Reply with quote

At this moment i am talking with an admin of an network with a userbase of ~3-400 users.
At that point it is disrespectfull to remove all databases for nicks/chans and ect.

the same with the network i am with, even though its not that many users, it is still disrespectfull.

I do not know the name of his services yet, but i beleive its either IRCservices or Epona/Anope

We run Anope our selves, and he is willing to use the software we are using.
I have heard of some kond of converter to convert IRCservices/Auspice into anope database files.
Anyone know where to get it ?

and another thing, anyone know a program for merging database files, and e.g delete whats in file2 (our database) and make sure file1 (their database) and put them in e.g file3 (the merged database) ?

I will be realy gr8full for any help i can get Wink
Back to top
Julio
Guest





PostPosted: Apr 10, 2004 1:51am    Post subject: Yes Im agree Reply with quote

One of the first point of view that I have over the last development process was this. I concentrate my job of services over the ircu 2.10.X too for the same reason. And I can stablish the ircservices 2.10.0.

I find a network for link, they have a top number of users, and me the imedia services, this is a problem central. They have icompatible database. It's one of the reason becouse some versions of ircd are without services. We need choose a adecuate ircd services diamon, a pureDragon and compile or setup on demand. And tools for format translation, why not, we have this in software of database years ago.

The best reference is the P-10 protocool, I think, of course all of us are RFC1459, but this is going to be the last RFC, I don't think so ...

JulioBell
Back to top
Sheik
none
none


Joined: 24 Jan 2004
Posts: 8

PostPosted: Nov 14, 2004 8:17pm    Post subject: Reply with quote

see http://heinz.anope.org
Back to top
Certus
none
none


Joined: 27 Apr 2004
Posts: 2

PostPosted: Jan 08, 2005 2:09pm    Post subject: Reply with quote

http://certus.anope.org/db-merger.c

I coded this merger two weeks ago. I tested nick merging with ~4000 records, bot merging with ~50 records, host merging with ~500 records and chan merging with (only) 10 records. On collision it informs you so you can choose what record to keep:

Code:
Nick collision for nick Michael:

Group 1: Michael(m.goots@gmx.fr)
Time registered: Fri Aug  6 18:41:45 2004
Group 2: M1ke(brill@gmail.com)
Time registered: Tue Nov 30 20:40:19 2004

What group do you want to keep? Enter the related group number "1" or "2".


If you open the .c file you'll find a configuration block so you can set the database names.

Compile the file by typing:
Quote:
gcc -g -o db-merger db-merger.c


After that you can use the merger by typing:
Code:
./db-merger


The following params are available:

--PREFEROLDEST [prefers the oldest records]
--PREFERNEWEST [prefers the newest records]
--PREFERFIRST [prefers the first db]
--PREFERSECOND [prefers the second db]

These params will automate the process for you so you don't have to take care of collisions.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    SearchIRC Forum Index -> IRCD & Network Services All times are GMT - 6 Hours
Page 1 of 1

 
 
Forum powered by phpBB
 
 © 2000 - 2008 EverythingIRC, Inc. All rights reserved. Please read our disclaimer