ispCP - Board - Support
500 (All-Sites) on New User Add - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: 500 (All-Sites) on New User Add (/thread-3077.html)

500 (All-Sites) on New User Add - UndeadDevil - 04-18-2008 05:50 PM

Hi I've searched extensivly for a solution to this and not found any yet.
I have installed ispCP on Suse 10.3, Installation went perfectly (My first VHCS install took a good day! So you guys are doing a excellent job)

However at first when I tried to add a new user I got "sys_command() | ERROR: External command '/usr/sbin/groupadd -g 2001 vu2001' returned '15' status !"

I then deleted that User + Group, now it is still unable to create a new user but isn't telling me what is happening (sys_command_rs() | Ending...) and if I follow the Execute Request Queue Link Apache starts giving only a 500 Error until I restart Apache! I have checked Apaches log and see no errors at all.

Also proFTPd is now refusing to start giving the following error which Google hasn't really helped with although finding alot of relevent results.
"- Fatal: unknown configuration directive 'SQLAuthTypes' on line 165 of '/etc/proftpd/proftpd.conf'"

Perl-Crypt is install if that makes a difference?

Thanks for any and all help and sorry if I have left out any needed information

RE: 500 (All-Sites) on New User Add - joximu - 04-18-2008 07:22 PM

Hi

without logs it's hard to guess...

have a look in the database directly, DB ispcp, tbale domain, what's the status of the domain?

What happens if you run the request manager manually?

proftpd: did you install proftpd-sql-mysql? I think no...

Have you installed all of thesese packages?
http://www.isp-control.net/ispcp/browser/trunk/docs/OpenSuse/opensuse103-packages
(there are also some perl-crypt).

And have you installed the packages which have no suse rpm. See
http://www.isp-control.net/ispcp/browser/trunk/docs/OpenSuse/INSTALL
(perl-libIDN etc)

/J

RE: 500 (All-Sites) on New User Add - UndeadDevil - 04-18-2008 09:30 PM

If you need any specific logs please let me know.

Here is a copy of the Database Details from the Domain Table. (Please excuse bad formatting)

Code:
domain_id domain_name    domain_gid domain_uid domain_admin_id domain_created_id domain_created    domain_last_modified domain_mailacc_limit domain_ftpacc_limit domain_traffic_limit domain_sqld_limit domain_sqlu_limit domain_status domain_alias_limit domain_subd_limit domain_ip_id    domain_disk_limit domain_disk_usage domain_php domain_cgi
1    www.*****.com    2003    2003    3    2    1208385492    0    0    200    0    100    100    change    5    0    1    25844    0    yes    yes

Domain Status in ispCP when I click on Switch says Domain is simply "account status is not ok!"

All Needed Packages are installed, including libIDN-devel.

Normally I would be insulted that you asked about proftpd-sql-mysql, but under the circumstances I would have jumped to same conclusion.

Code:
│  i  │proftpd                 │1.3.1       │1.3.1      │Highly configurable │
│     │proftpd-devel           │1.3.1       │           │Development headers │
│  i  │proftpd-sql-mysql       │1.3.1       │1.3.1      │mysql module for pro│
I'm not sure how you run the Request Manager manually?

RE: 500 (All-Sites) on New User Add - joximu - 04-18-2008 09:40 PM

Hi

ok, I'm not sure if you really have "www.domain.com" as domain name - normally you only create "domain.com" as domain name... - but this should not be the problem Smile

Status = "change", so please run the request manager:

/var/www/ispcp/engine/ispcp-rqst-mngr

