I should clarify: the first table screenshot is after deleting the row manually, and "reinstalling" the plugin via UI, leading to the UI screenshot in my reply to your initial response.
Plugins "defunct-missing" after v1.10.4 to v1.11 upgrade
In that case I do not see a problem with the data in the database.
Maybe your running into this:
https://github.com/osTicket/osTicket/issues/4718
The uninstall left the config data in the ost_config table, and so maybe it needs to be removed.
Doesn't appear to be the case?
there is nothing namepace='plugin.3'?
Nope. If it would be helpful, I have a complete backup (still building it out on my end currently) from prior to the v1.11 upgrade that I can revert back to if necessary.
You checked if there was more than one page of results right? ? [Sorry I have to ask because I have 197 entries in my ost_config table]
If there is no data in the plugin table, and no data in the ost_config I don't know why it would think that the plugin is partially installed. I've had to manually remove plugins before and removing them from those two places has always resulted in the plugin being gone from the system.
My bad... It's been a long week and it's only Wednesday. See attached.
Clicking on file results in an error.
{"errors":[{"code":500,"title":"Internal server error"}]}
Maybe .pdf are not allowed on the forums.
- Edited
Strange. Tried to do it as a .csv and it wouldn't even let me upload that.
Here's a screencap of what I think you were interested in:
- Edited
So here is wha tI would do. back up that table (or at least keep the screen capture)
Assuming that you are only running the ldap/ad plugin and no others.
delete every line with a namespace of plugin.#.
delete the entry in the ost_plugin table.
Try reinstalling/configuring/enabling the plugin fresh.
ps I remove the image from the forums since it showed a hash of the password and the username. I kept a copy just in case you did not. I can email it to you if you need it. I will delete it once I hear back that you do not need it.
Tried your suggestion.
Removing the entry in ostum_plugins and lines from ostum_config where namespace=2 (originaly plugin ID in ostum_plugins) removed the entry from the UI. Attempting to reinstall produces this again:
Here's the ostum_plugins table after all this:
Table ostum_config contains no lines where namespace=plugin.3
Sorry I'm out of ideas then.
@KevinTheJedi any thoughts?
Have you checked the permissions/ownership of the phar file?
Do me a favor and run the following commands in the osTicket directory:
$ chmod -R 0644 include/plugins/
$ chown -R www-data:www-data include/plugins
Restart Apache and retest.
Cheers.
Ran those commands:
Working on restarting Apache... I am not in direct control of that since this is a "resold" cPanel version (i.e. only the cPanel admins at my institution are able to do that.)
Prior to running those commands, I could view and edit the files in the included cPanel file manager no issue. It now appears I do not have permissions on those files any more.
As a side you would want to find out what user the webserver runs as. Some web hosts use your username. Other use something else. setting it to www-data is usually safe on debian (and derivatives) but not all linux webservers run as that username. If they are owned by the same user the rest of your files are owned as it should be okay so long as the permissions are good.
So, I am unable to restart Apache on my server because it is a resold version of cPanel, and the admins at my institution haven't given end users the ability to do so. In addition, files in /include/plugins are now completely locked, and I am unable to utilize chmod or chown to change perms/ownership.
Any ideas? At this point I'm wondering if it might be worth to restore from the last v1.10.4 backup I have just before upgrading, and try doing the upgrade manually, as opposed to doing it through Softaculous.