Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Updated to 1.7.15 - Mysql  (Read 5156 times)

0 Members and 1 Guest are viewing this topic.

Dags400

  • Guest
Updated to 1.7.15 - Mysql
« on: September 04, 2006, 04:48:55 AM »
I have configured the mysql part of the config file and also uncommented the bits in tables.sql.

Also tried the command /operserv set sql on
it says "unknown option sql"

Its on win32.. and i have not selected socket.
what would i use for that?

Question is how to get services to use mysql?

Is there a command or something i need to do?

Or is there something else i need to do?

Any help would be apreachiated

[Edited on 4-9-2006 by Dags400]

[Edited on 4-9-2006 by Dags400]
Logged

Dags400

  • Guest
(No subject)
« Reply #1 on: September 04, 2006, 06:06:22 AM »
Ok i managed to sort out the mysql unknown prob another problem has cropped up though..

I have created the database file, just that when i enable SQL on anope it doesn't create any tables.

How do you create tables for Anope?

Thanks in advance
Logged

Jan Milants

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1372
(No subject)
« Reply #2 on: September 04, 2006, 11:58:41 AM »
the following comes literally from the anope docs... ( /docs/MYSQL )

Quote
   1. Go to your "services bin directory" (eg: /home/someuser/services/) and run mydbgen
       to help on the schema creation and adjustments.
Logged
If you like me donate coins to 1FBmZVT4J8WAUMHKqpWhgNVj3XXnRN1cCk :)

heinz

  • Guest
(No subject)
« Reply #3 on: September 04, 2006, 02:05:34 PM »
You probably can't run mydbgen under windows, unless you have some nice funkeh shell-script-to-cscript converter.. so you'll need to type this in a command prompt window:

mysql --user=your_mysql_username --pass your_mysql_db_name < "c:\program files\anope\data\tables.sql"
Logged

Jan Milants

  • Team
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 1372
(No subject)
« Reply #4 on: September 04, 2006, 06:20:07 PM »
oh sorry i must have missed the windows part...
Logged
If you like me donate coins to 1FBmZVT4J8WAUMHKqpWhgNVj3XXnRN1cCk :)

Dags400

  • Guest
(No subject)
« Reply #5 on: September 05, 2006, 07:57:41 PM »
Thanks guys.. Don't worry Viper :)
Logged

Dags400

  • Guest
(No subject)
« Reply #6 on: September 05, 2006, 07:58:35 PM »
i'm guessing create the table manually.. I am total novice
Logged

Dags400

  • Guest
(No subject)
« Reply #7 on: September 05, 2006, 08:05:45 PM »
Nope sorted that one as well.. um still that line on the config

mysqlsock..

What to set that to on windows.
Logged
Pages: [1]   Go Up
« previous next »