HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Cron issue in Debian 6 (http://www.howtoforge.com/forums/showthread.php?t=52333)

Nolan 17th April 2011 06:58

Cron issue in Debian 6
 
Hi, I've got a cron job to execute every minute, and It's not working. :( The web files were transferred from a different server with permissions.
Here's the ISPConfig Cron - Log:
Code:

PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
ERROR: /var/www/clients/client1 is writable by group or others!mkdir: cannot create directory `/var/www/clients/client1/web2/var': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run/mysqld': File exists
ERROR: /var/www/clients/client1 is writable by group or others!ERROR: /var/www/clients/client1 is writable by group or others!invalid shell, /var/www/clients/client1/web2/bin/bash does not exist
usermod: no changes
PHP Warning: mkdir(): File exists in /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php on line 293
ERROR: /var/www/clients/client1 is writable by group or others!mkdir: cannot create directory `/var/www/clients/client1/web2/var': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run/mysqld': File exists
ln: creating hard link `/var/www/clients/client1/web2/var/run/mysqld/mysqld.sock': File exists
ERROR: /var/www/clients/client1 is writable by group or others!ERROR: /var/www/clients/client1 is writable by group or others!invalid shell, /var/www/clients/client1/web2/bin/bash does not exist
usermod: no changes
PHP Warning: mkdir(): File exists in /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php on line 293
ERROR: /var/www/clients/client1 is writable by group or others!mkdir: cannot create directory `/var/www/clients/client1/web2/var': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run': File exists
mkdir: cannot create directory `/var/www/clients/client1/web2/var/run/mysqld': File exists
ln: creating hard link `/var/www/clients/client1/web2/var/run/mysqld/mysqld.sock': File exists
ERROR: /var/www/clients/client1 is writable by group or others!ERROR: /var/www/clients/client1 is writable by group or others!invalid shell, /var/www/clients/client1/web2/bin/bash does not exist
usermod: no changes
PHP Warning: mkdir(): File exists in /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php on line 293
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.
repquota: Cannot find any quota file to work on.

Any suggestions?

-Nolan

falko 18th April 2011 09:45

Quote:

Originally Posted by Nolan (Post 255446)
The web files were transferred from a different server with permissions.

Do the same users exist on this server as well?

Does MySQL run? What's the output of
Code:

netstat -tap | grep mysql
?

Is this a physical machine or a virtual server?

Nolan 18th April 2011 16:40

Yes, the users are the same, and MySQL is running
It's a xen VPS.

The cron job works now, removing the one that was there, then adding again made it work, those MySQL errors are now gone.

However, the quota error is still there, and I'd like to enable that.

till 18th April 2011 16:42

Please see perfect setup guide for ispconfig 3 on debian 6 on how to enable quota on a debian 6 server.

Nolan 18th April 2011 17:13

I already had something similiar to what was in the /etc/fstab file in the guide.

I'm not sure what that UUID stuff in the example is
Code:

# /etc/fstab: static file system information.
#
# Use 'blkid' to print the universally unique identifier for a
# device; this may be used with UUID= as a more robust way to name devices
# that works even if disks are added and removed. See fstab(5).
#
# <file system> <mount point>  <type>  <options>      <dump>  <pass>
proc            /proc          proc    defaults        0      0
# / was on /dev/sda1 during installation
UUID=92bceda2-5ae4-4e3a-8748-b14da48fb297 /              ext3    errors=remount-ro,usrjquota=aquota.user,grpjquota=aquota.group,jqfmt=vfsv0 0      1
# swap was on /dev/sda5 during installation
UUID=e24b3e9e-095c-4b49-af27-6363a4b7d094 none            swap    sw              0      0
/dev/scd0      /media/cdrom0  udf,iso9660 user,noauto    0      0
/dev/fd0        /media/floppy0  auto    rw,user,noauto  0      0

Here is my /etc/fstab/
Code:

/dev/xvda1      /            ext3    errors=remount-ro,usrjquota=aquota.user,
grpjquota=aquota.group,jqfmt=vfsv0      0 1
/dev/xvda2      swap          swap    defaults      0 0
proc            /proc        proc    defaults      0 0


till 18th April 2011 17:32

Your fstab looks ok. Now proceed with the next steps from the tutorial to activate quota.

Nolan 18th April 2011 17:36

Errors :(
Code:

root@serv1:~# mount -o remount /
root@serv1:~# quotacheck -avugm
quotacheck: WARNING -  Quotafile //aquota.user was probably truncated. Cannot sa
ve quota settings...
quotacheck: WARNING -  Quotafile //aquota.group was probably truncated. Cannot s
ave quota settings...
root@serv1:~# quotaon -avug
quotaon: Cannot find quota file on / [/dev/xvda1] to turn quotas on/off.
quotaon: Cannot find quota file on / [/dev/xvda1] to turn quotas on/off.



All times are GMT +2. The time now is 07:42.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.