Mysql problems

Discussion in 'HOWTO-Related Questions' started by thabangk, Oct 19, 2009.

  1. thabangk

    thabangk New Member

    How can i remove mysql and install a fresh copy and with default settings because i messed up everything.can somebody give me the exact guide.
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Which distribution do you use?
     
  3. thabangk

    thabangk New Member

    I use centos 5.3 x86_64
     
  4. thabangk

    thabangk New Member

    I manage to sort that out,the problem was the user-priviledges, now i got the problem with clamd.It fails to restart

    This is the error:
    [[email protected] ~]# service clamd start
    Starting Clam AntiVirus Daemon: LibClamAV Error: cli_loaddbdir(): Can't open directory /var/clamav
    ERROR: Can't open file or directory
    [FAILED]

    And got this in the messages:

    Oct 20 06:55:49 server1 clamd[4200]: No stats for Database check - forcing reload
    Oct 20 06:55:49 server1 clamd[4200]: Reading databases from /var/clamav
    Oct 20 06:55:51 server1 clamd[4200]: Database correctly reloaded (632783 signatures)
    Oct 20 06:58:53 server1 clamd[4424]: clamd daemon 0.95.2 (OS: linux-gnu, ARCH: x86_64, CPU: x86_64)
    Oct 20 06:58:53 server1 clamd[4424]: Running as user clamav (UID 101, GID 105)
    Oct 20 06:58:53 server1 clamd[4424]: Log file size limit disabled.
    Oct 20 06:58:53 server1 clamd[4424]: Reading databases from /var/clamav
    Oct 20 06:58:53 server1 clamd[4424]: Not loading PUA signatures.
    Oct 20 06:58:53 server1 clamd[4424]: Can't open file or directory
    I'm using centos 5.3

    Please help.
     
  5. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    ls -la /var/
    ?
     
  6. thabangk

    thabangk New Member

    [[email protected] ~]# ls -la /var/
    total 228
    drwxr-xr-x 28 root root 4096 Oct 20 06:30 .
    drwxr-xr-x 24 root root 4096 Oct 20 00:14 ..
    drwxr-xr-x 2 root root 4096 Oct 20 12:00 account
    drwxr-x--- 6 amavis amavis 4096 Oct 20 06:36 amavis
    drwxr-xr-x 13 root root 4096 Oct 20 12:15 cache
    drwxr-xr-x 2 clamav clamav 4096 Oct 21 04:02 clamav
    drwxr-xr-x 2 root root 4096 Mar 17 2007 cvs
    drwxr-xr-x 3 root root 4096 Oct 20 12:00 db
    drwxr-xr-x 3 root root 4096 Oct 20 12:03 empty
    drwxr-xr-x 3 root root 4096 Oct 20 12:03 ftp
    drwxr-xr-x 2 root root 4096 Mar 11 2009 games
    drwxrwx--T 2 root gdm 4096 Sep 5 23:07 gdm
    drwxr-xr-x 32 root root 4096 Oct 20 04:58 lib
    drwxr-xr-x 2 root root 4096 Mar 11 2009 local
    drwxrwxr-x 5 root lock 4096 Oct 21 04:04 lock
    drwxr-xr-x 17 root root 4096 Oct 21 04:04 log
    lrwxrwxrwx 1 root root 10 Oct 20 11:56 mail -> spool/mail
    drwxr-x--- 5 root named 4096 Jul 30 02:54 named
    drwxr-xr-x 2 root root 4096 Mar 11 2009 nis
    drwxr-xr-x 2 root root 4096 Mar 11 2009 opt
    drwxr-xr-x 2 root root 4096 Mar 11 2009 preserve
    drwxr-xr-x 2 root root 4096 Jan 21 2009 racoon
    drwxr-xr-x 25 root root 4096 Oct 21 22:14 run
    drwxr-xr-x 18 root root 4096 Oct 20 05:47 spool
    drwxrwxrwt 2 root root 4096 Oct 21 04:02 tmp
    drwx------ 2 root root 4096 Jan 7 2007 tux
    drwxr-x--- 2 amavis amavis 4096 Jul 19 15:59 virusmails
    drwxr-xr-x 8 root root 4096 Jul 14 12:06 www
    drwxr-xr-x 3 root root 4096 Oct 20 12:03 yp
     
  7. falko

    falko Super Moderator ISPConfig Developer

    Ok, what's the output of
    Code:
    ls -la /var/clamav/
    ?
     

Share This Page