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 ]

COPYRIGHT © InterWorx L.L.C. 2004-2008 PRIVACY POLICYEULA