Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Inventory path character limit of 255 #478

Closed
poundbangbash opened this issue May 5, 2016 · 1 comment
Closed

Inventory path character limit of 255 #478

poundbangbash opened this issue May 5, 2016 · 1 comment

Comments

@poundbangbash
Copy link
Contributor

Due to autopkg being on my machine it has some long path names to applications like "/Users/eholtam/Library/AutoPkg/Cache/com.github.poundbangbash.eholtam-recipes.pkg.SuspiciousPackageApp/SuspiciousPackageAppPkg/Applications/SuspiciousPackage.app/Contents/Library/QuickLook/SuspiciousPackage.qlgenerator/Contents/SharedSupport/UpdateCheckerHost.app" which is 266 characters. With that in my home directory I get the following when munkireport tries to report the inventory back in.

 Munkireport: Server info: starting: reportdata
Server An error occurred while processing: Inventory_model
Server Error: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'path' at row 1
Server info: starting: inventory

As a workaround I've added $conf['bundlepath_ignorelist'] = array('.*/Library/AutoPkg.*'); to config.php but it may be worth looking at increasing the path character limit and if it impacts db speeds.

bochoven added a commit that referenced this issue May 6, 2016
@LukeAndrews
Copy link

I ran the following command on my MySQL db to fix it:
ALTER TABLE inventoryitem MODIFY path VARCHAR(512);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants