- System Administrator Troubleshooting FAQ
- Can I manually edit the InterWorx database?
- I got an InterWorx error saying to check the error log for details. How do I do that?
- Can I change my (or my customer's) domain name?
- CRON isn't working/responding for a given user.
- How do I extract zipped file from the SiteWorx control panel?
- The Untar feature in Fileman does not work.
- I am trying to delete a SiteWorx account from the InterWorx interface but it's not working. What can I do?
- I am running InterWorx-CP using a language other than English. How come the statistics only show in English?
- Can I disable the collection and compilation of AWSTATS?
- I've run out of room out the partition/hard drive containing /home. Is it possible to resize the hard drive or does InterWorx support a secondary hard drive?
- What's the difference between the package.deactivate.pex and domain.deactivate.pex commands?
- Is there any way to get a complete list of all accounts on a server?
System Administrator Troubleshooting FAQ
This is a general troubleshooting FAQ for a System Administrators.
Can I manually edit the InterWorx database?
No. Doing so is highly dangerous unless you know exactly what you are doing. Unless you have backups of the InterWorx-CP tables, the only way to restore a fouled database is to reinstall the InterWorx software which normally requires a server OS reinstall as well, which can be costly.
| Editing of the InterWorx database will put the system in an inconsistent state and void your support until the software is reinstalled from scratch. |
I got an InterWorx error saying to check the error log for details. How do I do that?
Run the following command from the shell:
tail ~iworx/var/log/iworx.log
This will spit out the last 10 lines of the error log.
If you would like to see more than just the 10 lines then use the -n attribute for example
tail -20 ~iworx/var/log/iworx.log
for 20 lines.
You may need to do 40 or 50 lines if the error is in the creation of a SiteWorx account or ScriptWorx xcript install.
Can I change my (or my customer's) domain name?
That would be extremely difficult and confusing given how InterWorx works.
When you create an account the system creates a (Linux) system user for the new account biased upon the first 8 alphanumeric characters of the domain that they select:
DOMAIN: mydomain.com SYSTEM USER: mydomain HOME DIRECTORY: /home/mydomain WEB ROOT: /home/mydomain/mydomain.com/html
If you change the domain, this system would no longer be valid. To start with things would probably still work okay, but eventually it would just get confusing.
Workaround:
Use a pointer domain otherdomain.com => mydomain.com
A pointer domain redirects all web services including, website, ftp, and email
CRON isn't working/responding for a given user.
We’ve seen this on a few boxes. Cron just needs a jolt to get going sometimes.
Just edit the user’s cronjobs, make a spacing change to trick cron, and then save.
How do I extract zipped file from the SiteWorx control panel?
The File Manager utility in InterWorx shows a tar utility on the menu but zip is also supported, simply click on the zip archive and it will open the contents of the archive. You can then use the menu at the bottom to extract those files and choose where you want to extract them to.
The Untar feature in Fileman does not work.
You need to install a Perl library. Log in as root and type the following command:
yum install perl-Archive-Zip
However, this SHOULD already be installed.
I am trying to delete a SiteWorx account from the InterWorx interface but it's not working. What can I do?
You can delete it from the command line by running:
/home/interworx/bin/package.deactivate.pex --domlist <domain>
I am running InterWorx-CP using a language other than English. How come the statistics only show in English?
InterWorx-CP utilizes several 3rd party tools to provide site statistics. Unfortunately, many of these do not provide alternate language selections. Hopefully the developers of these packages will recognize the value of being multi-lingual and update. When and if this happens, InterWorx will, of course, bundle the new versions and support that functionality.
Can I disable the collection and compilation of AWSTATS?
Yes. Edit ~iworx/iworx.ini
Look for [stats.awstats] and change enabled=”1” to enabled=”0”.
The only negative impact this has is that AWSTATS will not be available.
I've run out of room out the partition/hard drive containing /home. Is it possible to resize the hard drive or does InterWorx support a secondary hard drive?
Resizing a partition in Linux is possible -- but strongly not recommended -- and InterWorx does not recognize the existence of a secondary hard drive on your system. The easiest way around this is to add a second hard drive. Mount the drive as /home2 (or whatever you want) and then mv /home/myuser to /home2/myuser for some of your larger accounts and then set up a symlink from /home/myuser to /home2/myuser. By doing this your quotas may not work correctly.
What's the difference between the package.deactivate.pex and domain.deactivate.pex commands?
domain.deactivate.pex and package.deactivate.pex are two different commands. package.deactivate.pex is the correct command to use when trying to delete an account from the command line, and it actually calls domain.deactivate.pex during the process. In short, domain.deactivate.pex doesn’t do “enough” to delete a SiteWorx account. domain.deactivate.pex should never be invoked directly.
Is there any way to get a complete list of all accounts on a server?
Yes, run
$ ~iworx/bin/listaccounts.pex
it dumps out the uniqname and domain name, per line, of every account on the box. For example:
$ ~iworx/bin/listaccounts.pex domainco domain.com abconetw abc123.net foobarco foobar.com
Or:
~iworx/bin/listaccounts.pex | awk '{print $2}'
which will produce:
domain.com abc123.net foobar.com
If you wanted to filter out something (like remove the .com domains from the list), you can do:
''~iworx/bin/listaccounts.pex | awk '{print $2}' | grep --invert-match .com
which will produce:
abc123.net
Check the grep man page for more ways you can filter those results.
[ Apted from: http://www.interworx.com/forums/showthread.php?t=1269 ]
