This isn't very food related, but for anyone who wants to get webhosting or has had problems with webhosts in the past, this entry might be the funs! And by "the funs" I mean...it hurts, oh god, why does it hurt?
Here's the exchange of emails I had with the 1and1 support team, who I think teacher into a bin of papers marked "THINGS TO TELL CUSTOMERS WHO KEEP BOTHERING YOU" and replied with whatever was written on the paper. ...And the papers came from another bin callled "THINGS THAT WILL DEFINITELY NOT WORK."
Some content has been edited down (although I left the spelling errors in for fun). You'll get the jist. I'm not the most competent webmaster, but I might be better on a webhost support team than these people. Which isn't saying much.
On Friday at around noon, I started having problems with my mysql database when I tried to update my Movable Type-powered blog. I got the error message:
"Error during upgrade: failed to execute statement alter table mt_comment add comment_junk_status smallint default 0: Access denied for user: 'dbo92785265@%' to database 'db92785265' at lib/MT/Upgrade.pm line 1190."
I figure something must have been done to the database without me knowing and now my username doesn't have all permissions to the database. Could someone update the user so it has all permissions?
Due to security reasons, we only to access the database if the domain is hosted with 1&1, I checked on your domains and your domains seems to be hosted with another company, the onyl advise that I can give you is to point the domain to 1&1 name servers.
[Exchanged a bunch of messages as my domain was switching from dreamhost to 1&1. I thought it had gone through, but it hadn't, blah blah. At some point it went through. Let the fun continue!]
Could you check the mysql database and grant the user all permissions? Please let me know if/when you can do this (as I've come > to the conclusion that the control panel doesn't let me do this).
Yo9u may clic phpMyAdmin in the MySQL Administration of your 1&1 Control Panel.
I don't see where in phpMyAdmin I can edit the user's permissions. Could you tell me how to do this in phpMyAdmin or some other way to do it?
You may find phpMyAdmin button in Administration tab -> MySQL Administration.
I wasn't asking where phpmyadmin is located, but where INSIDE phpmyadmin can I set user permissions? I don't see it. My assumption is that this is something 1and1 has to do. My permissions were changed by 1and1 (not me, at least) last Friday, preventing me from accessing my database
When you can launch phpMyAdmin then that means you can connect to the dataabse because phpMyAdmin is set to open the database.
Although I can access the database through phpMyAdmin, the user doesn't actually have all privileges. If it did, I wouldn't have had problems using movable type. On Friday afternoon, movable type stopped working for me, despite that I didn't do anything to the databases or alter anything in phpmyadmin. The error I got from movable type (which worked for years up until Friday) is that the database user doesn't have access to the database. I didn't change any information; it just stopped working. Other people have had the same problem because the user didn't have all privileges. I'm not asking how to access my database, but how to grant the user all privileges, which I don't see how to do through phpmyadmin.
The reason why you can't connect to the database anymore is that the maximum limit on the size of 100 Mb has been reached. You may check it in MySQL Administration on the Storage Space box.
I cleared up space in my database so that its way below 100 MB now. Movable Type still can't access the database. Do you know exactly how to grant all privileges to the user?
Movable Type will be accessible on Linux, if you cant access the Movable type, according to experience that there might be something wrong on the script or the database itself.
That was enough to endure, right? I'm not the one at fault, right? Okay. I don't think 1and1 knows how to train their support team. If they don't know how to help me, then 1and1 doesn't require them to know.
On top of all those lovely messages, I got this gem:
Thank you again for choosing 1&1 web services. We are writing to follow up on your recent contact with our technical support department. As 1&1 is constantly striving to improve service performance and provide greater value to our customers, we ask that you please take a moment to follow the link below and answer a few survey questions.
AHHHHHHHHHHHHHHHHHHHHHH. Please tell me you're kidding. Please? PLEEEEEEEAASE?
Moral of the story: don't use 1and1 as a host. I'll admit that I use them for domain names. Can they fuck that up?
You're probably bored right now. Um. Err...[looks around for a photo to entertain you with]...
Ahhh, Sugar Sweet Sunshine, you fill my heart with sugary love! My heart! My...aaack [clutches chest] gfflrttpt [spasms] eeughuhpop [twitches]
Nah, I'm okay.
On a random note, The Food Pornographer made an interesting post that delves into her singer-songwriter guitar-playing past. I have no interesting past to speak of, BUT SOMEDAY...maaaybe.
Another thing, more food related: The Food Section reviews the selection of chocolate chip cookies sold at the Union Square Greenmarket. Damn, I wanted to do that! It would've given me an excuse to eat all the chocolate chip cookies! Not that I really need an excuse.
I should have something more food related/review filled later, but if not I'll be out from Saturday to Sunday away from my laptop. Frightening? Perhaps. I can't last much longer than that.