RE: [hlds_linux] MySQL Problem [AM]

[Ing. CIP Alejandro Celi Mariategui]

} -----Mensaje original-----
} De: [EMAIL PROTECTED]
} [mailto:[EMAIL PROTECTED]]En nombre de Florian
} Zschocke
} Enviado el: Martes, 11 de Junio de 2002 04:46 a.m.
} Para: [EMAIL PROTECTED]
} Asunto: Re: [hlds_linux] MySQL Problem [AM]
}
}
} "Ing. CIP Alejandro Celi Mariategui" wrote:
} >
} > I have all of my registered members in adminmod.users table in MySQL and
} > work fine when amv_private_server is set 0. All of the users
} can login and
} > his access level are 16384 (registered or not registered.
}
} [...]
}
} > When I set
} >
} > amv_private_server 1
} >
} > Nobody can log into the server, this is the debug of the server:
} [...]
} > L 06/10/2002 - 00:53:14: [ADMIN] MYSQL: Running query "SELECT
} pass,access
} > FROM adminmod.users where nick='Alex El Malo' or nick='-1'"
} > L 06/10/2002 - 00:53:14: [ADMIN] ERROR: Select query for users returned
} > disconnect, reconnect failed.
} > L 06/10/2002 - 00:53:14: [ADMIN] ERROR: Select query for users
} returned NULL
} > result.
} > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: VerifyUserAuth: User
} 'Alex El Malo'
} > did not match correct password for any entry.
}
}
} amv_private_server is known to work with mySQL servers so it
} cannot be a principal problem.
}
} Judging from the part of the log that you posted I suspect it to
} be a general problem with your mySQL server. What you see above is
} that AM cannot connect to the mySQL server. The query sent to the
} mySQL server fails.
}
} I don't know your other logs but I guess that the connection to
} the mySQL server does not work at all. You will not necessarily
} notice when amv_private_server is off. In this case it will only
} have the effect that everybody is allowed to connect. Nobody will
} ever be kicked due to using a reserved nick with the wrong
} password since AM doesn't know about any reserved nicks. It
} couldn't read any from the db table. You should notice when you
} give youself other admin rights and try to execute a protected
} command.
}
} When amv_private_server is set, the situation is a bit different.
} Now AM will allow only people in who *have* a validated entry in
} the users db table. But since it could not read the db table it
} cannot check for a valid entry and thus nobody is allowd to
} connect. I think this is what you are experiencing.
}
} Make sure that AM can connect to the mySQL server. When the server
} has started, type admin_command into the server console. That will
} cause AM to init. It will then try to establish a connection to
} the mySQL server. Check if this works or if it already produces
} errors.
}
} Florian.

Hi Florian:

I find the solution of the problem.
(The complete post in
http://www.ozforums.com/showthread.php?s=&threadid=34760 )

Resolved the problem!!!!!

Thanks to DA-YRASS on the #AdminMOD irc channel, he help me with this
problem, thanks to him for his time, and to test my server.cfg in his hlds
servers...

The solution is to move all

mysql_*

commands of server.cfg to top of the file and it work fine!!!!!

Bug or not... but it work with this solution.

Best regard,

Alex
[EMAIL PROTECTED]

_______________________________________________
To unsubscribe, edit your list preferences, or view the list archives, please visit:
http://list.valvesoftware.com/mailman/listinfo/hlds_linux