I was getting the following error when trying to use Plesk’s backup function:
ERROR Unable to open /opt/psa/var/apspkgarc/archive-index.xml
The solution is to visit the “Application Vault” under the “Server” tab of your Plesk interface. The file gets auto-generated at that point.
For more information on how to use Plesk’s backup feature, read this post
I was recently installing Warehouse on a Ubuntu Server, and was using nano quite a bit for some simple edits. One thing that was quite annoying was the fact that the “backspace” on my Mac was acting like the forward delete. I figured there had to be a configuration directive somewhere, which I found in /etc/nanorc. I opened that file (remember to use sudo) and un-commented this line out:
## Fix Backspace/Delete confusion problem. set rebinddelete
That fixed the issue.
Tip: you can search for delete by hitting ctrl+w and typing delete.
First off, install MacPorts, with some additional instructions here.
Then open up the Terminal (/Applications/Utilities/Terminal.app) and type:
sudo port install ntop
Notice: It will take a LONG time even on good hardware (about 10 minutes on my Mac Pro with a striped RAID boot array).
After that is complete, you can then launch it by running:
sudo ntop -d
which launches it in daemon mode so that you can close your terminal and still have it running in the background.
It should prompt you to enter the admin password, which has to be 5 characters or more. Type it again to confirm, and it should launch.
Notice that if you do not run it with sudo, you may receive this message:
mac-pro:~ ryebread$ ntop Fri Dec 19 10:57:15 2008 NOTE: Interface merge enabled by default Fri Dec 19 10:57:15 2008 Initializing gdbm databases Fri Dec 19 10:57:15 2008 **ERROR** ....open of /opt/local/var/ntop/prefsCache.db failed: File open error Fri Dec 19 10:57:15 2008 Possible solution: please use '-P ' Fri Dec 19 10:57:15 2008 **FATAL_ERROR** GDBM open failed, ntop shutting down... Fri Dec 19 10:57:15 2008 CLEANUP[t2687149856]: ntop caught signal 2 [state=2] Fri Dec 19 10:57:15 2008 ntop is now quitting...
It’s just telling you that it does not have the proper permissions to run in the /opt/local/var/ntop/prefsCache.db database.
Go to a web browser, and type:
http://localhost:3000
and you should be able to see an interface something like the following:
ntop running on Mac OS X 10.5.6, Leopard
After a fresh installation of SugarCRM on a test CentOS 5 box, I received the following error with a blank white screen typical of a PHP or die() statement.
Query Failed: AND users.id = '1'::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND users.id = '1'' at line 1
To fix it, simply turn off PHP Safe Mode in the php.ini file that is usually located in the /etc directory. Issue a service httpd restart and you should be good to go.
Do you need to quickly add a specific user with access to only a certain table? Issue this command as a root or admin user:
GRANT ALL ON testdb.* TO 'testuser'@'localhost' IDENTIFIED BY 'pass1';
You can also limit user’s privileges to specific ip addresses or domains in case you need to access your databases from a different host.
GRANT ALL ON *.* TO 'testuser'@'remote.farmsoftstudios.com' IDENTIFIED BY 'pass1';