wolsne
Account Details
SteamID64 76561198012377422
SteamID3 [U:1:52111694]
SteamID32 STEAM_0:0:26055847
Country Mongolia
Signed Up July 10, 2016
Last Posted December 16, 2018 at 7:28 PM
Posts 806 (0.9 per day)
Game Settings
In-game Sensitivity
Windows Sensitivity
Raw Input  
DPI
 
Resolution
 
Refresh Rate
 
Hardware Peripherals
Mouse  
Keyboard  
Mousepad  
Headphones  
Monitor  
1 2 3 4 ⋅⋅ 54
#6 arteezy stream in Other Games

mangobay 40 hr version

posted 5 hours ago
#12 SWOLETOWN lfp IM in Recruitment (looking for players)

jeff very good

posted 1 week ago
#7 Ascent.EU S31 Frag Movie in Videos

I thought drack's beard was supposed to be green?

Show Content
real talk though great work, and the stream was enjoyable too
posted 1 week ago
#9 SQL Database Connections w/Sourcemod & DigitalOcea in Q/A Help

Thanks to everyone for the help. I have established a database connection through my tf2 server now, the issue was having my mysql user account set to 'user'@'localhost' instead of @'%' and I feel like a bit of a fool. What is a safe way to establish remote connections through mysql? Do I just bind access for specific IP's/services I want connected?

posted 1 week ago
#4 XBS lft in Recruitment (looking for team)

better than me tbh

posted 1 week ago
#7 SQL Database Connections w/Sourcemod & DigitalOcea in Q/A Help

Here are my logs files from /var/log/mysql/

mysql_error.log

error.log

Nothing too interesting from what I can gather, the IP's that I removed from error.log are not from services that I recognize the IP from, and not from the TF2 server I am trying to establish the database connection from. However, I did see that there is an issue setting up SSL with an attached library error.

[Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

I'm not sure if this is enough to prevent a remote connection, but I feel like I'm grasping at straws.I am running https on my server with LetsEncrypt, something that I didn't mention in my OP.

posted 1 week ago
#6 SQL Database Connections w/Sourcemod & DigitalOcea in Q/A Help
ArieIf everything runs on the same machine, please do not set the bind-address to 0.0.0.0.

Do you get an error in sourcemod? Have you checked the sourcemod logs, have you checked the mysqld logs?

This is the sourcemod error I recieve:

L 12/04/2018 - 19:26:11: [sql-admin-manager.smx] Could not connect to database: [1045]: Unknown error 1045
[SM] Could not connect to the database.

This error is complaining about not being able to establish a database connection using the provided user/pass combination, but I have verified it multiple times, and used it to log directly into mysql seperately.

The sourcemod logs don't give me many clues, I'll include a pastebin dump:
Sourcemod log file

I understand that having your mysql bind address to 0.0.0.0 is pretty insecure and I do have it set to such atm while I attempt to reduce as many hindrances as possible to get this functional. I haven't checked the mysqld logs but I will not and update my post shortly.

Edit:

I followed this guide to set up logging files for mysql as I suppose they aren't enabled by default. I'll test a bit and see if I can have some generated.

posted 1 week ago
#3 SQL Database Connections w/Sourcemod & DigitalOcea in Q/A Help

Thanks for the quick reply Thermite, I believe I've gone through these steps as recommended by a stack overflow thread but I'll give it another shot in a bit. If anyone else has other suggestions feel free to keep the coming.

posted 1 week ago
#1 SQL Database Connections w/Sourcemod & DigitalOcea in Q/A Help

I know there's definitely some smarter people who browse these forums and I'm hoping someone might be able to assist me with my issue.

I'm currently running a digital ocean droplet with ubuntu 16.04 running a simple LAMP stack and hosting my mumble server on it. I've got a functional installation of MySQL and phpMyAdmin for database management. Accessing the database locally on the server via SSH gives me no problems, nor does directly editing database schema via phpMyAdmin, however when I supply the database user information for sourcemod in databases.cfg, my server can not make a connection regardless of my efforts. I'm essentially wanting to have support for more robust admin management using the sql-threaded plugin which is loading properly as well as the sql-admin-manager plugin.

On the droplet, I also have firewall rules to support I/O traffic on default mysql port, ssh, http/https, and mumble default port.

posted 1 week ago
#18 Team Name Vote for S30 in TF2 General Discussion

"We Fold on First Loss"

posted 1 week ago
#58 somethings up with grape juice in Off Topic

Tuesday, December 4, 2018

[1:54 AM]
grapejuiceIII:
Imagine reading a post, but over the course of it the quality seems to deteriorate and it gets wose an wose, where the swenetence stwucture and gwammer rewerts to a pwoint of uttew non swence, an u jus dont wanna wead it anymwore (o´ω`o) awd twa wol owdewl iws jus awfwul (´・ω・`);. bwt tw powost iwswnwt obwer nyet, it gwos own an own an own an own. uwu wanyaa stwop weadwing bwut uwu cwant stop wewding, uwu stwartd thwis awnd ur gwoing two fwinibsh it nowo mwattew wat! uwu hab mwoxie kwiddowo, bwut uwu wibl gwib ub sowon. i cwan wite wike dis fwor owors, swo dwont cwalengbe mii..

… wbats dis??? uwu awe stwill weedinb mwie powost?? uwu habe awot ob detewemwinyanyatiom!! 。◕‿◕。! u habve comopweedid tha pwost, good job!

[1:54 AM]
wolsne:
please stop

[1:54 AM]
grapejuiceIII:
nuuu >.<

[1:54 AM]
wolsne:
im reporting you to the police

posted 1 week ago
#7650 stream highlights in Videos

https://clips.twitch.tv/ModernCulturedLettuceFrankerZ
https://clips.twitch.tv/CrazyWrongOwlShadyLulu

posted 1 week ago
#73 ban insom from pugchamp in TF2 General Discussion

hate 2 see it rocket

posted 1 week ago
#16 LFP s30 open in Recruitment (looking for players)

yari is very chill and you should have an awesome time playing with this gamer + talking about keyboards

posted 1 week ago
#7592 stream highlights in Videos

https://clips.twitch.tv/TenuousNimbleDonutCeilingCat

posted 2 weeks ago
1 2 3 4 ⋅⋅ 54