Pengwin icon indicating copy to clipboard operation
Pengwin copied to clipboard

Can't install MariaDB/perlapi-5.24.1

Open mabdelfattah opened this issue 6 years ago • 16 comments

This could be linked to https://github.com/WhitewaterFoundry/WLinux/issues/186

$ sudo apt install perlapi-5.24.1 libdbi-perl mariadb-server-10.1 default-mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package perlapi-5.24.1 is a virtual package provided by:
  perl-base 5.24.1-3+deb9u4 [Not candidate version]

E: Package 'perlapi-5.24.1' has no installation candidate

mabdelfattah avatar Nov 19 '18 07:11 mabdelfattah

As the error suggests, perlapi-5.24.1 is provided by perl-base. Install perl-base instead of perlapi-5.24.1, and the problem should be solved.

patrick330602 avatar Nov 19 '18 07:11 patrick330602

@patrick330602 , of course, I did this before posting here :)

$ sudo apt-get install perl-base
Reading package lists... Done
Building dependency tree
Reading state information... Done
perl-base is already the newest version (5.28.0-3).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

mabdelfattah avatar Nov 19 '18 07:11 mabdelfattah

This is now very clear. As the information given, you are using Debian Testing where perl-base is on version 5.28.0-3 where perlapi-5.24.1 is provided by perl-base 5.24.1-3+deb9u4. You should following the guide to install MariaDB on Debian 10 instead of Debian 9.

patrick330602 avatar Nov 19 '18 09:11 patrick330602

@patrick330602 is there a way to move back/downgrade to Debian stretch so as I can use MySQL instead of MariaDB?

mabdelfattah avatar Nov 19 '18 10:11 mabdelfattah

I'm doing a new installation now and it already comes with test packages! image

mabdelfattah avatar Nov 19 '18 10:11 mabdelfattah

The reason you are getting that is that we have moved to Debian Testing in the latest version of WLinux.

There is a way to downgrade, but it will very likely end up with a broken system. Proceed with caution.

replace /etc/apt/sources.list with following content:

deb https://deb.debian.org/debian stable main contrib non-free
# deb-src https://deb.debian.org/debian stable main

deb https://deb.debian.org/debian stable-updates main
# deb-src https://deb.debian.org/debian stable-updates main

deb http://security.debian.org/debian-security/ stable/updates main
# deb-src http://security.debian.org/debian-security/ stable/updates main

deb https://deb.debian.org/debian stretch-backports main
# deb-src https://deb.debian.org/debian stretch-backports main

deb https://deb.debian.org/debian testing main contrib non-free
# deb-src https://deb.debian.org/debian testing main

deb https://apt.patrickwu.space/ stable main
# obtain source from https://github.com/wslutilities/wslu

replace /etc/apt/preferences with following:

Package: *
Pin: release a=stable
Pin-Priority: 990

Package: *
Pin: release a=backports
Pin-Priority: -1

Package: *
Pin: release a=testing
Pin-Priority: 501

then run following code to downgrade:

sudo apt update
sudo apt upgrade
sudo apt dist-upgrade

I would suggest you to use Debian if you want to install exactly that version of MariaDB.

patrick330602 avatar Nov 19 '18 12:11 patrick330602

I'm sorry to disappoint you, but I tried this and it did not work.

I'll try with a new installation without running the wlinux-setup. As, I think wlinux-setup installs the testing libraries automatically

mabdelfattah avatar Nov 19 '18 12:11 mabdelfattah

This is very interesting. The only option that uses testing branch in wlinux-setup is Neovim and python 3.7. Have you installed them?

patrick330602 avatar Nov 19 '18 12:11 patrick330602

Yes, that's why I want to give it one more try before installing any other packages and without wlinux-setup too.

mabdelfattah avatar Nov 19 '18 13:11 mabdelfattah

Patrick is correct, in 1.1.25 we moved to from mostly stable and some testing to 100% testing. This was done to avoid packaging mixing, which was causing problems, and to provide newer packages, which was one of the complaints we regularly recieved.

sirredbeard avatar Nov 20 '18 12:11 sirredbeard

I just purchased pengwin a couple days ago, and it's awesome, but lamp is not working.

