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
-
###########################################################################
# 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.
-
Which OS?
-
windows vista....
-
And you have MySQL installed? Which version?
-
yes, 5.1
-
Hm, I've never used Windows+Denora+MySQL sorry.
Suspect somewhere in there vista is causing problems ...
-
so, i should try to make this when i am perma hosting everything on xp?
-
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!
-
k,
what are those sponsors?
-
www.anope.org/sponsors.php :)
-
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
-
yes i did use the installer (reinstalled it a few time)
-
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
-
this is what i get.... I guess the trojan is the problem...
http://pastebin.com/q4Ns28Mc
-
[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)
-
inserted tables, new errors: http://pastebin.com/5GyQKtbw and this: http://pastebin.com/UswCZVWc
and this in #denora: http://pastebin.com/5AzKVKM2
-
clearly you didn't import the tables properly.
you need to import denora.sql first, then the sql file for your ircd.