Permission Problem??

[ceh1024]

I have a process that runs under a user called admin that fails everytime with the statement:

INSERT INTO default_en_activitylog (activitylog_log_date, userdb_id, activitylog_action, activitylog_ip_address) VALUES ('2007-10-27 15:29:32', '1', 'Successfully received data.zip', 'xx.xxx.xx.xxx')

I can run this exact same statement from phpadmin and it works fine.

I've changed permissions everyway that I can think of but still a problem.

I could use some inspiration if anyone has some ides.

Thanks

 

[Kozusnik]

Try...
GRANT ALL PRIVILEGES ON default_en_activitylog.* TO 'admin'@'localhost' IDENTIFIED BY 'some_password';

FLUSH PRIVILEGES;

If it's not running on localhost, change that to the IP or DNS name.

Mark

 

[ceh1024]

Thanks for the reply Mark.

Unfortunately that didn't help. I've tried various combinations that included but I tried it yet again.

So I'm still hunting for a solution.

Chuck

 

[elsenorjose]

How does it fail? What's the error message?

 

[ceh1024]

The process does the following. Downloads a zip file of 30MB. Unzips the file. Then processes the unziped portion into the Database. It fails at the point where it tries to insert tnotification of the sucessful download. so it does not get to the extraction part and beyond. THe production zip file it downloads is 30MD zipped and about 90MB raw.

I think I'm narrowing this down. I tried running the process and downloading a smaller file. It worked fine. Then I went back to the production file and it failed.

THere are no errors in any of the logs so I have to assume it just aborts for some reason.

Error message that appears is:

SQL ERROR: INSERT INTO default_en_activitylog (activitylog_log_date, userdb_id, activitylog_action, activitylog_ip_address) VALUES ('2007-10-29 19:40:31', '1', 'Successfully received fl_ftp_down/dn/mid_data.zip', 'xx.xxx.xx.xxx')
Server Type: Apache/2.0.52 (Red Hat)
Request Method: GET
Query String: action=Manager_load&task=get
User Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2)
Request URI: /admin/index.php?action=Manager_load&task=get
POST Variables: array (
)
GET Variables: array (
'action' => 'Manager_load',
'task' => 'get',
'printer_friendly' => false,
)

Chuck

 

[ceh1024]

Supplemental to the above.

I have systematically decreased the size of the file that is downloaded.

I get errors with the original 30MB zip.
I get errors with a 16MB zip.
I get NO errors with a 7MB zip.

So far I have changed the memory limt up to 768MB.

changed execution time to 120

Still no difference.

 

[elsenorjose]

Perhaps posting this in the forum of your process's language might help. It doesn't appear to be a MySQL problem if you can insert through PHPMyAdmin and that error message you posted isn't a MySQL error message. What are you using for your application?

 

[ceh1024]

The process runs as a php application that does all the work and inserts staus and updates to the database. I believe at this point that the error from the application is not accurate as everything runs fine when I download and parse the smaller zip file. So I am assumming that something is causing the php to fail that isn't being recorded in the logs either php or sql.