Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Denora problem  (Read 16107 times)

0 Members and 1 Guest are viewing this topic.

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Denora problem
« on: July 15, 2010, 04:59:45 PM »

Quote
###########################################################################
# SQL [OPTIONAL]
#   Your SQL configuration for use with Denora.
#
# To make use of SQL use these tokens and change their setting to the
# appropriate values.
#       
# Please read docs/MYSQL file for more info and details.
#
# Required tokens:
#  type        - SQL server type.
#                Available options:
#                  mysql
#                NOTE: Denora supports MySQL. Future versions may support
#                other SQL technologies.
#  host        - SQL server hostname.
#  user        - SQL user to log in with.
#  passwd      - SQL pass required for the specified user to log in.
#  name        - SQL database name Denora uses
#
# Optional tokens:
#  sock        - MySQL UNIX socket
#  port        - MySQL TCP port
#  retryonlost - Attempt to reconnect sql even if we lost the server
#  retries     - Number of retry attempts
#  retrygap    - Time gap between each retry attempt
#                The product of these values must be between 1 and 60.
#  disableopt  - Use with caution, only enable this if you are having
#                problems with mysql and zlib functions
#  keepusers   - Do not truncate the users table on startup
#                Use this only in combination with the "usercache" setting!
#                Only enable this if you really need it.
#  keepservers - Do not truncate the server table on startup
#                Use this only in combination with the "servercache"
#                setting! Only enable this if you really need it.

sql {
    // required tokens
    type        mysql;
    host        localhost;
    user        anonymous;
    passwd      password;
    name        denora;

    // optional tokens
    #sock        /tmp/mysql.sock;
    #port        3306;
    #retryonlost 0;
    #retries     6;
    #retrygap    10;
    #disableopt;
    #keepusers;
    #keepservers;
};

i get this error:  You can not use this command, the SQL code is disabled.
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: Denora problem
« Reply #1 on: July 15, 2010, 06:48:38 PM »

Which OS?
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #2 on: July 15, 2010, 06:51:20 PM »

windows vista....
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: Denora problem
« Reply #3 on: July 15, 2010, 06:51:58 PM »

And you have MySQL installed? Which version?
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #4 on: July 15, 2010, 06:52:50 PM »

yes, 5.1
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: Denora problem
« Reply #5 on: July 15, 2010, 06:54:35 PM »

Hm, I've never used Windows+Denora+MySQL sorry.

Suspect somewhere in there vista is causing problems ...
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #6 on: July 15, 2010, 06:55:22 PM »

so, i should try to make this when i am perma hosting everything on xp?
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: Denora problem
« Reply #7 on: July 15, 2010, 06:56:25 PM »

Not sure, never done it before on windows with denora.

Best bet would be a nice linux shell from one of our sponsors that can hold everything you want hosted on a nice fast line / box with stuff that just works!
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #8 on: July 15, 2010, 06:57:48 PM »

k,

what are those sponsors?
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: Denora problem
« Reply #9 on: July 15, 2010, 07:02:51 PM »

Logged

Hal9000

  • Team
  • *
  • Offline Offline
  • Posts: 103
Re: Denora problem
« Reply #10 on: July 16, 2010, 04:03:05 PM »

did you use the installer? it should install the required sql library, and as long as you got an sql server running it should work fine
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #11 on: July 16, 2010, 04:06:46 PM »

yes i did use the installer (reinstalled it a few time)
Logged

Hal9000

  • Team
  • *
  • Offline Offline
  • Posts: 103
Re: Denora problem
« Reply #12 on: July 18, 2010, 11:56:12 AM »

then you better start denora with ./stats -debug -sql
and see if the log file contains any useful information as to why sql is failing
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #13 on: July 18, 2010, 08:53:22 PM »

this is what i get.... I guess the trojan is the problem...
http://pastebin.com/q4Ns28Mc
Logged

Zero

  • Anope User
  • Offline Offline
  • Gender: Male
  • Posts: 17
Re: Denora problem
« Reply #14 on: July 19, 2010, 02:36:31 AM »

Quote
[Jul 18 21:50:24.550000 2010] Denora is missing 23 required sql tables, disabling sql. Run ./mydbgen to update your sql db.

More like you don't have sql tables on your sql server. Insert these tables in and it should begin to work correctly. (Should)

On a side note: I find it easier to have phpDenora installed as well to make sure my tables are getting updated actively without doing much work then loading the phpDenora webpage for my tables. (Though that is if you use a webserver setup correctly to retrieve the sql tables)
Logged

peter

  • Anope User
  • Offline Offline
  • Posts: 23
Re: Denora problem
« Reply #15 on: July 19, 2010, 08:56:41 AM »

inserted tables, new errors: http://pastebin.com/5GyQKtbw and this: http://pastebin.com/UswCZVWc
and this in #denora: http://pastebin.com/5AzKVKM2
« Last Edit: July 19, 2010, 09:02:13 AM by peter »
Logged

Hal9000

  • Team
  • *
  • Offline Offline
  • Posts: 103
Re: Denora problem
« Reply #16 on: July 19, 2010, 09:03:08 AM »

clearly you didn't import the tables properly.
you need to import denora.sql first, then the sql file for your ircd.
Logged
Pages: [1]   Go Up