Installation source!

Discussion in 'HOWTO-Related Questions' started by poba, Mar 20, 2007.

  1. poba

    poba New Member

    The Perfect Setup - Debian Sarge and MySQL 5!

    Hi,

    I'm trying to setup Debian Sarge server with MySQL 5. If I follow the "The Perfect Setup" instructions I get MySQL 4. I tryed to change this line
    Code:
    apt-get install mysql-server mysql-client libmysqlclient12-dev
    during the setup, but without success. Then I changed the installation source and try to update MySQL4 to 5. Nothing.

    Sorry for n00b question, but please help me.
     
    Last edited: Mar 20, 2007
  2. falko

    falko Super Moderator ISPConfig Developer

    Do you see any MySQL 5 packages when you run
    Code:
    apt-cache search mysql
    ? If not, you can try the packages from http://dotdeb.org/ .
     
  3. poba

    poba New Member

    Thanks for reply.

    First I checked if there are MySQL 5 packages. There were only MySQL 4 packages. So I added source in /etc/apt/sources.list

    Code:
    #deb file:///cdrom/ sarge main
    
    deb http://dotdeb.pimpmylinux.org/ stable all
    deb-src http://dotdeb.pimpmylinux.org/ stable all
    
    deb http://ftp.si.debian.org/debian/ stable main
    deb-src http://ftp.si.debian.org/debian/ stable main
    
    deb http://security.debian.org/ stable/updates main
    
    But now I get this! There is MySQL 5, but in the end it's "Checking for corrupt, not cleanly closed and upgrade needing tables."

    Code:
    debian:~# apt-get install mysql-server mysql-client libmysqlclient12-dev
    Reading Package Lists... Done
    Building Dependency Tree... Done
    The following extra packages will be installed:
      libdbd-mysql-perl libdbi-perl libmysqlclient12 libmysqlclient14 libmysqlclient15off libnet-daemon-perl libplrpc-perl
      mysql-client-5.0 mysql-common mysql-server-5.0
    Suggested packages:
      dbishell mysql-doc tinyca
    Recommended packages:
      libmysqlclient14-dev
    The following NEW packages will be installed:
      libdbd-mysql-perl libdbi-perl libmysqlclient12 libmysqlclient12-dev libmysqlclient14 libmysqlclient15off libnet-daemon-perl
      libplrpc-perl mysql-client mysql-client-5.0 mysql-common mysql-server mysql-server-5.0
    0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded.
    Need to get 39.4MB of archives.
    After unpacking 103MB of additional disk space will be used.
    Do you want to continue? [Y/n] y
    Get:1 http://ftp.si.debian.org stable/main libnet-daemon-perl 0.38-1 [46.0kB]
    Get:2 http://dotdeb.pimpmylinux.org stable/all mysql-common 5.0.32-1.dotdeb.1 [51.9kB]
    Get:3 http://ftp.si.debian.org stable/main libplrpc-perl 0.2017-1 [35.0kB]
    Get:4 http://ftp.si.debian.org stable/main libdbi-perl 1.46-6 [606kB]
    Get:5 http://dotdeb.pimpmylinux.org stable/all libmysqlclient14 4.1.15-0.dotdeb.4 [1206kB]
    Get:6 http://ftp.si.debian.org stable/main libmysqlclient12 4.0.24-10sarge2 [297kB]
    Get:7 http://ftp.si.debian.org stable/main libmysqlclient12-dev 4.0.24-10sarge2 [2922kB]
    Get:8 http://dotdeb.pimpmylinux.org stable/all libdbd-mysql-perl 2.9007-0.dotdeb.0 [133kB]
    Get:9 http://dotdeb.pimpmylinux.org stable/all libmysqlclient15off 5.0.32-1.dotdeb.1 [1774kB]
    Get:10 http://dotdeb.pimpmylinux.org stable/all mysql-client-5.0 5.0.32-1.dotdeb.1 [7087kB]
    Get:11 http://dotdeb.pimpmylinux.org stable/all mysql-server-5.0 5.0.32-1.dotdeb.1 [25.2MB]
    Get:12 http://dotdeb.pimpmylinux.org stable/all mysql-client 5.0.32-1.dotdeb.1 [43.4kB]
    Get:13 http://dotdeb.pimpmylinux.org stable/all mysql-server 5.0.32-1.dotdeb.1 [45.5kB]
    Fetched 39.4MB in 1m53s (348kB/s)
    Preconfiguring packages ...
    Selecting previously deselected package mysql-common.
    (Reading database ... 22341 files and directories currently installed.)
    Unpacking mysql-common (from .../mysql-common_5.0.32-1.dotdeb.1_all.deb) ...
    Selecting previously deselected package libnet-daemon-perl.
    Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1_all.deb) ...
    Selecting previously deselected package libplrpc-perl.
    Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1_all.deb) ...
    Selecting previously deselected package libdbi-perl.
    Unpacking libdbi-perl (from .../libdbi-perl_1.46-6_i386.deb) ...
    Selecting previously deselected package libmysqlclient14.
    Unpacking libmysqlclient14 (from .../libmysqlclient14_4.1.15-0.dotdeb.4_i386.deb) ...
    Selecting previously deselected package libdbd-mysql-perl.
    Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_2.9007-0.dotdeb.0_i386.deb) ...
    Selecting previously deselected package libmysqlclient15off.
    Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.32-1.dotdeb.1_i386.deb) ...
    Selecting previously deselected package mysql-client-5.0.
    Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.32-1.dotdeb.1_i386.deb) ...
    Setting up mysql-common (5.0.32-1.dotdeb.1) ...
    Selecting previously deselected package mysql-server-5.0.
    (Reading database ... 22556 files and directories currently installed.)
    Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.32-1.dotdeb.1_i386.deb) ...
    Selecting previously deselected package libmysqlclient12.
    Unpacking libmysqlclient12 (from .../libmysqlclient12_4.0.24-10sarge2_i386.deb) ...
    Selecting previously deselected package mysql-client.
    Unpacking mysql-client (from .../mysql-client_5.0.32-1.dotdeb.1_all.deb) ...
    Selecting previously deselected package mysql-server.
    Unpacking mysql-server (from .../mysql-server_5.0.32-1.dotdeb.1_all.deb) ...
    Selecting previously deselected package libmysqlclient12-dev.
    Unpacking libmysqlclient12-dev (from .../libmysqlclient12-dev_4.0.24-10sarge2_i386.deb) ...
    Setting up libnet-daemon-perl (0.38-1) ...
    
    Setting up libplrpc-perl (0.2017-1) ...
    
    Setting up libdbi-perl (1.46-6) ...
    Setting up libmysqlclient14 (4.1.15-0.dotdeb.4) ...
    
    Setting up libdbd-mysql-perl (2.9007-0.dotdeb.0) ...
    Setting up libmysqlclient15off (5.0.32-1.dotdeb.1) ...
    
    Setting up mysql-client-5.0 (5.0.32-1.dotdeb.1) ...
    Setting up mysql-server-5.0 (5.0.32-1.dotdeb.1) ...
    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld.
    .
    Checking for corrupt, not cleanly closed and upgrade needing tables.
    
    Setting up libmysqlclient12 (4.0.24-10sarge2) ...
    
    Setting up mysql-client (5.0.32-1.dotdeb.1) ...
    Setting up mysql-server (5.0.32-1.dotdeb.1) ...
    Setting up libmysqlclient12-dev (4.0.24-10sarge2) ...
    
    Code:
    debian:~# netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
    tcp        0      0 *:smtp                  *:*                     LISTEN     4712/exim4
    tcp        1      1 debian.pc-storitv:32787 debian.camtp.uni-mb:www LAST_ACK   -
    tcp6       0      0 *:ssh                   *:*                     LISTEN     4988/sshd
    tcp6       0      0 *:smtp                  *:*                     LISTEN     4712/exim4
    tcp6       0      0 ::ffff:192.168.1.10:ssh ::ffff:192.168.0.1:1098 ESTABLISHED5037/sshd: root@not
    tcp6       0    148 ::ffff:192.168.1.10:ssh ::ffff:192.168.0.1:1097 ESTABLISHED5030/0
    tcp6       0      0 ::ffff:192.168.1.10:ssh ::ffff:192.168.0.1:1124 ESTABLISHED5042/sshd: root@not
    
     
  4. falko

    falko Super Moderator ISPConfig Developer

    That's normal.
    Please start MySQL:
    Code:
    /etc/init.d/mysql restart
     

Share This Page