Quote:
Originally Posted by SweetT
I appreciate your position and I am happy that you are a customer.....but I want to try harder to get to that 100% mark. Would you consider having a phone call with me on Monday to discuss these situations and let me see if I can make some policy changes that will make you 100% satisfied? I dont every want a customer to be less than 100% satisfied so I will work hard to get there, I promise.
--T
|
I am going to be slammed with a million things on Monday. Our account is "AR Innovative ApS" and if you read through some of the tickets you might be able to see what I am saying but some of it occurred on the phone.
Here is a small example of what I went through this week with one of the techs. One of our servers hosts almost 100 tgp sites and I woke up yesterday to find that all of them were broken. At first I thought it was lighttpd which we use to serve the thumbs (separately from the pages)... it later turned out to be 2 issues... first was that somehow the database user lost all of it's permissions... I was getting an error in Smart Thumbs that said, basically:
Quote:
|
your mysql user does not have CREATE TEMPORARY TABLES privilege to be able to create temporary tables
|
The tech kept telling that nothing was wrong with the user permissions and posted this after saying he had fixed the CREATE TEMP TABLE permissions problem. See anything wrong with it?
Quote:
Host: %
User: <user>
Password: <password>
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: Y
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
|
The user doesn't have any permissions EXCEPT Create_tmp_table_priv. So I informed him of that problem and he fixed it...
The next problem was that I was getting this error in the mysql log in Smart Thumbs:
Quote:
|
Can't create/write to file '/tmp/#sql_54ad_0.MYI' (Errcode: 13)
|
Someone changed the permissions on /tmp and caused this error. This is what the tech said. (notice he is still saying it wasn't the mysql user permissions)
Quote:
Hi there,
It wasn't the mysql user permissions. It was the permissions on /tmp. It didn't have the sticky bit set, honestly probably someone here did that. I do apologise.
Thanks,
<techs_name>
|