Cron issue in Debian 6

Discussion in 'Installation/Configuration' started by Nolan, Apr 17, 2011.

  1. Nolan

    Nolan Member

    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
     
    Last edited: Apr 17, 2011
  2. falko

    falko Super Moderator ISPConfig Developer

    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?
     
  3. Nolan

    Nolan Member

    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.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

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

    Nolan Member

    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
    
    
     
    Last edited: Apr 18, 2011
  6. till

    till Super Moderator Staff Member ISPConfig Developer

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

    Nolan Member

    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.
     

Share This Page