Starting pengwin-setup.
Updating package database
Running upgrade check...
Holding pengwin-base & pengwin-setup to ensure no changes while operating
Selected: SERVICES
SERVICES
LAMP
MariaDB Choice for LAMP Stack
Installing MariaDB Database Server
Running apt-get update...
Hit:3 https://deb.debian.org/debian bullseye InRelease
Hit:2 https://packagecloud.io/whitewaterfoundry/pengwin-base/debian bullseye InRelease
Hit:4 https://deb.debian.org/debian bullseye-updates InRelease
Hit:6 https://deb.debian.org/debian-security bullseye-security InRelease
Hit:7 https://deb.debian.org/debian stable InRelease
Hit:1 https://downloads.mariadb.com/MariaDB/mariadb-10.5/repo/debian buster InRelease
Hit:5 https://packagecloud.io/whitewaterfoundry/pengwin-setup/debian bullseye InRelease
Hit:8 https://packagecloud.io/whitewaterfoundry/wslu/debian bullseye InRelease
Reading package lists...
Done adding trusted package signing keys
Reading package lists...
Building dependency tree...
Reading state information...
software-properties-common is already the newest version (0.96.20.2-2.1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Hit:3 https://deb.debian.org/debian bullseye InRelease
Hit:2 https://packagecloud.io/whitewaterfoundry/pengwin-base/debian bullseye InRelease
Hit:5 https://deb.debian.org/debian bullseye-updates InRelease
Hit:7 https://deb.debian.org/debian-security bullseye-security InRelease
Hit:8 https://deb.debian.org/debian stable InRelease
Hit:6 https://packagecloud.io/whitewaterfoundry/pengwin-setup/debian bullseye InRelease
Hit:1 https://downloads.mariadb.com/MariaDB/mariadb-10.5/repo/debian buster InRelease
Hit:9 https://packagecloud.io/whitewaterfoundry/wslu/debian bullseye InRelease
Get:4 https://downloads.mariadb.com/MariaDB/mariadb-10.2/repo/debian buster InRelease [2,421 B]
Get:10 https://downloads.mariadb.com/MariaDB/mariadb-10.2/repo/debian buster/main amd64 Packages [11.9 kB]
Fetched 14.3 kB in 3s (4,329 B/s)
Reading package lists...
Reading package lists...
Building dependency tree...
Reading state information...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 libdbi-perl : Depends: perlapi-5.28.1
E: Unable to correct problems, you have held broken packages.
mariadb-server:
  Installed: (none)
  Candidate: 1:10.5.11+maria~buster
  Version table:
     1:10.5.11+maria~buster 500
        500 http://downloads.mariadb.com/MariaDB/mariadb-10.5/repo/debian buster/main amd64 Packages
     1:10.5.10+maria~buster 500
        500 http://downloads.mariadb.com/MariaDB/mariadb-10.5/repo/debian buster/main amd64 Packages
     1:10.5.10-2 500
        500 https://deb.debian.org/debian bullseye/main amd64 Packages
     1:10.5.9+maria~buster 500
        500 http://downloads.mariadb.com/MariaDB/mariadb-10.5/repo/debian buster/main amd64 Packages
     1:10.3.29-0+deb10u1 500
        500 https://deb.debian.org/debian stable/main amd64 Packages
     10.2.22+maria~buster 500
        500 http://downloads.mariadb.com/MariaDB/mariadb-10.2/repo/debian buster/main amd64 Packages
mariadb: unrecognized service
Installing Apache Web Server
Reading package lists...
Building dependency tree...
Reading state information...
apache2 is already the newest version (2.4.48-3).
apache2-utils is already the newest version (2.4.48-3).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Starting Apache httpd web server: apache2(98)Address already in use: AH00072: make_sock: could not bind to address [::]:80
(98)Address already in use: AH00072: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
AH00015: Unable to open logs
Action 'start' failed.
The Apache error log may have more information.
.
Server version: Apache/2.4.48 (Debian)
Server built:   2021-06-20T14:39:33
apache2 is not running ... failed!
Installing PHP
Reading package lists...
Building dependency tree...
Reading state information...
libapache2-mod-php is already the newest version (2:7.4+76).
php is already the newest version (2:7.4+76).
php-bcmath is already the newest version (2:7.4+76).
php-cli is already the newest version (2:7.4+76).
php-common is already the newest version (2:76).

Installing LAMP as a service
#!/bin/bash

mysql_status=$(service mysql status)
if [[ ${mysql_status} = *"is stopped"* ]]; then
  service mysql --full-restart > /dev/null 2>&1
fi

apache2_status=$(service apache2 status)
if [[ ${apache2_status} = *"is not running"* ]]; then
  service apache2 --full-restart > /dev/null 2>&1
fi

%sudo   ALL=NOPASSWD: /usr/bin/start-lamp
#!/bin/bash

# Check if we have Windows Path
if ( which cmd.exe >/dev/null ); then

  sudo /usr/bin/start-lamp

fi

Any idea?

jacksun101 avatar Jul 11 '21 15:07 jacksun101

Hello @jacksun101,

Thanks for reporting, we will check and answer you shortly.

Regards, Carlos

crramirez avatar Jul 11 '21 19:07 crramirez

The hotfix is on the way. Meanwhile run this:

sudo apt install libdbi-perl

then run pengwin-setup again

crramirez avatar Jul 11 '21 21:07 crramirez

Hello,

The release 21.7.0 includes a fix for that. Update with pengwin-setup update

Please test it.

Regards, Carlos

crramirez avatar Jul 14 '21 13:07 crramirez

Thanks for the fix. I just tried from a new pengwin instance for the lamp feature. All look good, except the last message.

Creating config file /etc/php/7.4/fpm/php.ini with new version
NOTICE: Not enabling PHP 7.4 FPM by default.
NOTICE: To enable PHP 7.4 FPM in Apache2 do:
NOTICE: a2enmod proxy_fcgi setenvif
NOTICE: a2enconf php7.4-fpm
NOTICE: You are seeing this message because you have apache2 package installed.
invoke-rc.d: could not determine current runlevel

Installing LAMP as a service
#!/bin/bash

mysql_status=$(service mysql status)
if [[ ${mysql_status} = *"is stopped"* ]]; then
  service mysql --full-restart > /dev/null 2>&1
fi

apache2_status=$(service apache2 status)
if [[ ${apache2_status} = *"is not running"* ]]; then
  service apache2 --full-restart > /dev/null 2>&1
fi

%sudo   ALL=NOPASSWD: /usr/bin/start-lamp
#!/bin/bash

# Check if we have Windows Path
if ( which cmd.exe >/dev/null ); then

  sudo /usr/bin/start-lamp

fi

/usr/local/pengwin-setup.d/lamp.sh: line 123: /etc/profile.d/start-lamp.sh: Permission denied
Unholding pengwin-base & pengwin-setup

jacksun101 avatar Jul 18 '21 01:07 jacksun101

OK if you close and open pengwin it should be working now. I will check why the last message is appearing.

Thanks for testing

crramirez avatar Jul 18 '21 11:07 crramirez