(you'll find this often in the forum...), if you set DEBUG to 1 in /etc/ispcp/ispcp.conf (last lines) then you should have some debug outputs - sometimes there are log infos from sub processes in other log files: /var/log/ispcp/*err*

Proftpd: could you check if proftpd is loading the mysql module?
In debian its
Include /etc/proftpd/modules.conf
and there at least
LoadModule mod_sql_mysql.c

/J

RE: 500 (All-Sites) on New User Add - UndeadDevil - 04-18-2008 10:01 PM

Request Manager returns the following.
Code:
/srv/www/ispcp/engine/ispcp-rqst-mngr
DEBUG: push_el() sub_name: mngr_start_up(), msg: Starting...
DEBUG: push_el() sub_name: lock_system(), msg: Starting...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('`which touch` /var/run/ispcp.lock'), msg: Ending...
DEBUG: push_el() sub_name: lock_system(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: mngr_start_up(), msg: Ending...
DEBUG: push_el() sub_name: mngr_engine(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/srv/www/ispcp/engine/ispcp-serv-mngr 2 0 0 0 1>/var/log/ispcp/ispcp-serv-mngr.stdout 2>/var/log/ispcp/ispcp-serv-mngr.stderr'), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: mngr_engine(), msg: Ending...
DEBUG: push_el() sub_name: mngr_shut_down(), msg: Starting...
DEBUG: push_el() sub_name: unlock_system(), msg: Starting...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('`which rm` -rf /var/run/ispcp.lock'), msg: Ending...
DEBUG: push_el() sub_name: unlock_system(), msg: Ending...
DEBUG: push_el() sub_name: mngr_shut_down(), msg: Ending...

/var/log/ispcp/ispcp-serv-mngr.stderr has following error. Not sure what it means.
Code:
which: no w3m in (/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin)

I have no /etc/proftpd/modules.conf, I will create it and add that line now and attempt to start it.

Edit: Added modules.conf, proftpd still gives same error, although WebMin now lists modules.conf in config edit.

RE: 500 (All-Sites) on New User Add - UndeadDevil - 04-18-2008 10:21 PM

To add after retrying the Request Manager Manually and checking error log I've now got the following as well.
Code:
/var/run/courier/imapd.pid.lock: No such file or directory
..failed
/var/run/courier/pop3d.pid.lock: No such file or directory
..failed
waiting for named to shut down /var/run/courier/imapd.pid.lock: No such file or directory
ll_daemon_start: Resource temporarily unavailable
..failed
/var/run/courier/pop3d.pid.lock: No such file or directory
ll_daemon_start: Resource temporarily unavailable
..failed

The files do not exist in /var/run/courier but instead in just /var/run, there is NO config in ispCP to change them from what I can see. (I've only checked /etc/ispcp/ispcp.conf)

This server only had Suse 10.3 installed a few days ago so everything should be defaults.

RE: 500 (All-Sites) on New User Add - joximu - 04-19-2008 07:45 AM

ok, lets roll this out...

what version did you download?

did you follow the correct installation guide?
(there once was a mistake "make install" instead of "make -F Makefile.opensuse install")

Since a few months/weeks/versions ispCP does not change the courier config files any more.

RE: 500 (All-Sites) on New User Add - UndeadDevil - 04-20-2008 05:15 PM

Sorry for delay replying, I installed RC4. I followed the instructions to the latter, but to be sure is there a uninstall script so I can reinstall? If not could I have manual instructions?

RE: 500 (All-Sites) on New User Add - GuS - 05-13-2008 04:29 AM

Hi Guys,

I am having the same problems here...
When i try to use an User (domain) in the debug of the Admin panel i have:

Quote:gdnet.com.ar - Set status to "change"
sys_command_rs() | Ending...

And why setting the status on the DB to ok? and then run the script ispcp-rqst-mngr? Makes non sense if this operation fails, cause the corresponding dir of the domain inside /var/www/virtual/ is not being added and non /etc/apache2/sites-available/ispcp.conf entry either.

I am currently using Kubuntu Hardy - ISPCP RC4

I was having an old svn version of ISPCP and was working perfectly.... now i cant add domains...

In /var/log/daemon.log i have (related to ispcp):

Quote:May 12 15:14:48 servidor ispcp_daemon[1124]: child 1124 started !
May 12 15:14:48 servidor ispcp_daemon[1124]: send_line(): socket write error: Connection reset by peer
May 12 15:14:49 servidor ispcp_daemon[604]: EINTR was received ! continue;

But i am not sure if this is relevant.

I am attaching ispcp log.

Hope someone could help me...

Cheers.

EDIT: Ive installed ispcp from zero again but with debug enabled, and i have almost same errors as in the log (those marked with "error" entry). Is something with the tags {}... Example:

Quote:msg: ERROR: '{BASE_SERVER_VHOST}' eq '{BASE_SERVER_VHOST}', missing '{BASE_SERVER_VHOST}' in src !