[extender1987]

18:18:26] [zcmd] [Vladik Pitckofski]: /b and?
[18:18:33] [part] TeeJay_Brown has left the server (15:0)
[18:18:33] [part] Albert_Shadow has left the server (5:0)
[18:18:33] [part] Bil_Cobra has left the server (6:0)
[18:18:33] Aron Chupa (1) saving their 541 (slot 0) (Model 541)...
[18:18:33] [part] Aron_Chupa has left the server (1:0)
[18:18:36] [part] Jan_McAdam has left the server (14:0)
[18:18:36] [part] Tony_Steels has left the server (2:0)
[18:18:36] Anthony Accardo (4) saving their 424 (slot 3 (Model 424)...
[18:18:36] [part] Anthony_Accardo has left the server (4:0)
[18:18:36] [part] Vladik_Pitckofski has left the server (9:0)
[18:18:36] Marina Cobra (10) saving their 560 (slot 0) (Model 560)...
[18:18:36] [part] Marina_Cobra has left the server (10:0)
[18:18:36] [part] Roland_Tren has left the server (16:0)
[18:18:36] [part] Frank_Richman has left the server (12:0)
[18:18:36] [part] Jimmy_Tren has left the server (8:0)
[18:18:36] [part] Dash_Berlin has left the server (17:0)
[18:18:37] [part] Pablo_Snoop has left the server (11:0)
[18:18:37] Thomas Lewis (13) saving their 402 (slot 24) (Model 402)...
[18:18:38] [connection] 84.94.60.49:50641 requests connection cookie.
[18:18:38] [part] Thomas_Lewis has left the server (13:0)
[18:18:39] [part] Jensen_Ackles has left the server (0:0)
[18:18:41] [part] Pierce has left the server (7:0)
[18:18:50] [connection] 93.173.253.236:62501 requests connection cookie.
[18:18:51] [MySQL] Query Error - (ErrorID: 2013) (Handle: 1)
[18:18:51] [MySQL] Check mysql_log.txt to review the query that threw the error.
[18:18:51] Dumping query from 2015/6/2 (18:18:51)

Description: Lost connection to MySQL server during query (index 0). Query:


[18:18:51] UPDATE `accounts` SET `SPos_x` = '1457.05', `SPos_y` = '-1761.26', `SPos_z` = '3285.28', `SPos_r` = '149.33' WHERE id = '9461'
[18:18:51] [MySQL] Connection Error Detected in Threaded Query
[18:18:53] [connection] 62.162.183.59:2746 requests connection cookie.
[18:19:00] [connection] 93.173.253.236:62502 requests connection cookie.
[18:19:12] [MySQL] Query Error - (ErrorID: 2003) (Handle: 1)
[18:19:12] [MySQL] Check mysql_log.txt to review the query that threw the error.
[18:19:12] Dumping query from 2015/6/2 (18:19:12)

Description: Can't connect to MySQL server on '94.23.60.117' (10060) (index 0). Query:


[18:19:12] UPDATE `accounts` SET `IP`='95.187.247.131',`Registered`=1,`ConnectedTim e`=0,`Sex`=1,`BirthDate`='1990-03-09',`Band`=0,`PermBand`=0,`Warnings`=0,`Disabled`= 0,`Level`=3,`AdminLevel`=0,`SeniorModerator`=0,`He lper`=0,`DJ`=0,`DonateRank`=3,`Respect`=0,`XP`=0,` Money`=500000,`Bank`=500000,`pHealth`='100.00',`pA rmor`='100.00',`pSHealth`='0.00',`Int`=0,`VirtualW orld`=0,`Model`=71,`BanAppealer`=0,`PR`=0,`HR`=0,` AP`=1,`Security`=0,`ShopTech`=0,`FactionModerator` =0,`GangModerator`=0,`Undercover`=0,`TogReports`=0 ,`Radio`=0,`RadioFreq`=0,`UpgradePoints`=0,`Origin `=0,`Muted`=0,`Crimes`=0,`Accent`=1,`CHits`=0,`FHi ts`=0,`Arrested`=0,`Phonebook`=0,`LottoNr`=0,`Fish es`=0,`BiggestFish`=0,`Job`=0,`Job2`=0,`Paycheck`= 3682,`HeadValue`=0,`JailTime`=0,`WRestricted`=0,`M aterials`=0,`Crates`=0,`Pot`=0,`Crack`=0,`Nation`= 0,`Leader`=-1,`Member`=0,`Division`=-1,`FMember`=255,`Rank`=0,`DetSkill`=0,`SexSkill`=0 ,`BoxSkill`=0,`LawSkill`=0,`MechSkill`=0,`TruckSki ll`=0,`DrugsSkill`=0,`ArmsSkill`=0,`SmugglerSkill` =0,`FishSkill`=0,`CheckCash`=0
[18:19:12] ,`Checks`=0,`BoatLic`=0,`FlyLic`=0,`GunLic`=1,`Fis hLic`=1,`FishSkill`=0,`FightingStyle`=0,`PhoneNr`= 0,`Apartment`=-1,`Apartment2`=-1,`Renting`=-1,`CarLic`=1,`DrugsTime`=0,`LawyerTime`=0,`LawyerF reeTime`=0,`MechTime`=0,`SexTime`=0,`PayDay`=1855, `PayDayHad`=0,`CDPlayer`=0,`Dice`=0,`Spraycan`=0,` Rope`=0,`Cigars`=0,`Mask`=0,`Bombs`=0,`Wins`=0,`Gu n0`=0,`Gun1`=3,`Gun2`=24,`Gun3`=0,`Gun4`=29,`Gun5` =0,`Gun6`=0,`Gun7`=0,`Gun8`=0,`Gun9`=0,`Gun10`=0,` Gun11`=0,`Loses`=0,`Tutorial`=1,`OnDuty`=1,`Hospit al`=0,`MarriedID`=-1,`ContractBy`='',`ContractDetail`='',`WantedLevel `=0,`Insurance`=0,`911Muted`=0,`NewMuted`=0,`NewMu tedTotal`=0,`AdMuted`=0,`AdMutedTotal`=0,`HelpMute `=0,`ReportMuted`=0,`ReportMutedTotal`=0,`ReportMu tedTime`=0,`DMRMuted`=0,`VIPMuted`=0,`VIPMutedTime `=0,`GiftTime`=0,`AdvisorDutyHours`=0,`AcceptedHel p`=0,`AcceptReport`=0 WHERE `id`=9461
[18:19:21] [connection] 62.162.183.59:2751 requests connection cookie.
[18:19:26] Incoming connection: 46.120.217.214:50559 id: 0
[18:19:33] [MySQL] Query Error - (ErrorID: 2003) (Handle: 1)
[18:19:33] [MySQL] Check mysql_log.txt to review the query that threw the error.
[18:19:33] Dumping query from 2015/6/2 (18:19:33)

Description: Can't connect to MySQL server on '94.23.60.117' (10060) (index 0). Query:


[18:19:33] UPDATE `accounts` SET `TrashReport`=0,`GangWarn`=0,`CSFBanned`=0,`VIPInv iteDay`=0,`TempVIP`=0,`BuddyInvite`=0,`Tokens`=0,` PTokens`=0,`TriageTime`=0,`PrisonedBy`='Nobody',`P risonReason`='None',`TaxiLicense`=0,`TicketTime`=0 ,`Screwdriver`=0,`Smslog`=0,`Speedo`=0,`Wristwatch `=0,`Surveillance`=0,`Tire`=0,`Firstaid`=0,`Rccam` =0,`Receiver`=0,`GPS`=0,`Sweep`=0,`SweepLeft`=0,`B ugged`=-1,`pWExists`=0,`pWSeeds`=0,`Warrants`='',`JudgeJai lTime`=0,`JudgeJailType`=0,`BeingSentenced`=0,`Pro bationTime`=0,`DMKills`=0,`OrderConfirmed`=0,`Free zeHouse`=0,`FreezeCar`=0,`Firework`=0,`Boombox`=0, `Hydration`=100,`DoubleEXP`=0,`EXPToken`=0,`RacePl ayerLaps`=0,`Ringtone`=0,`Order`=0,`CallsAccepted` =0,`PatientsDelivered`=0,`LiveBanned`=0,`FreezeBan k`=0,`VIPM`=1238,`VIPMO`=0,`VIPExpire`=1433529931, `GVip`=1,`Watchdog`=0,`VIPSold`=0,`GoldBoxTokens`= 0,`DrawChance`=0,`RewardHours`='0.00',`CarsRestric ted`=0,`LastCarWarning`=0,`CarWarns`=0,`Flagged`=0 ,`Paper`=0,`MailEnabled`=1,`Mailbox`=0,`Business`=-1,`BusinessRank`=-1,`TreasureSkill`=0,`Met
[18:19:33] alDetector`=0,`HelpedBefore`=0,`Trickortreat`=0,`L astCharmReceived`=0,`RHMutes`=0,`RHMuteTime`=0,`Gi ftCode`=0,`Table`=0,`OpiumSeeds`=0,`RawOpium`=0,`H eroin`=0,`Syringe`=0,`Skins`=0,`Hunger`=92,`Hunger Timer`=59,`HungerDeathTimer`=0,`Fitness`=0,`Health Care`=0,`ReceivedCredits`=0,`RimMod`=0,`Tazer`=0,` Cuff`=0,`CarVoucher`=0,`ReferredBy`='Nobody',`Pend ingRefReward`=0,`Refers`=0,`Famed`=0,`FamedMuted`= 0,`DefendTime`=0,`PVIPVoucher`=0,`VehicleSlot`=0,` ToySlot`=0,`RFLTeam`=-1,`RFLTeamL`=-1,`VehVoucher`=0,`SVIPVoucher`=0,`GVIPVoucher`=0,` GiftVoucher`=0,`FallIntoFun`=0,`HungerVoucher`=0,` BoughtCure`=0,`Vials`=0,`AdvertVoucher`=0,`ShopCou nter`=0,`ShopNotice`=0,`SVIPExVoucher`=0,`GVIPExVo ucher`=0,`VIPSellable`=0,`ReceivedPrize`=0,`AdminS trikes`=0,`StaffBanned`=0 WHERE id=9461

[SoFahim]

Please Do not Post Double about same problem . Please Don't Spam . Another post is this https://sampforum.blast.hk/showthread.php?tid=576290 . Please be a good person

[Phaze]

It's clearly a MYSQL problem: Description: Can't connect to MySQL server on '94.23.60.117' (10060) (index 0). Query:

Please do more research on DDoS which are network attacks.

[Sergei]

Please start saving values in database when they actually change. You are not using ini.

[Konverse]

Quote:

Originally Posted by extender1987 [18:19:33] [MySQL] Query Error - (ErrorID: 2003) (Handle: 1) [18:19:33] [MySQL] Check mysql_log.txt to review the query that threw the error.

Nice mate that's not a DDOS attack, just a MyQSL problem.

[Vince]

Also do not connect to your MySQL server through the external IP. That would be like knocking on your own front door every time you wanted to get something out of the fridge.

[Sithis]

Quote:

Originally Posted by Vince Also do not connect to your MySQL server through the external IP. That would be like knocking on your own front door every time you wanted to get something out of the fridge.

My development server does the same. Performance wise there's no difference.

[Phaze]

Quote:

Originally Posted by Sithis My development server does the same. Performance wise there's no difference.

Just use localhost, you should never host the MYSQL database on another box than the game server.

[SimplyFragHosting]

Hello,

Our mysql servers respond to users with "%" flags meaning that it needs to access it externally in order to connect. The issue was he was trying to login with root/wrong password.

Kind Regards

Jack Fletcher
SimplyFrag.co.uk