« first day (1361 days earlier)      last day (3665 days later) » 

12:00 AM
actually
 
Alright, let me install that
 
if you know the credentials, you can have mysql workbench connect to the server directly
you'd have to give those creds to phpadmin, too
 
I'm the site owner, of course I have the credentials :D
 
ah, good
 
The workbench was scary
 
12:01 AM
it is, it is also terrible, terrible software
but better than phpmyadmin
 
Okay then, shall I just use that then?
 
i like it better, but you may prefer phpmyadmin
there's nothing wrong with it...just the web interface grosses me out
 
Okay, so I need to connect to the server
 
but if you are using workbench, you hit the new conenction button
whereever that resides in the UI these days
 
I found it, yeah
Let me connect
 
12:05 AM
well, once you get that connected, there's a new schema button somewhere
otherwise, if you have a CREATE script, you can just run it
good, the troll's gone
 
Fuuu
It's not cooperating
 
?
sure you got the creds? :)
 
Failed to Connect to MYSQL at -----
yEAH
 
does your server allow non-localhost connections?
sometimes that's a thing
 
wait
Okay, let me just try PHPmyadmin
 
12:08 AM
word, good luck
 
@SethBattin Holy jesus, why is this so complicated docs.phpmyadmin.net/en/latest/setup.html#installing-on-windows
 
:)
get hosting with shell access
seriously
ftp doesn't cut it
 
It's not worth ittt
I don't want to go get another host
 
It definitely is.
 
For a tiny project like this, not really
 
12:13 AM
well
 
I'd go with HeidiSQL over phpmyadmin on windows
 
oh shit, are you working on a windows server?
 
@hasherr Is the purpose of these tiny projects not to make you a more awesome developer?
His server is likely linux because it's cheap. His OS is Windows
 
yeah, we're trying to migrate his local db to a server now
 
Instead of installing phpmyadmin, and having to manage the installation for all that it is
 
12:15 AM
It's a test project for another larger project
 
He should be able to just use heidi to get into the remote instance
 
we tried a mysqlworkbench connection, no go
can only speculate about why without being able to see the server's workings
 
Big fat error with that workbench
Installing Heidi now
 
Who's your host #er?
 
Some shitty free one, 000webhost
 
