I find with help of a user on the irc. the solution was put all
mysql_* In the top of server.cfg and work fine. Here is the solution: http://www.ozforums.com/showthread.php?s=&threadid=34760 Best Regards, Alex Celi [EMAIL PROTECTED] } -----Mensaje original----- } De: [EMAIL PROTECTED] } [mailto:[EMAIL PROTECTED]]En nombre de Tiscali } B�rge Amundsen } Enviado el: Martes, 11 de Junio de 2002 03:33 a.m. } Para: [EMAIL PROTECTED] } Asunto: Re: [hlds_linux] AM - MySQL Problem } } } I have the exact same problem ... } } Ing. CIP Alejandro Celi Mariategui wrote: } } > Hi, } > } > I have a problem with Adminmod MySQL version. } > } > 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. } > } > I have a RedHat Linux 7.2 dedicated server. } > } > I use this config in server.cfg } > } > ============================================================== } > mysql_host "192.168.100.124" (DB is on another server) } > mysql_user "adminmod" } > mysql_pass "xxxxx" } > mysql_dbtable_users "adminmod.users" } > } > mysql_users_sql "SELECT pass,access FROM %s where nick='%s' or } nick='%i'" } > mysql_preload 0 } > } > amv_private_server 0 } > amv_prvt_kick_message "Register in games.viaperu.com to play on } this server" } > amv_reconnect_time 60 } > ============================================================== } > } > 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:06: World triggered "Round_Start" } > L 06/10/2002 - 00:53:14: "Alex El Malo<2><4294967295><>" } connected, address } > "200.37.85.90:27005" } > L 06/10/2002 - 00:53:14: [ADMIN] AM_ClientUserInfoChanged: Alex El Malo } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: Storing password 'x1x2x3x4'. } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: Client password buffer cleared. } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: Server knows pw '' now } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: SetUserPassword: User } 'Alex El Malo' } > entered password 'x1x2x3x4'. } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: mySQL tags table is not set. } > 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. } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: mySQL tags table is not set. } > 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: convert_string: string: } Alex El Malo } > L 06/10/2002 - 00:53:14: [ADMIN] DEBUG: convert_string: string: } > } > Can you help me? } > } > Best regards } > } > Alex Celi } > [EMAIL PROTECTED] } > } > _______________________________________________ } > To unsubscribe, edit your list preferences, or view the list } archives, please visit: } > http://list.valvesoftware.com/mailman/listinfo/hlds_linux } > } > } } } -- } Vennlig hilsen / Best regards } B�rge Amundsen } } _______________________________________________ } To unsubscribe, edit your list preferences, or view the list } archives, please visit: } http://list.valvesoftware.com/mailman/listinfo/hlds_linux _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds_linux
