Anope IRC Services

Denora Stats (discontinued) => Denora 1.5.x Support (Read Only) => Topic started by: peter on July 15, 2010, 04:59:45 PM

Title: Denora problem
Post by: peter 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.
Title: Re: Denora problem
Post by: Charles Kingsley on July 15, 2010, 06:48:38 PM
Which OS?
Title: Re: Denora problem
Post by: peter on July 15, 2010, 06:51:20 PM
windows vista....
Title: Re: Denora problem
Post by: Charles Kingsley on July 15, 2010, 06:51:58 PM
And you have MySQL installed? Which version?
Title: Re: Denora problem
Post by: peter on July 15, 2010, 06:52:50 PM
yes, 5.1
Title: Re: Denora problem
Post by: Charles Kingsley 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 ...
Title: Re: Denora problem
Post by: peter on July 15, 2010, 06:55:22 PM
so, i should try to make this when i am perma hosting everything on xp?
Title: Re: Denora problem
Post by: Charles Kingsley 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!
Title: Re: Denora problem
Post by: peter on July 15, 2010, 06:57:48 PM
k,

what are those sponsors?
Title: Re: Denora problem
Post by: Charles Kingsley on July 15, 2010, 07:02:51 PM
www.anope.org/sponsors.php  :)
Title: Re: Denora problem
Post by: Hal9000 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
Title: Re: Denora problem
Post by: peter on July 16, 2010, 04:06:46 PM
yes i did use the installer (reinstalled it a few time)
Title: Re: Denora problem
Post by: Hal9000 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
Title: Re: Denora problem
Post by: peter on July 18, 2010, 08:53:22 PM
this is what i get.... I guess the trojan is the problem...
http://pastebin.com/q4Ns28Mc
Title: Re: Denora problem
Post by: Jeffrey Turner 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)
Title: Re: Denora problem
Post by: peter 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
Title: Re: Denora problem
Post by: Hal9000 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.