12:16 AM
:(
 
i mean, i have shittyhosting.com, too
 
You have cpanel
 
but it lets me install a db
 
cpanel has phpmyadmin
login to cpanel, use it's phpmyadmin
 
oh, nice
 
12:16 AM
Cpanel?
Are you talking to me?
 
Yes
 
i mean...not very nice, but better than nothing
 
An alternate way is to upload the .sql exported from your local database
and then create a really simple php script to run the file
 
mmm
brazen
 
Then promptly delete it
 
12:18 AM
I'm on my cpanel
Okay
 
you'll gain +5 php cowboy points, though
 
I assume I should navigate to the mysql
 
Oh man, I remember fantastico
Ahhh the old days
Yep
Has Cpanel not upgraded significantly in the last 10 years?
Looks just like I remember it
 
it's the same old piece of shit as ever
 
Uhh
Okay, so I created a MySQL database from cpanel
I don't think I should've done that
 
12:20 AM
why not?
 
Import your tables into it
 
lol, aren't I uploading a database?
Not creating one?
 
it's not really uploading
 
You have to create a new one with cpanel :\
Shell Access >>>
 
a SQL script is just a bunch of commands to enter into a db program
 
12:21 AM
Cpanel heavily segments actual access so that the overall shared host isn't compromised
 
you upload a script, but you still have to execute it
 
So PHPmyadmin is probably not going to allow you user access to make a new DB.
 
he said he succeeded at making one
 
Yeah
I was just explaining why he had to do it the way that he did, that he doesn't think is right
 
Right, so I have one, and my host gave me a bunch of credentials
 
12:23 AM
Yep
 
ah, gotcha
 
So those credentials would let you log in with a remote panel probably
as well as the phpmyadmin on your cpanel
 
cries
 
You couldn't remote in before because you didn't have shell access to the mysql server
 
Remote panel?
 
12:23 AM
But now you have a user
 
So basically PHPMyAdmin or the Workbench
 
Like Heidi or the workbench
yep
 
Okay
 
you don't need shell access to use mysqlworkbench's connections
you can to a straight tcp connection
if your server allows it
 
But he needs a username and password for the db to do it doesn't he?
 
12:24 AM
which we can't determine...because no shell access
right, but that's different
he's got that
 
Not with cpanel he didn't
He had a username and password for the account
 
oh, i see what's going wrong
my mistake
you are surely right, Noctrine
 
Okay, didn't work >.<
 
the username and password for the database?
Did you make sure to use the prefix?
 
I tried setting up a new connection on the workbench
 
12:27 AM
It'd be like
 
Put in hostname and username
Left out port, not sure what to use for that
 
blahblahblah_name
 
And got an error
 
What error?
 
@Noctrine yeah that was it
Let me reproduce it
 
12:27 AM
leave the port at the default
 
Failed to connect to mysql at (host_name) with user blablabla_name
 
Your hostname is not your url
 
i suspect your server does not allow external connections
 
@Noctrine No, it's a modified version of the url
 
Could also be that though
 
12:29 AM
@SethBattin The site is pretty exclamatory on the fact that it hosts mysql stuff
 
well, hosting a db and allowing arbitrary access to it are different
 
Doesn't mean it allows external connections
 
like, php will be accessing it locally
 
My production servers are only set up to allow a connection locally
Or though a specific static ip
 
so apache gets the requests, runs php, php talks to the db
OR, if allowed, you can make a request directly to mysql
but i don't think you are allowed
 
12:30 AM
Lol, that probably won't happen
 
:| you should have just got the AWS micro instance :(
 
What is that?
 
not a bad idea
amazon web services
 
^ What I'm thinking of doing
 
instant virtual server
 
12:30 AM
:( i sent it to you last time when you were looking for hosts
 
I need a web hosting solution for my blog
 
Are they still doing the free year?
Yup, seems like it.
 
@VaughanHilts I just use tumblr for my blog
Although I'm thinking of changing to github pages
 
I rolled a WordPress install
I looked at Tumblr, too.
 
12:31 AM
Okay, hold on
We still haven't tried Heidi
 
It's likely not gonna work
Get AWS free tier :D
 
holy crap, i must be missing something in the small print about aws
 
Then we can give you direct specific help without having to work around a crippled host
 
He'll need his parents to fork up a CC number
 
Ahhh
man :\
 
12:32 AM
@SethBattin If you go over, you get nailed for fees.
 
Being a kid sucks
 
ah, of course
 
If you stay under, you're in the clear
I know a couple companies here that use free tiers to prototype prod servers
 
What is a CC number? I can likely get it on my own
 
Credit Card number
 
12:33 AM
one of my coworkers created a script to dump his aws usage fees to a cvs and automatically import them into a google chart on a web page hosted on the aws
 
You can't... legally. :)
 
it was comical
 
I have a card I can use.
 
@hasherr My ultimate recommendation - is to pay the 5/month on a digital ocean droplet
 
I own a VPS right now from ChicagoVPS
 
12:33 AM
dreamhost, also good
 
2GB RAM, shared usage, 2TB in/out
30 bucks annual
 
@Noctrine I'm not paying 5/month for a service that I'm only using for the weekend
 
.007 cent an hour
 
It's not exactly super fast, but it works.
 
is it really just the weekend? aws is totally the way to go, then
 
12:34 AM
I set up an AWS service the other day, does that help?
And I have my own card
 
Then yeah, just use the free tier
 
They give credit cards to children now?
I really missed the boat on that one.
 
i had one when i was 14
 
@VaughanHilts It's a debit card, but it'll work the same
 
only needed a checking account
 
12:35 AM
Oh, those.
A lot of companies will reject those
 
My parents got it for me when I turned 16 as a subtle hint that they wanted me to get a job
 
mine was real
 
@VaughanHilts Amazon doesn't.
 
We have those here, too but some places reject them. Good to know Amazon does not, though.
 
Yeah, you can get a real credit card as early as 16 I think?
 
12:36 AM
It's 18 here
(Canada)
 
I got mine at 17 when I was going into college
 
I believe so, Noc
And I most likely will when I turn 17
 
That's because a minor can't enter a legal binding agreement
Or it's null and void
 
ha
yeah, my limit was 500$
 
You went to college at 17?
 
12:37 AM
@VaughanHilts Here minors can go into contracts, they just have the ability to break them.
 
I went to university when I was 17
Is that so weird?
 
nope
 
More unlikely than 'weird'
 
@Noctrine You can do that here, too but nobody in the right mind would... since a minor can plead anullment at any time.
 
The credit card companies fight extra hard to sign up students at school :\ - I wonder if they have some special protection
 
12:38 AM
Actually.. I started university when I was 16, going on 17.
 
Or really, I guess, they can just damage your credit and write you off. Student limits are usually very low.
 
Okay, so if I enter my cc, how do I make sure it doesn't charge me?
 
They must, I guess... I have one at any rate.
 
@hasherr Don't go over the free limits
 
Check your statement monthly.
If it states a charge, you probably fucked up.
 
12:38 AM
There are all kinds of panels and tools you can use to monitor usage
 
But it's free for a year, and then it'll charge me at the end?
 
It was a year, is it forever now?
 
Just destroy the instance after that
It's a year
 
@VaughanHilts It's still a year
 
12:39 AM
Hopefully in a year you'll be making all the paper off of malware tycoon
 
So, I bought a PS4 today.
Hopefully it's not a brick >_>
 
Alright, AWS is up for me
Oh, Amazon, you're so nice
 
They're not being nice. They're hoping you slip up :'D
 
lel
I hope they know I'm significantly better at computers than a normal 16 year old, so that isn't likely.
But anything can happen.
 
Make sure you set up usage and billing alerts
They are expecting you to be worse than an army of sysadmins or opsdevs
 
12:43 AM
@hasherr Your typical sixteen year old isn't really their demographic..
 
That's very true haha
 
General tips for continued cheapness
 
One easy way to lose is get yourself DDOS'd
 
1. Don't post links to your site on reddit, /., hackernews, etc
 
Watch your bandwidth poof
 
12:44 AM
lol
 
2. Set up analytics, and rate limiting. DDOS attacks are trivial these days
 
Jeez, I wish you guys would've warned me about this stuff before I made it
 
Anyone with a facebook account, or google docs could engineer a DDOS in no time.
 
or charles proxy
select request, select repeat count
 
Or Low Orbit Ion Cannon :)
 
12:45 AM
Alright, well, let's get back to the real issue: databases
 
 
hey look at that, something about a game!
 
@Grey What's that
 
@Grey What am I looking at
 
Isn't hasherr doing all this for a game?
 
12:45 AM
:|
 
@Noctrine No, it's some web app
 
:\
 
Web Service**
 
haha noo
 
Craft Studio Map :o
 
12:46 AM
Noc still doesn't know about project UltraRad
 
Only interested in Malware tycoon >>
 
Or about Project Falcon XXXX
 
1 min ago, by Noctrine
@Grey What's that
Seemed pretty interested in that
:P
 
I'll just go file a patent for malware tycoon..
 
:p
 
12:47 AM
d:p
 
I stopped asking after I found out it wasn't malware tycoon
 
lol
 
What if I told you....
 
Malware Tycoon is on hold for me, currently
 
It's malware tycoon
 
12:47 AM
That's why I asked, "Whats that" instead of "Is that malware tycoon"
 
Project UltraRad is mas importante
 
co men-na sai
@noctrine
 
Okay, enough chitter-chatter, databases
 
co men-na sai?
 
No malware tycoon, no databases.
 
12:48 AM
Japanese I think for "Please forgive me"
 
Pip, Grey, and hasherr all have projects that seem to be priority over MT
 
:(
 
gomen-na sai
 
Do something radical and hip like CouchDB or RavenDB
 
good god
 
12:48 AM
I TOLD HIM VAUGHAN he wouldn't listen
 
@SpartanDonut Students get busy too, you know.
 
(That was sarcasm.)
 
(I'm jamming)
I got 3 hours of sleep
 
you ain't busy
 
@hasherr This was an optional project last I checked
Hehe, highschool busy
 
12:49 AM
u tryin ta tell us that not paying bills an feeding off our parents is not busy?
 
Had such high hopes for GD Minor League :(
 
yeah, seriously, highschool is the easiest you'll ever have it
 
University is much worse. :)
 
Might be optional, but would you turn it down?
 
I was gonna give you guys a real version of that logo I sent
 
12:49 AM
Hopes shattered
 
I can't project past university, but
 
@Noctrine omg
WAIT
 
Man, I wish I could go back to HS. I used to do soooo much coding
 
@VaughanHilts I never said we're as busy/busier than you guys.
 
12:49 AM
@hasherr Yes, yes I did.
 
@hasherr LOOK
 
I was measurably worse. But...
 
what you should do is impregnate someone
 
My Grade 12 Calculus teacher tried to bribe me into making an android app for him
 
Haha I coded too much my grades suffered from it :<
 
12:50 AM
then you'll have all the free time in the world
 
I nope'd out of that one quickly.
 
@VaughanHilts And you didn't?
 
"Can I use your class to do it? And you just give me an A"
 
Nope.
That's exactly what he said Noctrine lmao
@Noctrine *
 
@SethBattin I'd rather shoot myself than tell my parents I got a girl pregnant
 
12:50 AM
I would have taken that offer sooooo quickly.
 
it's not your parents that you would need to worry about
 
Malware tycoon screenshots and you get that logo :p
 
Since I was always practicing for ECOO (the programming contest local to here) in his class all the time.
So I was like... nah, I don't free labour heh
 
@SethBattin Rest of my life, yeah
 
And then there's expecations, trust and infidelity.. yuck.
 
12:51 AM
@Noctrine okokokk
 
That, or...
Well, this is off-topic
 
@hasherr we need that logo
 
a bit :)
 
Nopefuckit.jpg
Too busy
 
Son.
 
12:52 AM
DON'T CALL ME SON
I AM OLD ENOUGH TO BE YOUR FATHER
 
nah
 
John went from zero stars to 14. I'm going to have to remember that trick.
 
Hmmm, I should probably get to making things.
 
Same, but then grey and vaughan joined and crushed everyone's hopes and dreams
 
12:53 AM
@Noctrine Share the motivation, I just literally finished all my exams 3 hours ago :)
 
Somehow, people are doing all the other things on the projects that I'm working on on time. So I'm starting to get backlogged :(
I'd show some stuff, but I feel self-conscious, cause it's not good enough yet
 
It can't be worse than my joke of an A-Start implementation I did yesterday for the first time.
O(N) searches everywhere
 
@SethBattin Okay, so I've got AWS set up, now what's so good about it and how is it going to help me get my database on the webservice
 
@hasherr It's a virtual computer you can control
 
i don't know, never used it before :)
 
12:56 AM
So... it can do anything you want it to do :)
 
That sentence didn't even make sense...
 
@Noctrine, help hasherr
 
So out of the three choices:
 1. Relationship graph for visual novel fighting thingie I've been working on.
 2. Character art for visual novel fighting thingie I've been working on.
 3. New website I've been working on.
 
Leave Noctrine to his things, Vaughan is plenty
 
What sounds most interesting
 
12:56 AM
Step 1: Pick desired database technology
 
^^
 
MYSQL
 
@Noctrine Can you expand on #1?
 
Install mysql
 
relationship graph
 
12:57 AM
@Noctrine 2
 
@Noctrine DONE
 
Nice
Now, connect to mysql via ssh
 
I'm a sucker for VNs
So.. 1 or 2
 
ah, yeah, now that you have a real server, ssh to it
 
Step 3: Setup a web server to proxy through
 
12:58 AM
or set up a connection in workbench via ssh
 
Step 4: Upload code
 
cries
I don't know anything you guys are saying
 
Neither did we once upon a time. :)
 
so, you can log in to your new server
 
Download Putty
 
12:58 AM
do do that via ssh
NO
no putty
 
I use it and I'm ok
 
use gitbash if you have to
 
WHAT'S WRONG WITH PUTTY.
 
but fuck putty
 
gitbash?
 
12:58 AM
Have I been doing it wrong??
 
yeah, gitbash has enough mingwn in it
 
Oooh
 
*uses putty for telnet and ssh"
 
Yeahhh
 
WHAT THE HELL IS PUTTY
 
WHAT
 
Oh, as an alternative shell
 
Calm d0wn
 
Fancy features
 
Don't ask questions, go to the places that we send you to and read.
Then ask questions.
 
12:59 AM
^- +1
 

« first day (1361 days earlier)      last day (3665 days later) »