Unable to upload in house ipa

billanook
New Contributor

Hi,

We are trying to upload an in house ipa file but are recieving the error "Unable to upload the specified file".
I read that the max file size in MySQL needs to be changed in the JSS Database Utilities but when I try and go to the MySQL settings it is greyed out.

Any help appreciated.

Thanks.

2 REPLIES 2

Steven_Xu
Contributor

I have the same problem, don't know how to fix it.

NickKoval
Contributor
Contributor

I've seen the greyed out issue happen on a windows JSS where the JSS Database Utility has no control over the MySQL instance. I don't know what causes that disconnect or how to make the JSS Database Utility hook up with MySQL for administration purposes, but I have been able to fix the max file size issue without using the JSS Database Utility. Here's what I've done:

  1. Open the MySQL command line application & log in with the root username and password.
  2. Type in the following command to show your current max_allowed_packet setting: ``` SHOW VARIABLES LIKE 'max_allowed_packet';
    1. Navigate to your Data location for MySQL (the default location is C:ProgramDataMySQL<MySQL version>).
  3. Open the my.ini file and increase the number next to the max_allowed_packet variable.*
  4. Save your changes and close the my.ini file.
  5. Open the Services Administration Tool and use that to restart MySQL.
  6. Again open the MySQL command line application and log in with the root username and password.
  7. Type in the following command to verify your new current max_allowed_packet setting:** ``` SHOW VARIABLES LIKE 'max_allowed_packet';

* Typically, I round up to the next 10 MB for my inhouse .ipa's. So if it's a 12 MB ipa I'll set the packet size to 20 MB.
** If the max_allowed_packet didn't change, your mysql instance is most likely using a different .ini file.

Hope this helps.