Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Anope + MySQL  (Read 8366 times)

0 Members and 1 Guest are viewing this topic.

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Anope + MySQL
« on: December 23, 2011, 10:36:43 PM »
Hey all.

I'm using Anope 1.8 branch with MySQL. I import a pile of usernames and passwords from a forum database and using a web irc client it automajically logs them in and ident's to nickserv etc.

The problem I have is whenever a new user signs up, their details get inserted into MySQL, which is fine, but in order for Anope to re-read the DB it seems to require a full restart.

Is there a way to get Anope to re-read the MySQL DB without a restart, so it can see newly added users?

Thanks.
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: Anope + MySQL
« Reply #1 on: December 23, 2011, 10:39:10 PM »
1.8 can't do that without a custom module or two, 1.9 can do it though.
Logged

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Re: Anope + MySQL
« Reply #2 on: December 23, 2011, 10:40:32 PM »
Aha.

So what's different in 1.9? Does it query the DB for every ident request (amongst other things I suspect) ?
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: Anope + MySQL
« Reply #3 on: December 23, 2011, 10:41:41 PM »
Yes
Logged

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Re: Anope + MySQL
« Reply #4 on: December 23, 2011, 10:43:32 PM »
Hey Adam. Thanks. Do you happen to know if I can use the same DB for 1.8 with 1.9 - i.e. is it the same schema ?
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: Anope + MySQL
« Reply #5 on: December 23, 2011, 10:44:53 PM »
No but it is rather similar up to 1.9.6, then it changes drastically.
Logged

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Re: Anope + MySQL
« Reply #6 on: December 23, 2011, 10:48:26 PM »
Only 1.9.5 is on sourceforge, should I go with that or is 1.9.6+ in SVN or something?

s/svn/git/g
« Last Edit: December 23, 2011, 10:52:35 PM by Nathan »
Logged

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Re: Anope + MySQL
« Reply #7 on: December 23, 2011, 10:55:01 PM »
In fact, I'm thinking it's maybe best using stable and something like misc_sqlcmd.
Logged

Jan Milants

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1372
Re: Anope + MySQL
« Reply #8 on: December 23, 2011, 11:06:30 PM »
if you want to stick to 1.8, misc_sqlcmd can do simple stuff like the thing you described here...
Logged
If you like me donate coins to 1FBmZVT4J8WAUMHKqpWhgNVj3XXnRN1cCk :)

Nathan

  • Anope User
  • Offline Offline
  • Posts: 6
Re: Anope + MySQL
« Reply #9 on: December 23, 2011, 11:15:28 PM »
Excellent, thanks. I'll go play...
Logged
Pages: [1]   Go Up
« previous next »