Posts Tagged ‘error’

Remote access to MySQL – error 10061 can’t connect to MySQL server – host is not allowed – user is not allowed

Sunday, February 15th, 2015

I’ve just been reviving my ubuntu (linux) server on the LAN to do some interface development and testing, and thought it would be easier to work if I had remote access to the MySQL databases to use something a little more productive than phpMyAdmin.

Poof! What a palaver! All up and running now, but time to make some notes in case I ever have to do this again. In case it matters, it’s the long term support LTS version of Ubuntu 12.04 (purple pangolin IIRC).

Anyhow, the default install of a LAMP server (linux/apache/mysql/php) doesn’t allow remote access, so you have to set it up.

The original error was

SQL Error (2003): Can't connect to MySQL server on hostname (10061)

 
(more…)

Error creating products: PHP Warning: move_uploaded_file(name.JPG)

Sunday, February 14th, 2010

The full error message is:

PHP Warning: move_uploaded_file(name.JPG) [<a href=’function.move-uploaded-file’>function.move-uploaded-file</a>]: failed to open stream: Permission denied in …oscdir…/admin/includes/classes/upload.php on line 84

Proved to be a kind of intermediate permissions error. Goes away like other permissions problems with 777 insecure settings. To give the web server write access on Hostroute, you need owner set to cpanel user, group set to nobody and write permissions to both. You have to get Hostroute support to set group nobody, as it’s not permitted from the account shell access even when that’s turned on.

This exact error was after group was set to nobody but it only had read access; change permissions in ftp program.

This relates to install instructions: http://svn.oscommerce.com/confluence/display/OSCDOC/Pre-Installation+Steps#Pre-InstallationSteps-FileandDirectoryPermissions

Error creating products: PHP Warning: file_exists()

Thursday, February 11th, 2010

The full error message is:

PHP Warning: file_exists() [<a href=’function.file-exists’>function.file-exists</a>]: open_basedir restriction in effect. File(/usr/bin/convert) is not within the allowed path(s): (…actual settings removed…) in …oscdir…/admin/includes/applications/products/actions/save.php on line 23

It turns out just to be a configuration error. Osc 3.0A5 defaults to Imagemagick for image processing with the path set to /usr/bin/convert. Delete this in program locations to make the error go away. See http://forums.oscommerce.com/topic/331275-imagemagick/page__p__1380028&#entry1380028