Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: anope_geoip_country vide - empty  (Read 620 times)

0 Members and 1 Guest are viewing this topic.

c-cris

  • Anope User
  • Offline Offline
  • Posts: 12
anope_geoip_country vide - empty
« 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 */
}

Logged

Lord255

  • Anope User
  • Offline Offline
  • Posts: 120
Re: anope_geoip_country vide - empty
« Reply #1 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.

?
Logged

c-cris

  • Anope User
  • Offline Offline
  • Posts: 12
Re: anope_geoip_country vide - empty
« Reply #2 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...
Logged

Lord255

  • Anope User
  • Offline Offline
  • Posts: 120
Re: anope_geoip_country vide - empty
« Reply #3 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
Logged
Pages: [1]   Go Up