slpkg has disappeared?

NaboHipersonico · 09-25-2022, 12:44 PM

Hello, I have installed slpkg and all its dependencies, but I can't make it work, I don't know if it doesn't exist anymore or if I have a problem, I follow these steps:

https://ayudalinux.com/slpkg-package-manager/

And when I do slpk update, I get all this:

bash-5.1# slpkg update
Traceback (most recent call last):
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
return fn()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 320, in connect
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 884, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 486, in checkout
rec = pool._do_get()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get
return self._create_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 266, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 381, in __init__
self.__connect()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 673, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/sbin/slpkg", line 5, in <module>
from slpkg.main import main
File "/usr/lib64/python3.9/site-packages/slpkg/main.py", line 8, in <module>
from slpkg.checks import Check
File "/usr/lib64/python3.9/site-packages/slpkg/checks.py", line 8, in <module>
from slpkg.queries import SBoQueries
File "/usr/lib64/python3.9/site-packages/slpkg/queries.py", line 9, in <module>
from slpkg.models.models import SBoTable
File "/usr/lib64/python3.9/site-packages/slpkg/models/models.py", line 53, in <module>
Base.metadata.create_all(engine)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/schema.py", line 4917, in create_all
bind._run_ddl_visitor(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3227, in _run_ddl_visitor
with self.begin() as conn:
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3143, in begin
conn = self.connect(close_with_result=close_with_result)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3315, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3394, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3364, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2198, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
return fn()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 320, in connect
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 884, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 486, in checkout
rec = pool._do_get()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get
return self._create_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 266, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 381, in __init__
self.__connect()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 673, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: https://sqlalche.me/e/14/e3q8)
bash-5.1#

Thank you

Cheers

marav · 09-25-2022, 01:10 PM

https://slackbuilds.org/repository/15.0/system/slpkg/

NaboHipersonico · 09-25-2022, 01:17 PM

Hello. If I have already installed that, as I said at the beginning of the post, install it like this:

sbopkg -i “greenlet SQLAlchemy slpkg”

I'd say don't leave me any dependencies, so that's not the problem.

henca · 09-25-2022, 01:36 PM

I just tried "slpkg update" and it works fine here...

Code:

bash-4.3# slpkg update

Check and update repositories:

Check repository [slack] ... 
[1/1][ Download ] --> PACKAGES.TXT

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:51--  https://mirrors.slackware.com/slackware/slackware64-14.2/PACKAGES.TXT
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://ftpmirror.infania.net/slackware/slackware64-14.2/PACKAGES.TXT [following]
--2022-09-25 20:30:51--  https://ftpmirror.infania.net/slackware/slackware64-14.2/PACKAGES.TXT
Resolving ftpmirror.infania.net... 193.234.108.92
Connecting to ftpmirror.infania.net|193.234.108.92|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 704195 (688K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/core/PACKAGES.TXT'

PACKAGES.TXT        100%[===================>] 687.69K  1.56MB/s    in 0.4s    

2022-09-25 20:30:52 (1.56 MB/s) - '/var/lib/slpkg/slack_repo/core/PACKAGES.TXT' saved [704195/704195]


[1/1][ Download ] --> CHECKSUMS.md5

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:52--  https://mirrors.slackware.com/slackware/slackware64-14.2/CHECKSUMS.md5
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 998585 (975K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/core/CHECKSUMS.md5'

CHECKSUMS.md5       100%[===================>] 975.18K   734KB/s    in 1.3s    

2022-09-25 20:30:54 (734 KB/s) - '/var/lib/slpkg/slack_repo/core/CHECKSUMS.md5' saved [998585/998585]


[1/1][ Download ] --> PACKAGES.TXT

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:54--  https://mirrors.slackware.com/slackware/slackware64-14.2/extra/PACKAGES.TXT
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://ftpmirror.infania.net/slackware/slackware64-14.2/extra/PACKAGES.TXT [following]
--2022-09-25 20:30:54--  https://ftpmirror.infania.net/slackware/slackware64-14.2/extra/PACKAGES.TXT
Resolving ftpmirror.infania.net... 193.234.108.92
Connecting to ftpmirror.infania.net|193.234.108.92|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 32241 (31K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/extra/PACKAGES.TXT'

PACKAGES.TXT        100%[===================>]  31.49K  --.-KB/s    in 0.02s   

2022-09-25 20:30:55 (1.80 MB/s) - '/var/lib/slpkg/slack_repo/extra/PACKAGES.TXT' saved [32241/32241]


[1/1][ Download ] --> CHECKSUMS.md5

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:55--  https://mirrors.slackware.com/slackware/slackware64-14.2/extra/CHECKSUMS.md5
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 32347 (32K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/extra/CHECKSUMS.md5'

CHECKSUMS.md5       100%[===================>]  31.59K  --.-KB/s    in 0.1s    

2022-09-25 20:30:55 (248 KB/s) - '/var/lib/slpkg/slack_repo/extra/CHECKSUMS.md5' saved [32347/32347]


[1/1][ Download ] --> PACKAGES.TXT

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:55--  https://mirrors.slackware.com/slackware/slackware64-14.2/pasture/PACKAGES.TXT
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3834 (3.7K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/pasture/PACKAGES.TXT'

PACKAGES.TXT        100%[===================>]   3.74K  --.-KB/s    in 0s      

2022-09-25 20:30:56 (2.05 GB/s) - '/var/lib/slpkg/slack_repo/pasture/PACKAGES.TXT' saved [3834/3834]


[1/1][ Download ] --> CHECKSUMS.md5

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:56--  https://mirrors.slackware.com/slackware/slackware64-14.2/pasture/CHECKSUMS.md5
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4867 (4.8K) [text/plain]
Saving to: '/var/lib/slpkg/slack_repo/pasture/CHECKSUMS.md5'

CHECKSUMS.md5       100%[===================>]   4.75K  --.-KB/s    in 0s      

2022-09-25 20:30:56 (2.39 GB/s) - '/var/lib/slpkg/slack_repo/pasture/CHECKSUMS.md5' saved [4867/4867]


[1/1][ Download ] --> ChangeLog.txt

URL transformed to HTTPS due to an HSTS policy
--2022-09-25 20:30:56--  https://mirrors.slackware.com/slackware/slackware64-14.2/ChangeLog.txt
Resolving mirrors.slackware.com... 207.223.116.213
Connecting to mirrors.slackware.com|207.223.116.213|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 673757 (658K) [text/plain]
Saving to: '/var/log/slpkg/slack/ChangeLog.txt'

ChangeLog.txt       100%[===================>] 657.97K   681KB/s    in 1.0s    

2022-09-25 20:30:58 (681 KB/s) - '/var/log/slpkg/slack/ChangeLog.txt' saved [673757/673757]

Done
Check repository [sbo] ... Done

bash-4.3# echo $?
0
bash-4.3#

However, I only have slack and sbo enabled in slpkg. What does your /etc/slpkg/repositories.conf look like? Also what does your /etc/slpkg/slpkg.conf look like?

regards Henrik

NaboHipersonico · 09-25-2022, 01:48 PM

Hello, I put what you ask me, I knew the first one, the second I didn't, surely it came from there, because I didn't get to edit that file.

nano /etc/slpkg/repositories.conf

sbo
slack
alien
# rlw
# studio
# slacky
# slackr
# slonly
# multi
# ktown{latest}
# slacke{18}
salix
# rested
# slackl
rested msb{1.10}

nano /etc/slpkg/slpkg.conf

# Configuration file for slpkg
#
# slpkg.conf file is part of slpkg.
#
# Copyright 2014-2018 Dimitris Zlatanidis <d.zlatanidis@gmail.com>
# All rights reserved.
#
# Slpkg is a user-friendly package manager for Slackware installations.
#
# https://github.com/dslackw/slpkg
#
# Slpkg is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
# END OF LEGAL NOTICE
#
# ----------------------------------------------------------------------------
# Set Slackware release "stable" or "current". Default is "stable".
RELEASE=stable

# Set Slackware version if it's necessary. Default is "off".
SLACKWARE_VERSION=off

# Set computer architecture if it's necessary. Default is "off".
COMP_ARCH=off

# Build directory for repository "sbo" slackbuilds.org. In this
# directory downloaded sources and scripts for building.
# Default is "/tmp/slpkg/build/".
BUILD_PATH=/tmp/slpkg/build/

# Alternative source downloads for the "sbo" repository. Default is "off".
SBOSRCARCH=off
SBOSRCARCH_LINK=http://slackware.uk/sbosrcarch/by-name/

# Download directory for others repositories that use binaries files
# for installation. Default is "/tmp/slpkg/packages/"
PACKAGES=/tmp/slpkg/packages/

# Download directory for Slackware patches file.
PATCHES=/tmp/slpkg/patches/

# If CHECKMD5 is "on" the system will check all downloaded
# sources and Slackware packages. Default is "on".
CHECKMD5=on

# Delete all downloaded files if DEL_ALL is "on". Default is "on".
DEL_ALL=on

# Delete build directory after each process if DEL_BUILD is "on".
# Settings for the repository "sbo" slackbuilds.org. Default is "off".
DEL_BUILD=off

# Keep build log file if SBO_BUILD_LOG is "on". Default is "on".
SBO_BUILD_LOG=on

# Speed up SlackBuild scripts. If "on" slpkg auto detect the numbers of
# processor and apply into MAKEFLAGS variable. Some SlackBuilds fail if
# MAKEFLAGS is declared or the number of processors (-j <n>) is greater
# than one. Default if "off".
MAKEFLAGS=off

# Define default answer to slpkg questions.
# Choose "y" if you do not want to questions. Default is "n".
DEFAULT_ANSWER=n

# Define default answer for the removal of dependencies.
# Choose "y" if you do not want to question. Default is "n".
REMOVE_DEPS_ANSWER=n

# If you want build UNSUPPORTED or UNTESTED packages choose "y".
# Settings for the repository "sbo" slackbuilds.org. Default is "n".
SKIP_UNST=n

# If you want to disable automatic resovle dependencies choose "off".
# Default is "on".
RSL_DEPS=on

# Delete package dependencies if DEL_DEPS is on.
# You must be careful if you enable this option because it can remove
# packages related to distribution. Default is "off".
DEL_DEPS=off

# Use colors for highlighting. Choose "on" or "off". Default is "on".
USE_COLORS=on

# Downloader utility. Four options are supported "wget", "aria2c",
# "curl" and "http" (HTTPie). Default is "wget".
DOWNDER=wget

# Downloader [OPTION]. Pass downloader options, for curl use "-L -o" as
# using to download in specific directory and support any redirects
# such as from sourceforge repository. No extra option need for aria2c
# by default to work. Http recommended "-d -c -o" options by default.
# Default for wget is "-c -N".
DOWNDER_OPTIONS=-c -N

# Update slackpkg ChangeLog.txt file if SLACKPKG_LOG is "on".
# Automatically synchronizes the command "slackpkg update" with
# "slpkg -c slack --upgrade". Default is "on".
SLACKPKG_LOG=on

# This option applies only to the distribution upgrade and repository
# slack (Slackware). If you want to update only packages that are installed
# choose "on". Default is "off".
# NOTE: This option is not recommended at "on" because it can leave out
# packages required for distribution.
ONLY_INSTALLED=off

# Enable or disable the progress bar. Status bar progress delays the search
# process in package lists. Default is "off".
PRG_BAR=off

# Register a text editor that uses the slpkg in a few options.
# Default is "nano".
EDITOR=nano

# If you don't want slpkg downgrade packages, setting this variable to "on".
# Warning: Possible failure building packages or running applications after
# install. Default is "off".
NOT_DOWNGRADE=off

Thanks. Cheers

montagdude · 09-25-2022, 08:24 PM

I don't know anything about slpkg, but this error seems to be your problem:

Code:

sqlite3.OperationalError: unable to open database file

Again, I don't know anything about slpkg, so I don't know where this database file is supposed to be. Can you check that it exists and has read permissions?

fourtysixandtwo · 09-26-2022, 12:04 AM

There was a problem reported on LQ with slpkg 4.1.4 a few weeks ago, but testing it now, it seems to be working fine.

There is a 4.1.5 on his website you can try or downgrade to 4.1.3.

henca · 09-26-2022, 01:49 AM

Quote:

Originally Posted by NaboHipersonico

nano /etc/slpkg/repositories.conf

sbo
slack
alien
# rlw
# studio
# slacky
# slackr
# slonly
# multi
# ktown{latest}
# slacke{18}
salix
# rested
# slackl
rested msb{1.10}

Ok, I only have the slack and sbo repositories enabled myself. What if you use

Code:

slpkg repo-enable

...to disable salix, rested, msb{1.10} and alien? Does it work better then?

Also, rested and msb{1.10} should probably be on separate rows.

regards Henrik

NaboHipersonico · 09-26-2022, 02:34 PM

Hello, thank you all very much for your answers.

Quote:

Originally Posted by montagdude

I don't know anything about slpkg, but this error seems to be your problem:

Code:

sqlite3.OperationalError: unable to open database file

Again, I don't know anything about slpkg, so I don't know where this database file is supposed to be. Can you check that it exists and has read permissions?

I don't know how it looks if it's installed and working, so I took it and installed it with slackbuilds, it wasn't installed, but it still gives the same error.

Keep investigating.

NaboHipersonico · 09-26-2022, 02:35 PM

Quote:

Originally Posted by fourtysixandtwo

There was a problem reported on LQ with slpkg 4.1.4 a few weeks ago, but testing it now, it seems to be working fine.

There is a 4.1.5 on his website you can try or downgrade to 4.1.3.

Interesting I will try one and another version and I will tell you.

Thanks.

NaboHipersonico · 09-26-2022, 03:33 PM

Quote:

Originally Posted by henca

Ok, I only have the slack and sbo repositories enabled myself. What if you use

Code:

slpkg repo-enable

...to disable salix, rested, msb{1.10} and alien? Does it work better then?

Also, rested and msb{1.10} should probably be on separate rows.

regards Henrik

Hello, I do everything you say and it still happens exactly the same.

I will investigate with other versions to see.

Thanks.

Greetings.

fourtysixandtwo · 09-27-2022, 10:02 PM

Looked into it further and tried it on a fresh VM where it did not work. Try the following:

Code:

mkdir -p /var/lib/slpkg/{database,repository}

Makes sense given the error of not being able to open the database.

adcdam · 09-27-2022, 10:21 PM

Quote:

Originally Posted by fourtysixandtwo

Looked into it further and tried it on a fresh VM where it did not work. Try the following:

Code:

mkdir -p /var/lib/slpkg/{database,repository}

Makes sense given the error of not being able to open the database.

Hi,i was having the same problem, i really don´t use slpkg (i use slackpkg+ and sbopkg) but after seeing this post i installed to test it.
Creating those directories fixed the problem
edit: at least now the program start, but im not 100% sure if slpkg work as it should. I removed slpkg and i will continue using slackpkg+ and sbopkg

NaboHipersonico · 09-28-2022, 04:38 AM

Quote:

Originally Posted by adcdam

Hi,i was having the same problem, i really don´t use slpkg (i use slackpkg+ and sbopkg) but after seeing this post i installed to test it.
Creating those directories fixed the problem
edit: at least now the program start, but im not 100% sure if slpkg work as it should. I removed slpkg and i will continue using slackpkg+ and sbopkg

Hello. It does not work. Yes, when doing the directory thing and doing slpkg update, it updates, but then when you install programs it doesn't work well, I've tried installing the king of dependencies, vlc and it seems to install it, it doesn't give an error or anything, but it doesn't finish installing.

I've tried something smaller xfburn which has only one dependency and it doesn't install either and to be sure I've installed both vlc and xfburn with sqg and it installed everything like a champ.

I consider the issue resolved, because it was to have more installation options, the issue is that before I didn't know that sqg existed and then I installed all the dependencies by hand with sbopkg as follows: sbopkg -i "greenlet SQLAlchemy slpkg" and well, no you die, but imagine installing vlc like this, with sqg it's wonderful, so I'll use sqg to install since it works very well because it solves the dependencies and after all it's what I was looking for with slpkg.

Thanks for everything.

Greetings.