Author Topic: Roster and user IDs (Read 4889 times)

Nytridr · « **on:** May 07, 2008, 02:33:38 am »

rsbot [CORE]    [INC_GANNOUNCE] Detected org name as: Rising Sun
rsbot [GETUID]  [FAILED]        I was unable to get the user id for user: Mystic
nyts

rsbot [GETUID]  [FAILED]        I was unable to get the user id for user: Archk
rsbot [BUDDY]   [LOG]   Winterflame logged [on] (MEMBER)

Looks like roster is updating 2x during logon..

Code: [Select]

Vabot [SETTINGS]        [LOAD]  Loaded settings from database.
Vabot [ROSTER]  [UPDATE]        Starting roster update
Vabot [ROSTER]  [UPDATE]        Starting roster update

got like 100 of these or more during bot boot up during a roster update.

Code: [Select]

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) i
n C:\aobots\bebot test\Sources\MySQL.php on line 122
MySQL error (# 0) on query: Cannot connect to the database server!


Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) i
n C:\aobots\bebot test\Sources\MySQL.php on line 122
MySQL error (# 0) on query: Cannot connect to the database server!

Code: [Select]

rsbot [ROSTER]  [ERASE] Erasing Mysticnyts char_id mismatch (ID: 1988142545)
rsbot [BUDDY]   [BUDDY-DEL]     Mysticnyts
rsbot [BUDDY]   [BUDDY-DEL]     Mysticnyts
rsbot [ROSTER]  [ADD]   Adding Mysticnyts after reroll (ID: )
rsbot [Whois]   [Update]        Mysticnyts had an invalid user ID! UID:

Also added one over at http://bebot.link/bebot-0-5-support/sql-error-t1283/msg8941/#msg8941 but I think it has something to do with this one also.

One more problem I just noticed. On our relay bot the org name is being set FROM the bots that are connecting.. Not sure of the ramifications of this.

Code: [Select]

aotf [CORE] [INC_GANNOUNCE] Detected org name as: Rising SunAotf is strickly our relay bot and dose not belong to any org. One problem I have noticed is it is having problems re inviting back to the bot with out human interaction. And it is also spamming the different bots that log on or off of the relayed bot, regardless what I do about it. Actually had to go back to the old version of the relay bot for it to work right.

Ummm maybe I should rename this topic..

Here be another one captain.

Code: [Select]

MySQL error (# 0) on query: SELECT ol.nickname,ol.status_pg,ol.botname,sm.gid,sm
.name FROM online AS ol LEFT JOIN Aotf_security_members AS sm ON ol.nickname = s
m.name WHERE sm.gid = 4 AND ol.status_pg = 0 AND ol.botname = "aotf"
Table 'aotf.online' doesn't exist
aotf [SETTINGS] [LOAD]  Loaded settings from database.
aotf [ROSTER]   [UPDATE]        Starting roster update
aotf [ROSTER]   [UPDATE]        Roster update failed. Funcom XML returned 0 memb
ers.
MySQL error (# 0) on query: SELECT ol.nickname,ol.status_pg,ol.botname,sm.gid,sm
.name FROM online AS ol LEFT JOIN Aotf_security_members AS sm ON ol.nickname = s
m.name WHERE sm.gid = 4 AND ol.status_pg = 0 AND ol.botname = "aotf"
Table 'aotf.online' doesn't exist

Dose not seem to affect anything though.

ok here is another one for the !symb part of pb.php .. Seems like the !PB part works but the !symbs part of it dont, where you do the command in the following code.

Code: [Select]

rsbot [GROUP]   [MSG]   [Rising Sun] Metanyt: !symb agent eye
rsbot [GROUP]   [MSG]   [Rising Sun] Rsbot: [link]Found 8 matches[/link]
rsbot [GROUP]   [MSG]   [Rising Sun] Metanyt: !symb support ear
MySQL error (# 0) on query: SELECT * FROM symbiants WHERE slot='ear' AND (unit='
'support'') ORDER BY ql, unit
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'support'') ORDER BY ql, u
nit' at line 1
rsbot [GROUP]   [MSG]   [Rising Sun] Rsbot: No matches found for ''support'' in
'ear'

Blueeagle · « **Reply #1 on:** May 07, 2008, 05:05:29 pm »

get_uid fails in numerous occations. The reason for this is unclear but it seems that FC doesn't always return the user id when one requests it.
Added this to the bug reporting system.

Code: [Select]

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048)

Quote from: http://bugs.mysql.com/bug.php?id=6580

The mysql server intermittently fails to allow connections from clients, with no obvious
pattern to when or why connections are refused. The clients are local to the server
machine
...
the error is:
Can't connect to MySQL server on 'localhost' (10048)
...
it's the Win32 delay in releasing a port after closing it that's the problem.

As far as I can tell from google this is a bug that occurs with windows 2003 and XP. However on windows 2000 this does not occur.

This bug has been reported on many connects/disconnects however the bot should only connect to the database once and keep that connection. I cannot see why this would occur, but if this is a persisting problem we have to look into it. This bug has not been entered into our bug reporting system as it seems not to be a bug pertaining to BeBot but to MySQL/Windows.
If this problem persists long please bump this post and I will add it as a bug and we will have to check if we're doing several connects. However at this time I believe this is not the case.

As for the char-id mismatch players should not be erased when get_uid() fails. This is a bug in the bot and has been added to our bug handling system.

aotf [CORE] [INC_GANNOUNCE] Detected org name as: Rising Sun
Is this bot set as an org bot in the bot.conf-file? A relay bot should be set as a raid-bot, not an org bot. I think that should cure the problem.

The ol.nickname is pertaining to the relay module. The issue here appears at first glance to be a mis-registered table prefix. Added bug to or bug handling system.

The symbs module is in process of being re-worked and it should most likely not have been shipped with the development version. I am currently finishing this module myself and I need to write an installer to install the database tables that are not in the module. This is expected to be done before 0.6.0 is released

I think I got all of them.

I thank you for reporting these bugs, but in the future please post separate bugs in separate posts so that we can track progress of each bug individually.

Khalem · « **Reply #2 on:** May 07, 2008, 05:15:02 pm »

Quote from: Blueeagle on May 07, 2008, 05:05:29 pm

Code: [Select]
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048)
Quote from: http://bugs.mysql.com/bug.php?id=6580
The mysql server intermittently fails to allow connections from clients, with no obvious
pattern to when or why connections are refused. The clients are local to the server
machine
...
the error is:
Can't connect to MySQL server on 'localhost' (10048)
...
it's the Win32 delay in releasing a port after closing it that's the problem.
As far as I can tell from google this is a bug that occurs with windows 2003 and XP. However on windows 2000 this does not occur.

This bug has been reported on many connects/disconnects however the bot should only connect to the database once and keep that connection. I cannot see why this would occur, but if this is a persisting problem we have to look into it. This bug has not been entered into our bug reporting system as it seems not to be a bug pertaining to BeBot but to MySQL/Windows.
If this problem persists long please bump this post and I will add it as a bug and we will have to check if we're doing several connects. However at this time I believe this is not the case.

We do not use persistent connections. We did at one point, but this was changed some time ago.
We might want to add an option to allow persistent connections or default to using persistant connections on Windows to work around this MySQL bug?

It would be interesting to see if mysqli_ suffers from the same problem as the mysql_ function calls.

Blueeagle · « **Reply #3 on:** May 07, 2008, 05:21:36 pm »

Further investigation into this has led me to a similar problem occuring when using MySQL 5.1 client to connect to MySQL 5.0 servers.

Not sure if this might be the case.

And when I say we only connect once PHP re-uses the same connection if availible. This is not the same as a persistent connection but it does not open a new connection every time the bot accesses the database. It only opens a new one if the old one is invalid ie. timed out.

Nytridr · « **Reply #4 on:** May 07, 2008, 06:14:55 pm »

Quote from: Blueeagle on May 07, 2008, 05:05:29 pm

If this problem persists long please bump this post and I will add it as a bug and we will have to check if we're doing several connects. However at this time I believe this is not the case.

As for the char-id mismatch players should not be erased when get_uid() fails. This is a bug in the bot and has been added to our bug handling system.

This happens all the time and for the same people of the different bots, and on the relay bot this happens with 3 out of the 6 I have connected.

Quote

aotf [CORE] [INC_GANNOUNCE] Detected org name as: Rising Sun
Is this bot set as an org bot in the bot.conf-file? A relay bot should be set as a raid-bot, not an org bot. I think that should cure the problem.

Code: [Select]

  $guildbot = falst;                // false if its a raidbot.
  $guild_name = "";                // only if its a guildbot.
  $guild_id = 00000001;            // only if its a guildbot.

Just realized the "falst" after correcting it, it is still detecting org name. which it shouldnt be.

Nytridr · « **Reply #5 on:** May 07, 2008, 06:21:39 pm »

Quote

I thank you for reporting these bugs, but in the future please post separate bugs in separate posts so that we can track progress of each bug individually.

Sorry about that, it just sorta kept growing and growing and growing.

Blueeagle · « **Reply #6 on:** May 07, 2008, 06:34:36 pm »

Quote from: Nytridr on May 07, 2008, 06:14:55 pm

and on the relay bot this happens with 3 out of the 6 I have connected.

I am assuming you're reffering to the MySQL connect error.

As mentioned earlier this is a bug with MySQL and windows 2003/XP and most likely vista.

There might be an issue where your server is version 5.0 and the client is a higher version.

A work around for now is to delay between starting up the bots as this error appears to occur when multiple connections are made at the same time.

Alreadythere · « **Reply #7 on:** May 07, 2008, 06:39:29 pm »

Quote from: Nytridr on May 07, 2008, 06:14:55 pm

Quote
aotf [CORE] [INC_GANNOUNCE] Detected org name as: Rising Sun
Is this bot set as an org bot in the bot.conf-file? A relay bot should be set as a raid-bot, not an org bot. I think that should cure the problem.

Code: [Select]
$guildbot = falst; // false if its a raidbot. $guild_name = ""; // only if its a guildbot. $guild_id = 00000001; // only if its a guildbot.Just realized the "falst" after correcting it, it is still detecting org name. which it shouldnt be.

If aotf is in an org the bot will always detect the org name. But as long as guildbot is set to false it won't react or work as an org bot at all (I think...). If you get some output in org chat of this bot it would be best to disable org chat via the core setting, and please tell us if that's the case.

Nytridr · « **Reply #8 on:** May 07, 2008, 07:04:36 pm »

Quote from: Alreadythere on May 07, 2008, 06:39:29 pm

Quote from: Nytridr on May 07, 2008, 06:14:55 pm

Quote
aotf [CORE] [INC_GANNOUNCE] Detected org name as: Rising Sun
Is this bot set as an org bot in the bot.conf-file? A relay bot should be set as a raid-bot, not an org bot. I think that should cure the problem.

Code: [Select]
$guildbot = falst; // false if its a raidbot. $guild_name = ""; // only if its a guildbot. $guild_id = 00000001; // only if its a guildbot.Just realized the "falst" after correcting it, it is still detecting org name. which it shouldnt be.
If aotf is in an org the bot will always detect the org name. But as long as guildbot is set to false it won't react or work as an org bot at all (I think...). If you get some output in org chat of this bot it would be best to disable org chat via the core setting, and please tell us if that's the case.

this is really the only thing i am seeing..

Code: [Select]

[Rising Sun] Aotf: Rsbot logged off
[Rising Sun] Jobbii: i hate 150 BS all they doing in title grinding
[Clan shopping 100+] Vingus: WTB Intelligent Brain Symbiant, Control Unit Aban
[Rising Sun] Aotf: "Rsbot" (Lvl 1/0 Clan Trader, Squad Commander of Rising Sun) Logged On :: Details
[Rising Sun] Aotf: Rsbot logged off
[Rising Sun] Aotf: "Rsbot" (Lvl 1/0 Clan Trader, Squad Commander of Rising Sun) Logged On :: Details
[Rising Sun] Aotf: Rsbot logged off
[Rising Sun] Aotf: "Rsbot" (Lvl 1/0 Clan Trader, Squad Commander of Rising Sun) Logged On :: Details
[Rising Sun] Aotf: Rsbot1 logged off
[Rising Sun] Aotf: "Rsbot1" (Lvl 5/0 Clan Meta-Physicist, President of RS Elites) Logged On :: Details

[Raidsrus] Raidsrus: Experienced "Azmarshal" Gimp (Lvl 220/24 Clan Keeper, Veteran of Deadly

That was just me playing around with ctrl-c on the server on our org bot.. so not sure if that is what ya mean. from this it looks like aotf is actually in the org, but I know it isnt.

Alreadythere · « **Reply #9 on:** May 07, 2008, 07:17:22 pm »

The chat client is pretty sure that it is.

One possibility is that someone kicked the toon from org, but the character never was logged into AO again, only into chat. If that's the case the character won't be updated concerning org memberships on the chat server.

Nytridr · « **Reply #10 on:** May 07, 2008, 07:31:28 pm »

By golly ge gorage, that worked. I just logged aotf on and ran her through ao and logged her off.. and I am not getting the org detect part anymore..

Date: 2007-07-07 Level: 6 AI: 0 Clan Not in guild
Date: 2007-07-05 Level: 6 AI: 0 Clan Rising Sun (AoF) (Unit Member)

and I am not getting unknown userid with it anymore.. I am with my other bots but not this one.. I wounder if maybe just logging them on for a min or 2 and back off with the client may help.

so the only problems I have left is

Code: [Select]

MySQL error (# 0) on query: SELECT ol.nickname,ol.status_pg,ol.botname,sm.gid,sm
.name FROM online AS ol LEFT JOIN Aotf_security_members AS sm ON ol.nickname = s
m.name WHERE sm.gid = 4 AND ol.status_pg = 0 AND ol.botname = "aotf"
Table 'aotf.online' doesn't exist

Which blueeagle has already address, and the !symbs one, which I think is only a misplaced ' or something, since I imported the correct db.
and the userid thing with the other org bots.

other then those I think we are good.. I will keep poking around see if I can find more..:)p

Blueeagle · « **Reply #11 on:** May 07, 2008, 08:31:06 pm »

From the mysql command line interface please do the following

Code: [Select]

USE <databasename>;
SHOW TABLES;

That should list the tables in the database. You'll ofcourse have to exchange <databasename> to the name of the database as defined in conf/MySQL.conf.

This will help determine if the table "online" does in fact exist.

Nytridr · « **Reply #12 on:** May 07, 2008, 09:12:38 pm »

Quote from: Blueeagle on May 07, 2008, 08:31:06 pm

From the mysql command line interface please do the following
Code: [Select]
USE <databasename>; SHOW TABLES;
That should list the tables in the database. You'll ofcourse have to exchange <databasename> to the name of the database as defined in conf/MySQL.conf.

This will help determine if the table "online" does in fact exist.

Code: [Select]

Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use aotf;
Database changed
mysql> show tables
    ->
    -> ;
+------------------------+
| Tables_in_aotf         |
+------------------------+
| access_control_saves   |
| alts                   |
| aotf_access_control    |
| aotf_automsgs          |
| aotf_banks             |
| aotf_blacklist         |
| aotf_color_schemes     |
| aotf_donations         |
| aotf_links             |
| aotf_log_message       |
| aotf_logon             |
| aotf_logon_notifies    |
| aotf_mail_message      |
| aotf_meeting           |
| aotf_news              |
| aotf_online            |
| aotf_org_city          |
| aotf_orgbank_backpack  |
| aotf_orgbank_item      |
| aotf_orgbank_toon      |
| aotf_preferences       |
| aotf_preferences_def   |
| aotf_raid_points       |
| aotf_security_flexible |
| aotf_security_groups   |
| aotf_security_members  |
| aotf_security_org      |
| aotf_settings          |
| aotf_statistics        |
| aotf_string_filter     |
| aotf_tablenames        |
| aotf_timer             |
| aotf_tower_attack      |
| aotf_tower_result      |
| aotf_users             |
| aotf_welcome_msgs      |
| colors                 |
| command_alias          |
| land_control_zones     |
| orgs2                  |
| player_notes           |
| shortcuts              |
| timer_class_entries    |
| timer_classes          |
| whois                  |
+------------------------+
45 rows in set (0.02 sec)

mysql>

Nytridr · « **Reply #13 on:** May 07, 2008, 09:28:24 pm »

I droped the aotf_tablenames and it seems to of fixed it, even after I changed it back to using Aotf and true

spoke to soon.. umm

Ok if I change the "online" to use Aotf and true, when I restart it I get those errors, if I put it back to blank and false then it works right.

at least thats something.. I can leave it like that, but its defently a bug.

Blueeagle · « **Reply #14 on:** May 07, 2008, 10:30:23 pm »

If the table has first been created you need to drop both *_tablename and the table for it to be recreated properly. It's not enough to change the code to true and then drop the original table as that won't update the *_tablename table.

Also this is not something that's meant to be done as the bot should share the online table.

Author Topic: Roster and user IDs (Read 4889 times)

Nytridr

Roster and user IDs

Blueeagle

Re: Roster and user IDs

Khalem

Re: Roster and user IDs

Blueeagle

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Blueeagle

Re: Roster and user IDs

Alreadythere

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Alreadythere

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Blueeagle

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Nytridr

Re: Roster and user IDs

Blueeagle

Re: Roster and user IDs