_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 7/1/2019 6:45:32 PM | System.Exception: Failed to connect to server over three times in a row. Server may be down. Please try again later. ---> MySql.Data.MySqlClient.MySqlException: Authentication to host 'cityofplayers.com' for user 'wbenn_user' using method 'mysql_native_password' failed with message: User wbenn_user already has more than 'max_user_connections' active connections ---> MySql.Data.MySqlClient.MySqlException: User wbenn_user already has more than 'max_user_connections' active connections I see ppl are jealous of my work done :) Yes, this is an awesome error to have. I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 This is from the Other folder, again...multiple times: 7/1/2019 9:44:30 PM | System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at CoH_Forums_Parser.Program.FindUsersInThread(Int32 threadID, String content) in C:\Projects\CoH Forums Parser\CoH Forums Parser\Program.cs:line 412 at CoH_Forums_Parser.Program.AddThread(String URL, Nullable`1 date, StringBuilder content) in C:\Projects\CoH Forums Parser\CoH Forums Parser\Program.cs:line 398 at CoH_Forums_Parser.Program.ProcessContent(String URL, Nullable`1 date, StringBuilder content) in C:\Projects\CoH Forums Parser\CoH Forums Parser\Program.cs:line 280 at CoH_Forums_Parser.Program.Main(String[] args) in C:\Projects\CoH Forums Parser\CoH Forums Parser\Program.cs:line 182 I just released a fix for this. It looks like there's some "junk" in some of the memberIDs stored, standard internet junk. I'm now splitting that memberID by newlines and taking the first actual number that I can parse, which seems correct because the junk has all been alphanumeric rather than numeric. This one requires an updated Parser, please get it from the OP. I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 So, about that Error folder...it's putting some of the WARCs in there. Are they supposed to be or can we get rid of them? I'm at like 2Gb worth in the one folder alone. Also, What's everybody's folder down to? I'm at 608Gb left. Feel free to move those back into your main directory if you've grabbed the newest copy of the Parser. I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 And... my internet got wiped out due to an electrical storm. I may not be able to do any more code updates today, because while I can use my Cell Phone as a hotspot at home, I'm not going to leave it at home to keep my connection working while I'm at work to remote in... so I won't be alot of help until tonight.... I'm out. Link to comment Share on other sites More sharing options...
Healix Posted July 2, 2019 Share Posted July 2, 2019 Awww, PK...so sorry that happened to you! *grabs nearest lightning bolt, ties in a knot, stomps on it, places in an empty air-tight mayonnaise jar, throws in dumpster* Forever grateful to be back in my city! Link to comment Share on other sites More sharing options...
justicebeliever Posted July 2, 2019 Share Posted July 2, 2019 Awww, PK...so sorry that happened to you! *grabs nearest lightning bolt, ties in a knot, stomps on it, places in an empty air-tight mayonnaise jar, throws in dumpster* PK - I appreciate all the hard work you and the team are doing here (+1 Inf for PK, Zep, Red, Aries) Healix - you are going to really freak out the folks at the dump when that jars shatters. Either that or some poor guy goings to be killed by thugs, tossed in the dumpster, and wake up with lightning powers. Edit: +1 to Amatyr as well. "The opposite of a fact is falsehood, but the opposite of one profound truth may very well be another profound truth." - Niels Bohr Global Handle: @JusticeBeliever ... Home servers on Live: Guardian ... Playing on: Everlasting Link to comment Share on other sites More sharing options...
Symbolis Posted July 2, 2019 Share Posted July 2, 2019 Have the parser up and running, now. Yay! Attached my error log thus far. Hope it's useful! Errors.log Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 I'm talking with my host now about the timeout errors. I'm out. Link to comment Share on other sites More sharing options...
Zep Posted July 2, 2019 Share Posted July 2, 2019 I'm talking with my host now about the timeout errors. I have a 4 day weekend coming up. If it doesnt cost you anything to increase capacity I'll get 200+ copies going before bed and watch it during the day -- can load up my i7 laptop too and we can get this done :) ** Asus TUF x670E Gaming, Ryzen 7950x, AIO Corsair H150i Elite, TridentZ 192GB DDR5 6400, Sapphire 7900XTX, 48" 4K Samsung 3d & 56" 4k UHD, NVME Sabrent Rocket 2TB, MP600 Pro 8tb, MP700 2 TB. HDD Seagate 12TB ** ** Corsair Voyager a1600 ** Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 It would cost to increase capacity. Alot. They said to give it some time and see if things clear up. If it doesn't after a bit, I'm supposed to try to change the nameserver in the connectionString to the IP address instead to remove another layer of abstraction. I'm doubtful... I got a funny feeling they're starting to throttle me to get me to pay for a higher level package... I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 Anyone knows a good web host that provides: ASP.NET MySQL Databases > 200GB in size Isn't super expensive? (hoping for $50 a month or less I can't seem to find all of these things. Either my search-fu is weak, or such a thing doesn't exist. I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 Have the parser up and running, now. Yay! Attached my error log thus far. Hope it's useful! And you're on the board Symbolis, thanks for your contribution! I'm out. Link to comment Share on other sites More sharing options...
Symbolis Posted July 2, 2019 Share Posted July 2, 2019 #CrushingIt :D Link to comment Share on other sites More sharing options...
Oubliette_Red Posted July 2, 2019 Share Posted July 2, 2019 Anyone knows a good web host that provides: ASP.NET MySQL Databases > 200GB in size Isn't super expensive? (hoping for $50 a month or less I can't seem to find all of these things. Either my search-fu is weak, or such a thing doesn't exist. I am not a search guru when it comes to servers, since I've never needed the use of one. The only thing I've been able find so far that came close is https://www.tier.net/infrastructure Dislike certain sounds? Silence/Modify specific sounds. Looking for modified whole powerset sfx? Check out Michiyo's modder or Solerverse's thread. Got a punny character? You should share it. Link to comment Share on other sites More sharing options...
Zep Posted July 2, 2019 Share Posted July 2, 2019 Anyone knows a good web host that provides: ASP.NET MySQL Databases > 200GB in size Isn't super expensive? (hoping for $50 a month or less I can't seem to find all of these things. Either my search-fu is weak, or such a thing doesn't exist. Question: Please understand the last time I did a lot of coding networking meant a 2400 baud modem. Could you make an agent program that reports what all parsers do on a single machine? This would change us from how many total parsers are supported to how many total users. Of course, I am guessing that coding multiple programs to talk to each other could be annoying.... could all the parsing leave text files that a master program reads, sends, and deletes? Of course I am not doing the work and it is not like this is going to take forever as is. Thank you again for all the work you do on this - as is is fine, just some random thoughts. ** Asus TUF x670E Gaming, Ryzen 7950x, AIO Corsair H150i Elite, TridentZ 192GB DDR5 6400, Sapphire 7900XTX, 48" 4K Samsung 3d & 56" 4k UHD, NVME Sabrent Rocket 2TB, MP600 Pro 8tb, MP700 2 TB. HDD Seagate 12TB ** ** Corsair Voyager a1600 ** Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 That's not really feasible. Actually, the text parsing itself is pretty quick. It's the checks to the database, making sure the data doesn't already exist, and then creating the data that takes most of the time. And that can't really be improved by any way that I can think of in a modular way. I'm out. Link to comment Share on other sites More sharing options...
Oubliette_Red Posted July 2, 2019 Share Posted July 2, 2019 I'm getting the server timeout error now, whether I parse a single file or multiples. Errors.log Dislike certain sounds? Silence/Modify specific sounds. Looking for modified whole powerset sfx? Check out Michiyo's modder or Solerverse's thread. Got a punny character? You should share it. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 Yeah, I might just have to bite the bullet and pay for a dedicated server... I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 Okay, so I've tested and ruled out the clients and their communication. The stored procedures and methods that I've created to get the job done are now failing ON THE SERVER. I think that this database has gotten bigger than their hardware can support. Or at least the hardware that they've given me permission to use. At this point, I'm considering just hosting my own server... hmmmm... I do have a spare PC... but then it'd rely on my internet connection, which wouldn't necessarily be always up... what do you all think? I'm out. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 I've officially stopped all of your parsers from looping again by artificially raising the version number to a non-existent number until I get this figured out. No point in y'all wasting time and resources trying to get something working that won't. It looks like we've grown bigger than my current host at their current price range. I'm out. Link to comment Share on other sites More sharing options...
Oubliette_Red Posted July 2, 2019 Share Posted July 2, 2019 GoFundMe? I'm currently seeking employment, but I could chip in a few inf for the duration. Dislike certain sounds? Silence/Modify specific sounds. Looking for modified whole powerset sfx? Check out Michiyo's modder or Solerverse's thread. Got a punny character? You should share it. Link to comment Share on other sites More sharing options...
_NOPE_ Posted July 2, 2019 Author Share Posted July 2, 2019 Hmm... I'm looking hard at Patreon, it seems GoFundMe is kind of designed for a one time thing, and it'd be nice if I could get the community to help pay for a long-term server... I'm out. Link to comment Share on other sites More sharing options...
WanderingAries Posted July 2, 2019 Share Posted July 2, 2019 It looks like we've grown bigger than my current host at their current price range. Yeah...I'm pretty good at taxing people/things. O:) :p OG Server: Pinnacle <||> Current Primary Server: Torchbearer || Also found on the others if desired Installing CoX: Windows || MacOS || MacOS for M1 <||> Migrating Data from an Older Installation Clubs: Mid's Hero Designer || PC Builders || HC Wiki || Jerk Hackers Old Forums <||> Titan Network <||> Heroica! (by @Shenanigunner) Link to comment Share on other sites More sharing options...
justicebeliever Posted July 2, 2019 Share Posted July 2, 2019 Hmm... I'm looking hard at Patreon, it seems GoFundMe is kind of designed for a one time thing, and it'd be nice if I could get the community to help pay for a long-term server... Well...you are a big part of the HC community...everyone who has helped with this is part of HC...even HC mods/devs are helping out...Can we pitch a case to HC to have them host the forums and include the overhead in their monthly goals? A.) They have a scalable hosting model B.) Funding can be consolidated C.) It doesn't increase their legal exposure...and if it's a static forum tool, the support would be minimal and supplied by yourself... Thoughts? I mean it's HC's call, but since we are supporting them, I feel we have a voice... "The opposite of a fact is falsehood, but the opposite of one profound truth may very well be another profound truth." - Niels Bohr Global Handle: @JusticeBeliever ... Home servers on Live: Guardian ... Playing on: Everlasting Link to comment Share on other sites More sharing options...
Oubliette_Red Posted July 3, 2019 Share Posted July 3, 2019 Hmm... I'm looking hard at Patreon, it seems GoFundMe is kind of designed for a one time thing, and it'd be nice if I could get the community to help pay for a long-term server... Well...you are a big part of the HC community...everyone who has helped with this is part of HC...even HC mods/devs are helping out...Can we pitch a case to HC to have them host the forums and include the overhead in their monthly goals? A.) They have a scalable hosting model B.) Funding can be consolidated C.) It doesn't increase their legal exposure...and if it's a static forum tool, the support would be minimal and supplied by yourself... Thoughts? I mean it's HC's call, but since we are supporting them, I feel we have a voice... As I've always said "If you don't ask, then the answer is no." Dislike certain sounds? Silence/Modify specific sounds. Looking for modified whole powerset sfx? Check out Michiyo's modder or Solerverse's thread. Got a punny character? You should share it. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now