Import Failure

[ianobetz]

I'm attempting to import a comma delimited list of leads from one sugar database into another. Their versions vary slightly, but not much.

When I attempted to import the lead list, I receive an error message:
File was not uploaded successfully. It may be that the 'upload_max_filesize' setting in your php.ini file is set to a small number

My upload_max_filesize is set to 60M and the file is 11.9K. I believe the problem is a permission issue.

Does anyone know which file needs to have open permissions to get the import to work?

[andopes]

Make sure session.save_path is a valid folder in php.ini
Make sure cache folder is writable.

Regards

[ianobetz]

session.save_path is a valid path: /var/lib/php5
chmod 777 -R cache directory

Still the same error. There are probably 20 leads exported from database 6.1RC to go into 6.2.

[ianobetz]

I'm also having issues with logging into phpmyadmin. The error is:
#1 - Can't create/write to file '/tmp/#sql_30f_0.MYI' (Errcode: 13)

I'm fairly certain I have a permission problem. Unfortunately, I don't know enough about Ubuntu to add the services to the correct user/permissions. PHP runs under the www-data owner/group, most of the files (sugar and phpmyadmin) are also under the www-data owner/group, but I am unable to upload new files without changing the owner/group to a super user.

Can anyone give me a decent article about how to structure the owner/group, etc?

[andopes]

session.save_path is a valid path: /var/lib/php5
chmod 777 -R cache directory

Still the same error. There are probably 20 leads exported from database 6.1RC to go into 6.2.

You shoudn't be able to write on /var/lib/php5, neither apache user.
Update it to /tmp instead.

Regards

[ianobetz]

I updated it to /tmp, but now I can't login. It was actually commented out before I changed it to tmp.

[ianobetz]

Fixed it by changing the permissions of /var/lib/php5 to 777 recursively. I'd sure like to know why I have to mess with all of these permissions. I'm pretty sure I have them setup incorrectly.