Anope IRC Services

International Support => French => Topic started by: c-cris on March 13, 2022, 02:25:53 PM

Title: anope_geoip_country vide - empty
Post by: c-cris on March 13, 2022, 02:25:53 PM
Bonjour,

Comme l'inique le titre, j'ai la table anope_geoip_country qui reste vide donc les informations ne sont pas transmise. J'utilise MagIRC et du coté Pays j'ai donc que inconnue.
Pourtant les services anope voient bien a la connexion des utilisateurs :/

Une petite idée ?

Translate :
Hello,

As the title suggests, I have the anope_geoip_country table which remains empty so the information is not transmitted. I use MagIRC and on the Country side I therefore have only unknown.
Yet the anope services see the connection of users :/

A small idea?

irc2sql.conf

Code: [Select]
/*
 * IRC2SQL
 */
 
module
{
name = "irc2sql"
/* Ceci doit être configuré avec un module SQL actif */
engine ="mysql/main"
prefix = "anope_"
/*Active GeoIP */
geoip_database = "country"
client = "StatServ"
ctcpuser = "yes"
ctcpeob = "yes"
}
 
service
{
nick = "StatServ"
user = "StatServ"
host = "Services.network"
gecos = "Statistical Service"
#modes = "+o"
channels = "@#Services" /* Le service joindra ces salons */
}

Title: Re: anope_geoip_country vide - empty
Post by: Lord255 on March 13, 2022, 02:35:51 PM
hello.
did you load the geoip database as the conf asks you to do?

Code: [Select]
         
         * .. you have to run the
* geoipupdate script after you started Anope to download
* and import the GeoIP database.

?
Title: Re: anope_geoip_country vide - empty
Post by: c-cris on March 13, 2022, 03:16:43 PM
Yes, but I have another problem.:/

Code: [Select]
Downloading...
   Country Database:      Done
Unpacking...
unzip:  cannot find or open GeoIPCountryCSV.zip, GeoIPCountryCSV.zip.zip or GeoIPCountryCSV.zip.ZIP.
rm: cannot remove 'GeoIPCountryCSV.zip': No such file or directory
Converting to UTF-8...
iconv: cannot open input file `GeoIPCountryWhois.csv': No such file or directory
rm: cannot remove 'GeoIPCountryWhois.csv': No such file or directory
Importing...
mysqlimport: [Warning] Using a password on the command line interface can be insecure.
mysqlimport: Error: 3948, Loading local data is disabled; this must be enabled on both the client and server sides, when using table: anope_geoip_country
rm: cannot remove 'anope_geoip_country.csv': No such file or directory
rm: cannot remove 'anope_geoip_country6.csv': No such file or directory
Done...
Title: Re: anope_geoip_country vide - empty
Post by: Lord255 on March 13, 2022, 03:45:12 PM
Yes, but I have another problem.:/

Code: [Select]
Downloading...
   Country Database:      Done
Unpacking...
unzip:  cannot find or open GeoIPCountryCSV.zip, GeoIPCountryCSV.zip.zip or GeoIPCountryCSV.zip.ZIP.
rm: cannot remove 'GeoIPCountryCSV.zip': No such file or directory
Converting to UTF-8...
iconv: cannot open input file `GeoIPCountryWhois.csv': No such file or directory
rm: cannot remove 'GeoIPCountryWhois.csv': No such file or directory
Importing...
mysqlimport: [Warning] Using a password on the command line interface can be insecure.
mysqlimport: Error: 3948, Loading local data is disabled; this must be enabled on both the client and server sides, when using table: anope_geoip_country
rm: cannot remove 'anope_geoip_country.csv': No such file or directory
rm: cannot remove 'anope_geoip_country6.csv': No such file or directory
Done...

yea. it needs some modification. :)
i think you should try crazycat's scripts. :)
https://forum.anope.org/index.php?topic=4577.msg23441#msg23441