Re: How can I find packages manually installed using "dpkg -i"?

[David Wright]

On Mon 02 Oct 2023 at 16:00:57 (+0200), to...@tuxteam.de wrote:
> On Mon, Oct 02, 2023 at 09:52:39AM -0400, Greg Wooledge wrote:
> > On Mon, Oct 02, 2023 at 09:43:39AM -0400, The Wanderer wrote:
> > > On 2023-10-02 at 09:28, Ottavio Caruso wrote:
> > > > Yeah, the one for which I had to manually use "dpkg -i".
> > > 
> > > That information is not tracked.
> > > 
> > > What is tracked is "the package versions known to be available from each
> > > registered repository" and "the package versions which are installed".
> > 
> > There *is* tracking.  Packages can be marked as "automatically installed"
> > or not.  The problem is, the marking is not consistent with user
> > expectations.
> 
> But not if you use dpkg directly (dpkg doesn't even resolve dependencies,
> but just gives up when some aren't met). That's why I proposed comparing
> apt logs and dpkg logs -- things in the latter but not in the former were
> probably installed with straight dpkg.
> 
> It probably ain't straightforward, though. And the logs might have been
> rotated out anyway.

If you have complete logs and try this, presumably coming up with a
sorted list of apt-installed packages (remembering --unique) from its
history, and a similar list from the ' install ' lines in dpkg.log*,
bear in mind that you need to ignore the dpkg.log until about when
locales is installed, as APT never sees a load of packages installed
before that point.

Also be careful if you're tempted to sort dpkg.log's install lines
by time, instead of grepping the logs in the correct (non-collating)
order, because for people in the western hemisphere, the packages you
want to ignore will have UTC timestamps, placing them in the midst
of packages installed after the d-i has finished. (The timestamps
jump from UTC to localtime after locales is installed.)

To avoid all these complications in future, I would suggest that the
OP (and anybody else) modify their logrotate configuration files thus:

  $ grep rotate /etc/logrotate.d/{apt,dpkg}
  /etc/logrotate.d/apt:  rotate -1
  /etc/logrotate.d/apt:  rotate -1
  /etc/logrotate.d/dpkg:  rotate -1
  $ 

and jettison  dpkg -i  in favour of:  apt install /path/to/some.deb
where the /path/to/ is essential even if it's only ./some.deb.

With those changes, it will be easy to spot these particular packages
just by grepping .deb$ (strictly, \.deb$) in …/apt/history.log*.

Cheers,
David.

Re: XFCE4 without panels

[Mike Castle]

I just tried this in a VM and it seemed to work.

>From a command line:
xfce4-panel -q
find ~/.config | grep panel

Remove the xfce4-panel.xml   (I also removed the empty directory just
named panel.)

The lack of panels seems to have survived a reboot.

I don't know if it is sufficient for every variation involving saving
session state or what not.  But might get you started in the right
direction.

If worst comes to pass, you might be able to put the xfce4-panel -q
command in a shell script that automatically launches when you log in.

Good luck!
mrc

Re: swap-fle on arm64, need to disable, how?

[Max Nikulin]

On 02/10/2023 03:01, hw wrote:

Once you figured
it out, you add sufficent amounts of RAM and use zram.


Is it possible for *Pi boards? Even laptops may have soldered RAM with 
no spare slots.


ZRAM may be fast, but if you need, say +2G in comparison to physical RAM 
size, the chance of success is fair in the case of RAM size of 16G. If a 
board has just 2G of RAM then you need to be really lucky to get extra 
2G by compression.


Perhaps Gene's setup is no optimal, but swap on SSD, despite its 
disadvantages, may be an alternative to using a more performant board 
for building of applications.

Re: Debian live boot corrupting secure boot

[Jeffrey Walton]

On Thu, Sep 28, 2023 at 12:10 AM Valerio Vanni  wrote:
>
> On Wed, 27 Sep 2023 09:54:31 +0700 Max Nikulin  wrote:
> > I found the issue on latest versions of Clonezilla, but then I tried
> >
> >^^
> > with plain Debian live and the behavior is the same.
> >
> > Does it mean that you can not boot your *old* Clonezilla live after booting 
> > a latest Clonezilla? If so, it is better to discuss the issue with shim or 
> > grub developers.
>
> Yes. If I load a Clonezilla live newer than 3.1.0-11, then I cannot boot
> anymore 2.8.1-12.

I would probably bet if you booted to Windows, the OS would check the
Forbidden Signature/Secure Boot DBX and (re)apply KB5012170 [0] as
required.

So you are probably going to have to deal with this sooner rather than
later. Both OSes are going to try to update the database with
signatures of the bad grub programs. Or I would not bet against it.

Jeff

[0] 
https://support.microsoft.com/en-gb/topic/kb5012170-security-update-for-secure-boot-dbx-72ff5eed-25b4-47c7-be28-c42bd211bb15

Same Debian, different hardware = different OpenGL version?

[Anders Andersson]

I recently installed Debian stable on my old desktop and my trusty old
Thinkpad X200, without messing with any driver settings. Both are
running the default gnome desktop with the same kernel.

I installed the terminal emulator 'kitty' from the main repository on
both machines but it only works on my desktop.

The relevant bug report for kitty
(https://github.com/kovidgoyal/kitty/issues/2536) tells me that kitty
requires OpenGL 3.3, and to check with "glxinfo | grep OpenGL
version".

On my desktop I get: OpenGL version string: 4.6 (Compatibility
Profile) Mesa 22.3.6
On my thinkpad: OpenGL version string: 2.1 Mesa 22.3.6

Is there anything I can do about this using open source drivers? I
don't know enough about OpenGL, if it's a software issue or if it's
simply that the old intel GPU in the Thinkpad X200 can not work with
new OpenGL, while the AMD RX460 in my desktop can?

Re: btrfs snapshots (of root file system)?

[Anders Andersson]

On Sun, Oct 1, 2023 at 7:20 AM hw  wrote:
>
> Hi,

Hello! I'm not going into much detail but maybe I can guide you to
better be able to find what you want.

> with btrfs, how do I make a snapshot of the root file system?  The
> purpose is to update software and being able to go back to a previous
> state if necessary.
>
> There doesn't seem to be a command to create snapshots but only
> subvolumes?  How does a subvolume turn into a snapshot?  (The root
> file system is, of course, not on a subvolume.)

Everything in btrfs is a suvolume, including the root (aka
"top-level"). A snapshot is merely a subvolume created *from* another
subvolume, and can optionally be read-only.

You can take a snapshot of the top level subvolume by doing "btrfs sub
snap / @foo". Documentation for creating both empty subvolumes and
snapshots are in btrfs-subvolume.

> How do I merge snapshots?  IIRC, when you remove a ZFS snapshot, the
> older state is merged to the state the snapshot is in.  Apparently
> btrfs can only delete snapshots --- and it seems like a bad idea to
> delete the root file system.  How would I boot from it when it's been
> deleted?

I don't think you can merge snapshots the way you describe. I don't
see how it could be atomic? You can however move subvolumes around
freely, create new snapshots at will, and select the boot subvolume
either by the "subvol=" mount option or by setting the default
subvolume (btrfs sub set-default).

> Can I make a snapshot on a different volume?  The manpage doesn't say
> that the destination of a subvolume must be on the same volume, and in
> any case, I should be able to do that.

You can create snapshots anywhere *within the same filesystem*. To be
fair, the manpage says "A BTRFS subvolume is a part of filesystem" and
"A snapshot is also subvolume". It could be more clear.

Re: systemctl status mariadb - Access denied for user root at localhost using password NO

[Andy Smith]

Hello,

On Mon, Oct 02, 2023 at 04:45:25PM +0300, Petros Pap wrote:
> root@server:~# mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)

I believe that the Debian packaging of MariaDB is by default set up
to allow socket authentication for root@localhost so that any root
process can connect to root@localhost through the socket without
supplying a password. I also believe that this is required for
correct functioning of the packaging.

If that no longer works for you, then you or something you ran must
have changed it.

> Can you please advise me what to do?

You should re-enable socket authentication for root@localhost.

If you also need to have things connect to root@localhost by
password then I believe you can allow socket OR password auth. A
simple search will tell you how to do this in MariaDB.

Thanks,
Andy

-- 
https://bitfolk.com/ -- No-nonsense VPS hosting

Re: Debian live boot corrupting secure boot

[Valerio Vanni]

Il 02/10/2023 18:45, Max Nikulin ha scritto:

At least a warning "I'm going to blacklist something, do you want to 
continue?".


It is just speculation. To show a warning you need to execute some code. 


Yes, but I would trust a code that asks before doing some potentially 
disruptive change.
I don't want to consider a live environment like a virus. I'd like to 
considere it the opposite, a "safe thing" that leaves thing untouched.


Yes, I do. My idea is to build custom image of old Clonezilla with 
EFI files signed by you own keys. The downside is that you need  to 
install your keys to every box where you are going to boot your images.


Doesn't seem practical. I am the mantainer of that disk image: I keep 
it updated, I keep it tested after updates and after modifications I 
get from applications' mantainers.


You may ask Clonezilla developers to make an image with old version and 
new grub-signed and shim-signed. I think, you even could do it yourself.


For now, it seems more practical to use old Clonezilla. I don't have 
such control on the deploying chain (i.e. what version other technician 
use), so I have to point towards compatibility.


For security: if Asus and Microsoft (usual "house owners") are happy 
with a certain blacklist, I don't feel myself culprit of "making the 
machine less secure" if i *don't load* a Linux version that blacklists 
older ones.


Don't forget that the only times I break secure boot is when I test news 
Clonezilla versions.


Now 2.8.1-12 works. It's fast, it loads without issues on the machines 
where I need it. In few words, it does its job. Perhaps it's also 
forward compatible (I didn't test with an image taken from the latest, 
for some version it was compatibile).


I still hope that performance issue is fixed in future releases, it's 
not wise taking for sure that 2.8.1-12 will work forever, on other 
machines etc. It could be that in 2 years a chipset not supported come out.


But during last week I changed my plan. Before was "start to use new 
Clonezilla as soon as it is fixed".

Now it's "Good when it's fixed, but I'll use 2.8 as long as it works".

But neither Asus (bios from start of September) nor Microsoft (Windows 
11) do that blacklisting.


Do you mean Windows install on hard drive or Windows install image?


Machine comes with Windows 10 pre installed, and then it's updated from 
Windows update. Then I installed Windows 11 with upgrade assistant.

So far, no blacklist of old Clonezilla.

Do you mean that installing Windows 10 or 11 from scratch could behave 
differently?


Notice, it is still just a hypothesis that your issues are caused by 
new keys and it has to be confirmed by comparison key lists before 
and after.


I'll try with
efibootmgr -v
when I have here another machine


This particular command lists boot entries (location of .efi file to 
boot), not secure boot keys. I mentioned it because I had an issue 
namely with boot entries. In your case they may be unaffected.


If firmware has the "EFI shell" option then you may try "bcfg boot dump 
-v". Unsure if it is possible to redirect output to a file.


I'll try. Is there nothing inside Linux efi tools?


I don't know if Clonezilla has this package installed,


Then you may try any other live image. Perhaps some of Debian live, 
grml, system rescue have necessary tools installed.


No, I want to see the condition without loading newer Linux versions.
Otherwise, I'd see the condition generated by that live.

Unless I find a "live as I like it" (meaning that doesn't alter secure 
boot).


Clonezilla come in many flavours, the main line is based on Debian 
(stable - testing) and the alternate one is based on Ubuntu (alternate 
stable - alternate testign).


I'll try also with a non related distribution, as you suggest.


I mean an image from Fedora, not Clonezilla based on Fedora.


Yes, it was clear.

Re: Debian live boot corrupting secure boot

[Max Nikulin]

On 30/09/2023 20:53, Valerio Vanni wrote:

Il 29/09/2023 05:39, Max Nikulin ha scritto:

That is why I am suggesting to check for discussions related to shim & 
grub and to ask people involved into their development.


I'll try. I don't feel confortable at the idea that a live environment 
could do such a change.


In general I agree with you, but some restrictions may exist.

At least a warning "I'm going to blacklist something, do you want to 
continue?".


It is just speculation. To show a warning you need to execute some code. 
However .efi file is considered unsafe due to unknown signature. I have 
no idea concerning origin of code that injects newer keys. It should be 
some special case for secure boot.


Yes, I do. My idea is to build custom image of old Clonezilla with EFI 
files signed by you own keys. The downside is that you need  to 
install your keys to every box where you are going to boot your images.


Doesn't seem practical. I am the mantainer of that disk image: I keep it 
updated, I keep it tested after updates and after modifications I get 
from applications' mantainers.


You may ask Clonezilla developers to make an image with old version and 
new grub-signed and shim-signed. I think, you even could do it yourself. 
Take an old image, put EFI, grub directories and kernel files from a new 
image. Perhaps adjust some config files if they include Clonezilla 
version. This way allows to avoid dealing with custom secure boot keys.


But neither Asus (bios from start of September) nor Microsoft (Windows 
11) do that blacklisting.


Do you mean Windows install on hard drive or Windows install image?

Notice, it is still just a hypothesis that your issues are caused by 
new keys and it has to be confirmed by comparison key lists before and 
after.


I'll try with
efibootmgr -v
when I have here another machine


This particular command lists boot entries (location of .efi file to 
boot), not secure boot keys. I mentioned it because I had an issue 
namely with boot entries. In your case they may be unaffected.


If firmware has the "EFI shell" option then you may try "bcfg boot dump 
-v". Unsure if it is possible to redirect output to a file.



I don't know if Clonezilla has this package installed,


Then you may try any other live image. Perhaps some of Debian live, 
grml, system rescue have necessary tools installed.


Clonezilla come in many flavours, the main line is based on Debian 
(stable - testing) and the alternate one is based on Ubuntu (alternate 
stable - alternate testign).


I'll try also with a non related distribution, as you suggest.


I mean an image from Fedora, not Clonezilla based on Fedora.

Re: Debian will not boot any more, wrong UUID

[Hans]

Am Montag, 2. Oktober 2023, 17:03:57 CEST schrieb Curt:
> On 2023-09-30, Hans  wrote:
> > Second: The setting of AHCI has disappeared, so I can not change the
> > settings in BIOS. And: the BIOS can not be reflashed!
> 
> I've read that on some Acer machines the procedure is:
> 
> 'Main' BIOS tab/ctrl+s (as suggested by Steve and Jeffrey)/toggle VMD
> Controller to [Disabled].

Hi Curt, 

tried both, but sadly no success. 

Thanks anyway!

Best regards

Hans

[SOLVED] Re: Debian will not boot any more, wrong UUID

[Hans]

Am Montag, 2. Oktober 2023, 10:42:42 CEST schrieb Steve McIntyre:
Hi Steve and all ones who helped me.

I had to search a solution for my problem and so I dind the following:

1. After I spoke to my customer, i installed Debian_12 to the second 
harddrive. And yes, it is a normal SSD and slower than the NVME-drive.

2. After it I accessed to the old partitions on the NVME under Windows. Here I 
am using Paragon drivers, to get access to the partitions. So I could rescue 
the old data and copied them to the new /home.

3. It appeared, that grub was now on the second drive and does NOT see windows 
any more. So I can not start Windows from the grub menu (os-prober in grub is 
activated, but does not see /dev/nvme and so not windows) The solution is, to 
boot via "F12" key which shows the BIOS option to choose, what to start. My 
customer agreed to this.

All in all, this solution is unsatisfied, but accepted by my friend (customer). 

Some important: During the installation, I discovered, that the BIOS was 
corrupted. The menu, where the boot line should be shown (1. Windows, 2. 
LinpusLite, 3. Debian) was completely crapped with random signs. 


Even "Load defaults" could not rescue it! More bad: I could not get into the 
BIOS any more with the F2-key. 

The trick: Using the grub menu and there the point: UEFI-settings I managed to 
get into the BIOS again, but the menu point was still no more existent. The 
screen was full with random signs.

After some reboots and removing from power, holding power button for 10 
seconds and some other things, this was suddenly ok again (luckyly!!!).

What shall I say? I suppose, the INSYDEH20 Bios is fully crap and should 
avoided in the future whenever possible.

Oh, and there is no way, to overwrite it, as the BIOS installer does only an 
upgrade, no overwrite. Yes, there is HOW20EZE, which you can edit the binaries 
and maybe give thme a highjer version. But you need specialo knowledge and it 
is dangerous and could brick your notebook completely. Thus I did not burn my 
fingers.

Ok, I found a solution, not for the problem, but for my friend. And I am sure, 
the cause of all these is the BIOS itself, Changed by Windows or changed by 
crap.

Again, thank you all for your help. I learnt again a lot (what is always 
important) and could see the reason.

This problem can be marked as solved. 

Best and happy hacking!

Hans 

> Hi Hans!
> 
> hans.ullr...@loop.de wrote:
> >In short; I tried (as most people tell): Starting windows in secure mode,
> >then boot into the BIOS and there set from RAID to AHCI, afterwards start
> >windows as normal.
> >
> >This setting in BIOS was existent some time ago, but now it is complete
> >gone (this point is completele disappeared!)!!  I know that it is in RAID,
> >because Windows told so: BUS form = RAID.
> 
> Right. I have one of these machines as a test box locally, and I think
> I know what the problem is.
> 
> The core issue is that the BIOS setup screen has a ridiculous
> mis-feature - it hides some BIOS entries from the user, with no
> indication that it has done so. On the model I have, it needs you to
> hit Ctrl-s on each of the BIOS setup screens to show them. I've read
> about other models where you need to hit other key combinations. Doing
> a web search for " hidden bios settings" should help you here.
> 
> The "InsydeBIOS" thing is utter crap, basically. I'd *reallY* strongly
> recommend getting rid of the machine and replacing it with something
> less awful.
> 
> Be aware that if you switch storage from RAID to AHCI mode then you'll
> probably lose access to the Windows installation - it will be
> depending on the RAID setup.

Re: Debian will not boot any more, wrong UUID

[Curt]

On 2023-09-30, Hans  wrote:
>
> Second: The setting of AHCI has disappeared, so I can not change the settings 
> in BIOS. And: the BIOS can not be reflashed!
>

I've read that on some Acer machines the procedure is:

'Main' BIOS tab/ctrl+s (as suggested by Steve and Jeffrey)/toggle VMD
Controller to [Disabled].

-- 

Re: [SOLVED] Samba+Kerberos inside LXC container...

[nimrod]

I've found a decent workaround for this issue.

I set a public IP for the container and put it in the DNS with hostname
"samba".

Et voilà:

$ smbclient //samba/dati -k
WARNING: The option -k|--kerberos is deprecated!
Try "help" to get a list of possible commands.
smb: \>

The share is also perfectly accessible from Windows and Linux machines
in the same Active Directory domain without prompting for credentials,
provided that the user has logged in the machine with domain
credentials.

That's exactly what I need.

Assigning a public IP to an LXD container is a bit tricky, because you
need to set up a specific profile, removing the default profile from
the container and assign this new profile to it. But it works, that's
enough for me.

Hope this could help someone else.

On Tue, 2023-09-19 at 14:50 +0200, nimrod wrote:
> Hi,
> 
> I'm running an LXC container on a Debian 12 host. The container,
> named "samba", aims to share a directory in an Active Directory
> environment (functional level 2016).
> 
> The container is joined to the domain using the realm command. Inside
> the container I can login with any domain user without any problem. 
> 
> I can also access the share with a command like:
> 
> $ smbclient //dl560/dati -U someuser -W BNCRM
> 
> and issuing the right credentials when prompted.
> 
> What I cannot absolutely get working is access the same share with
> Kerberos:
> 
> $ smbclient -k //dl560/dati
> 
> The above command is run as an authenticated user, who can perfectly
> well access another share on a virtual Debian 10 server. If I issue
> the above command with the -d10 option I get the long output below.
> 
> I've mapped 445 port this way:
> 
> $ lxc config device add samba port445 proxy listen=tcp:0.0.0.0:445
> connect=tcp:10.65.65.147:445
> 
> Any suggestionwould be very appreciated. I can try to provide any
> missing information.giuli
> 
> Best regards.
> 
> -
> $ smbclient -k //dl560/dati
> WARNING: The option -k|--kerberos is deprecated!
> INFO: Current debug levels:
> all: 10
> tdb: 10
> printdrivers: 10
> lanman: 10
> smb: 10
> rpc_parse: 10
> rpc_srv: 10
> rpc_cli: 10
> passdb: 10
> sam: 10
> auth: 10
> winbind: 10
> vfs: 10
> idmap: 10
> quota: 10
> acls: 10
> locking: 10
> msdfs: 10
> dmapi: 10
> registry: 10
> scavenger: 10
> dns: 10
> ldb: 10
> tevent: 10
> auth_audit: 10
> auth_json_audit: 10
> kerberos: 10
> drs_repl: 10
> smb2: 10
> smb2_credits: 10
> dsdb_audit: 10
> dsdb_json_audit: 10
> dsdb_password_audit: 10
> dsdb_password_json_audit: 10
> dsdb_transaction_audit: 10
> dsdb_transaction_json_audit: 10
> dsdb_group_audit: 10
> dsdb_group_json_audit: 10
> lp_load_ex: refreshing parameters
> Initialising global parameters
> rlimit_max: increasing rlimit_max (1024) to minimum Windows limit
> (16384)
> INFO: Current debug levels:
> all: 10
> tdb: 10
> printdrivers: 10
> lanman: 10
> smb: 10
> rpc_parse: 10
> rpc_srv: 10
> rpc_cli: 10
> passdb: 10
> sam: 10
> auth: 10
> winbind: 10
> vfs: 10
> idmap: 10
> quota: 10
> acls: 10
> locking: 10
> msdfs: 10
> dmapi: 10
> registry: 10
> scavenger: 10
> dns: 10
> ldb: 10
> tevent: 10
> auth_audit: 10
> auth_json_audit: 10
> kerberos: 10
> drs_repl: 10
> smb2: 10
> smb2_credits: 10
> dsdb_audit: 10
> dsdb_json_audit: 10
> dsdb_password_audit: 10
> dsdb_password_json_audit: 10
> dsdb_transaction_audit: 10
> dsdb_transaction_json_audit: 10
> dsdb_group_audit: 10
> dsdb_group_json_audit: 10
> Processing section "[global]"
> doing parameter workgroup = WORKGROUP
> doing parameter log file = /var/log/samba/log.%m
> doing parameter max log size = 1000
> doing parameter logging = file
> doing parameter panic action = /usr/share/samba/panic-action %d
> doing parameter server role = standalone server
> doing parameter obey pam restrictions = yes
> doing parameter unix password sync = yes
> doing parameter passwd program = /usr/bin/passwd %u
> doing parameter passwd chat = *Enter\snew\s*\spassword:* %n\n
> *Retype\snew\s*\spassword:* %n\n *password\supdated\ssuccessfully* .
> doing parameter pam password change = yes
> doing parameter map to guest = bad user
> doing parameter usershare allow guests = yes
> pm_process() returned Yes
> lp_servicenumber: couldn't find homes
> added interface lxcbr0 ip=10.0.3.1 bcast=10.0.3.255
> netmask=255.255.255.0
> added interface lxdbr0 ip=10.190.52.1 bcast=10.190.52.255
> netmask=255.255.255.0
> added interface eno1 ip=192.168.0.77 bcast=192.168.1.255
> netmask=255.255.254.0
> Client started (version 4.17.10-Debian).
> Opening cache file at /run/samba/gencache.tdb
> tdb(/run/samba/gencache.tdb): tdb_open_ex: could not open file
> /run/samba/gencache.tdb: Permission denied
> gencache_init: Opening user cache file
> /home/someuser/.cache/samba/gencache.tdb.
> sitename_fetch: No stored sitename for realm ''
> internal_resolve_name: looking up dl560#20 (sitename (null))
> namecache_fetch: name dl560#20 found.
> remove_duplicate_addrs2: looking for duplicate address/port pairs
> Connecting to 

Re: Problèmes à l'installation si je ne veux pas refaire les partitions de swap

[Haricophile]

Le Mon, 2 Oct 2023 11:16:30 +0200,
Eric DEGENETAIS  a écrit :

> La solution proposée par deboostrap me convient parfaitement. Elle a
> d'ailleurs le bénéfice secondaire de passer par un chroot, donc de me
> permettre de faire pas mal de travail en parallèle de l'utilisation
> de l'OS primaire. Je ne le cherchais pas spécialement mais ça me
> convient plutôt.

Intellectuellement, je trouve que c'est en plein dans l'esprit de la
famille UNIX et c'est ce qui la rend géniale.

Re: How can I find packages manually installed using "dpkg -i"?

[The Wanderer]

On 2023-10-02 at 09:52, Greg Wooledge wrote:

> On Mon, Oct 02, 2023 at 09:43:39AM -0400, The Wanderer wrote:
> 
>> On 2023-10-02 at 09:28, Ottavio Caruso wrote:
>> 
>>> Yeah, the one for which I had to manually use "dpkg -i".
>> 
>> That information is not tracked.
>> 
>> What is tracked is "the package versions known to be available from
>> each registered repository" and "the package versions which are
>> installed".
> 
> There *is* tracking.  Packages can be marked as "automatically
> installed" or not.  The problem is, the marking is not consistent
> with user expectations.

That does exist, yes, but it tracks "explicitly selected for
installation" vs. "installed as a dependency" - and even beyond the
problems which you note, that isn't the distinction which Ottavio
appears to be interested in.

The distinction Ottavio is interested in appears to be "installed by
'dpkg -i' from a .deb file on the command line" vs. "installed via 'apt'
or 'apt-get' from a repository". (It's not clear how "installed via
'apt' from a .deb file on the command line" would be counted for this
purpose.)

As far as I'm aware, there is no tracking of where the package entered
the local system from, which is what would be necessary in order for
something to report the information Ottavio appears to be seeking.

-- 
   The Wanderer

The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man. -- George Bernard Shaw



signature.asc
Description: OpenPGP digital signature

systemctl status mariadb - Access denied for user root at localhost using password NO

[Petros Pap]

-- System Information:
Debian GNU/Linux 12 (bookworm)
Linux server 6.1.0-12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.52-1
(2023-09-07) x86_64 GNU/Linux
Version: systemd 252 (252.12-1~deb12u1) +PAM +AUDIT +SELINUX +APPARMOR +IMA
+SMACK +SECCOMP +GCRYPT -GNUTLS +OPENSSL +ACL +BLKID +CURL +ELFUTILS +FIDO2
+IDN2 -IDN +IPTC +KMOD +LIBCRYPTSETUP +LIBFDISK +PCRE2 -PWQUALITY +P11KIT
+QRENCODE +TPM2 +BZIP2 +LZ4 +XZ +ZLIB +ZSTD -BPF_FRAMEWORK -XKBCOMMON +UTMP
+SYSVINIT default-hierarchy=unified


-- Issue
I have installed Webmin, mariadb, and phpmyadmin

All the above is working
I can create databases from Webmin and create databases from phpmyadmin
and i can login to mysql

root@server:~# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
root@server:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5958
Server version: 10.11.3-MariaDB-1 Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]>


But when i try


root@server:~# systemctl stop mariadb.service
root@server:~# systemctl restart mariadb.service
root@server:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.11.3 database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset:
enabled)
 Active: active (running) since Mon 2023-10-02 16:04:54 EEST; 17s ago
   Docs: man:mariadbd(8)
 https://mariadb.com/kb/en/library/systemd/
Process: 153057 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root
-d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 153058 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 153060 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery
] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]
  && s>
Process: 153144 ExecStartPost=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 153146 ExecStartPost=/etc/mysql/debian-start (code=exited,
status=0/SUCCESS)
   Main PID: 153131 (mariadbd)
 Status: "Taking your SQL requests now..."
  Tasks: 14 (limit: 14299)
 Memory: 172.9M
CPU: 744ms
 CGroup: /system.slice/mariadb.service
 └─153131 /usr/sbin/mariadbd

Oct 02 16:04:53 server systemd[1]: Starting mariadb.service - MariaDB
10.11.3 database server...
Oct 02 16:04:54 server systemd[1]: Started mariadb.service - MariaDB
10.11.3 database server.
Oct 02 16:04:54 server /etc/mysql/debian-start[153151]: Reading datadir
from the MariaDB server failed. Got the following error when executing th>
Oct 02 16:04:54 server /etc/mysql/debian-start[153151]: ERROR 1045 (28000):
Access denied for user 'root'@'localhost' (using password: NO)
Oct 02 16:04:54 server /etc/mysql/debian-start[153151]: FATAL ERROR:
Upgrade failed
Oct 02 16:04:54 server debian-start[153160]: ERROR 1045 (28000): Access
denied for user 'root'@'localhost' (using password: NO)


I don't know if the problem is from systemctl or from mariadb or from
phpmyadmin,
I believe is systemctl because everything else seems is working

Can you please advise me what to do?

-- 
ppetros

Re: How can I find packages manually installed using "dpkg -i"?

[tomas]

On Mon, Oct 02, 2023 at 09:52:39AM -0400, Greg Wooledge wrote:
> On Mon, Oct 02, 2023 at 09:43:39AM -0400, The Wanderer wrote:
> > On 2023-10-02 at 09:28, Ottavio Caruso wrote:
> > > Yeah, the one for which I had to manually use "dpkg -i".
> > 
> > That information is not tracked.
> > 
> > What is tracked is "the package versions known to be available from each
> > registered repository" and "the package versions which are installed".
> 
> There *is* tracking.  Packages can be marked as "automatically installed"
> or not.  The problem is, the marking is not consistent with user
> expectations.

But not if you use dpkg directly (dpkg doesn't even resolve dependencies,
but just gives up when some aren't met). That's why I proposed comparing
apt logs and dpkg logs -- things in the latter but not in the former were
probably installed with straight dpkg.

It probably ain't straightforward, though. And the logs might have been
rotated out anyway.

Cheers
-- 
t


signature.asc
Description: PGP signature

Re: How can I find packages manually installed using "dpkg -i"?

[Greg Wooledge]

On Mon, Oct 02, 2023 at 09:43:39AM -0400, The Wanderer wrote:
> On 2023-10-02 at 09:28, Ottavio Caruso wrote:
> > Yeah, the one for which I had to manually use "dpkg -i".
> 
> That information is not tracked.
> 
> What is tracked is "the package versions known to be available from each
> registered repository" and "the package versions which are installed".

There *is* tracking.  Packages can be marked as "automatically installed"
or not.  The problem is, the marking is not consistent with user
expectations.

>From apt-patterns(7):

   ?automatic, ~M
   Selects packages that were installed automatically.

[...]

EXAMPLES
[...]
   apt list '~i !~M (~slibs|~sperl|~spython)'
   List all manually-installed packages in sections matching libs,
   perl, or python.

But if you try this locally, you'll discover that a bunch of packages
are listed which you don't expect.

unicorn:~$ apt list '~i !~M'
Listing... Done
abcde/stable,stable,now 2.9.3-1 all [installed]
acl/stable,now 2.3.1-3 amd64 [installed]
adduser/stable,stable,now 3.134 all [installed]
alsa-utils/stable,now 1.2.8-1 amd64 [installed]
an/stable,now 1.2-7+b1 amd64 [installed]
apt-listchanges/stable,stable,now 3.24 all [installed]
apt-transport-https/stable,stable,now 2.6.1 all [installed]
apt-utils/stable,now 2.6.1 amd64 [installed]
apt/stable,now 2.6.1 amd64 [installed]
aptitude/stable,now 0.8.13-5 amd64 [installed]
at/stable,now 3.2.5-1+b1 amd64 [installed]
[...]

I didn't need to install "adduser" or "apt" manually, for example, and
yet they're listed here.  As it turns out, most (or all?) of the packages
that were installed by the installer *also* show up as manually installed.
This makes it unsuitable for most people's purposes.

Re: How can I find packages manually installed using "dpkg -i"?

[The Wanderer]

On 2023-10-02 at 09:28, Ottavio Caruso wrote:

> Am 02/10/2023 um 10:12 schrieb Marco M.:
> 
>> That means it cannot be found in the currently enables repos.
>> 
>> Do you want to list such packages
> 
> Yeah, the one for which I had to manually use "dpkg -i".

That information is not tracked.

What is tracked is "the package versions known to be available from each
registered repository" and "the package versions which are installed".
Whether the package version that is installed came from one of the
registered repositories, much less whether it was installed from that
repository, is not tracked.

Unless I'm much mistaken, if you installed one package manually (i.e.,
not as a dependency) from a repository and another package locally via
'dpkg -i', the installation state of those two packages will look the
same. The system does not track anything which would let it tell you
where the package came from; at most, if the installed version of a
package is available from a currently-registered repository, it may be
able to tell you where you could get that package from again.

It's entirely probable that there is no way to identify the set of
packages you're interested in, short of a combination of manual
archaeology in local log files (and the local apt package cache) and
relying on your own memory.

-- 
   The Wanderer

The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man. -- George Bernard Shaw



signature.asc
Description: OpenPGP digital signature

Re: How can I find packages manually installed using "dpkg -i"?

[Marco M.]

Am 02.10.2023 um 13:28:05 Uhr schrieb Ottavio Caruso:

> Yeah, the one for which I had to manually use "dpkg -i".

I don't know a way to only show them. Every package has the attribute
"automatically installed". Every package you manually installed doesn't
have that.

Re: Segmentation fault in Chromium

[Marco M.]

Am 02.10.2023 um 13:16:24 Uhr schrieb Richmond:

> I received a segmentation fault from chromium. Would it be logged
> anywhere?

Install gdb and run it with that to get more information.

Segmentation fault in Chromium

[Richmond]

I received a segmentation fault from chromium. Would it be logged
anywhere? I searched journalctl but no mention of it.

Chromium 117.0.5938.132 built on Debian 11.7, running on Debian 11.7

5.10.0-25-amd64 #1 SMP Debian 5.10.191-1 (2023-08-16) x86_64 GNU/Linux

I expect such things cannot be logged but it would be good to find out
what it is.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Xavier Drudis Ferran]

El Mon, Oct 02, 2023 at 12:45:26PM +0200, Narcis Garcia deia:
> 
> Però el què necessito és poder dissenyar un formulari: Amb etiquetes i
> explicacions per a cada camp que emplena l'usuari, limitació del format de
> les dades, algun avís o reacció programada, etc.
> També dissenyar un informe: Un llistat on aparegui el títol que jo vull,
> explicacions a l'efecte, numeració de pàgines, suma de la columna que jo
> vull, etc.
>

Ni idea.  La meva humil opinió és que això no és tan fàcil d'oferir
en una aplicació genèrica, i per això qui ho intenta es queda bastant
a mitges. Al final si intentes fer-ho amb una aplicació "per a
dummies" acabes tenint més feina que si et fas a mida una aplicació
web o una aplicació d'escriptori (però hauria de ser portable).

Els frameworks de programació són més complicats d'aprendre però
ofereixen més flexibilitat i llavors costen menys de fer servir.

Generadors d'informe potser encara en pots trobar de genèrics que et
solucionin alguna cosa (jasper reports o així). Però també si no es
complica molt el llistat, que si no arriba un moment que s'acaben o es
compliquen massa. Però formularis que no siguin estúpids del tot i
siguin còmodes i informatius, costen menys de fer amb HTML i un
programa de servidor que amb dissenyadors de formularis que tenen un
conjunt limitat de tipus, validacions i presentacions.

Vull dir que sí, que fer-te un programa a mida és feina. Però agafar
una eina genèrica i fer-te-la a mida a vegades és més feina i queda
pitjor. I si intentes estalviar temps acabaràs amb deute tecnològic,
però et passarà tant programant-ho tu com amb una eina genèrica. Si ho
programes tu no li voldràs deicar prou temps per deixar-ho super
perfecte i quan ho vulguis canviar en un futur serà més difícil. I si
agafes una eina, un cop tinguis alguna cosa passable, ho deixaràs així
i en un futur et trobaràs nous requeriments que l'eina no hi arribarà
i t'hauràs de passar a un programa a mida.

En qualsevol cas, bona sort.

Re: How can I find packages manually installed using "dpkg -i"?

[Max Nikulin]

On 02/10/2023 17:05, Ottavio Caruso wrote:

Before you say:

$ apt list '?narrow(?installed, ?not(?origin(Debian)))'

The problem with that is there are packages that I added from the Linux 
Mint repos (not manually) and that I want to keep and they all have the 
tag "local". For example:


mintmenu/now 6.1.5 all [installed,local]
mintreport/now 1.3.5 all [installed,local]
mintsources/now 2.1.9 all [installed,local]


Apt does not store in its DB from which sources particular packages were 
installed. Filters are based on presence of packages in currently 
configured repositories. See apt-patterns(7) for various available 
options such as ~M for automatically installed packages. I would try


   apt list '~o!~M'

To get list of local manually installed packages. If the number of them 
is not high you may remove them and then run


apt autoremove --purge

Notice that packages from non-standard repositories may break upgrade 
due to their dependencies.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Narcis Garcia]

El 2/10/23 a les 12:32, Xavier Drudis Ferran ha escrit:

El Mon, Oct 02, 2023 at 12:27:04PM +0200, Xavier Drudis Ferran deia:

El Mon, Oct 02, 2023 at 10:52:12AM +0200, Narcis Garcia deia:


Necessito reduir els requisits tècnics al mínim, i el meu objectiu és que
l'usuari només hagi de tenir LibreOffice i saber la seva credencial.
Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit.



No estic segur que el libreoffice sol inclogui totes les extensions
necessàries per acedir a MySQL, o a tots els sgbd possibles.

MySQL té un client de base de dades gràfic (MySQL Workbench), però no
tinc clar que un usuari final s'hi trobi molt còmode.

Si no aparentment hi ha aplicacions que no ho he provat com per dir
si et serveixen, però em fa por que puguin espantar usuaris. Si vols mirar,
sense masssa fe...

kexi, ferret, kettle (pentaho data integration)

Però sembla matar mosques a canonades, no sé, és per altres mena de feines...



O potser Tora, SQL Squirrel o DBeaver, però no estan a debian.



Vaig fer un cop d'ull a Kexi, i sembla la típica aplicació per accedir a 
una base de dades tal com és, com el 99% de recomanacions que llegeixo.


Però el què necessito és poder dissenyar un formulari: Amb etiquetes i 
explicacions per a cada camp que emplena l'usuari, limitació del format 
de les dades, algun avís o reacció programada, etc.
També dissenyar un informe: Un llistat on aparegui el títol que jo vull, 
explicacions a l'efecte, numeració de pàgines, suma de la columna que jo 
vull, etc.


--

Narcis Garcia

__
I'm using this dedicated address because personal addresses aren't 
masked enough at this mail public archive. Public archive administrator 
should remove and omit any @, dot and mailto combinations against 
automated addresses collectors.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Xavier Drudis Ferran]

El Mon, Oct 02, 2023 at 12:27:04PM +0200, Xavier Drudis Ferran deia:
> El Mon, Oct 02, 2023 at 10:52:12AM +0200, Narcis Garcia deia:
> > 
> > Necessito reduir els requisits tècnics al mínim, i el meu objectiu és que
> > l'usuari només hagi de tenir LibreOffice i saber la seva credencial.
> > Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit.
> >
> 
> No estic segur que el libreoffice sol inclogui totes les extensions
> necessàries per acedir a MySQL, o a tots els sgbd possibles.
> 
> MySQL té un client de base de dades gràfic (MySQL Workbench), però no
> tinc clar que un usuari final s'hi trobi molt còmode.
> 
> Si no aparentment hi ha aplicacions que no ho he provat com per dir
> si et serveixen, però em fa por que puguin espantar usuaris. Si vols mirar,
> sense masssa fe...
> 
> kexi, ferret, kettle (pentaho data integration)
> 
> Però sembla matar mosques a canonades, no sé, és per altres mena de feines...
>

O potser Tora, SQL Squirrel o DBeaver, però no estan a debian.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Xavier Drudis Ferran]

El Mon, Oct 02, 2023 at 10:52:12AM +0200, Narcis Garcia deia:
> 
> Necessito reduir els requisits tècnics al mínim, i el meu objectiu és que
> l'usuari només hagi de tenir LibreOffice i saber la seva credencial.
> Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit.
>

No estic segur que el libreoffice sol inclogui totes les extensions
necessàries per acedir a MySQL, o a tots els sgbd possibles.

MySQL té un client de base de dades gràfic (MySQL Workbench), però no
tinc clar que un usuari final s'hi trobi molt còmode.

Si no aparentment hi ha aplicacions que no ho he provat com per dir
si et serveixen, però em fa por que puguin espantar usuaris. Si vols mirar,
sense masssa fe...

kexi, ferret, kettle (pentaho data integration)

Però sembla matar mosques a canonades, no sé, és per altres mena de feines...


> > > i directament funciona
> > > amb algunes mancances.
> > > «Connect directly (using MariaDB C connector)»:
> > > 
> > > No desa claus primàries quan creo taules amb camps, i no reacciona quan
> > > demano crear un informe.
> > 
> > Ni idea, sembla alguna incompatibilitat.
> > Ho fa indiferentment del tipus de dades dels camps clau ?
> 
> Sembla que si, que és indiferent.

Vaja.

> I els camps d'autocomptador numèric, no compten.
>

Ara que ho dius això em sona com d'alguna prova fa mooolt de temps.
Crec que no ho vaig poder arreglar i vaig acabar havent de posar un
trigger al MySQL per una cosa que en teoria no calia.

> 
> Necessito que es pugui fer amb una aplicació d'escriptori, independentment
> de què algun dia es desenvolupi una interfície web, que no podrà dependre de
> CMS que condicionin tot.
>

> 
> El problema és requerir que l'usuari s'hagi d'instal·lar cosetes, i què això
> sigui viable amb GNU, Windows, etc.


No sé què dir-te. No em sona que la gent tingui als seus escriptoris
aplicacions genèriques d'actualitzar bases de dades que valguin gran
cosa.

Llavors si ha de ser d'escriptori, però no vols que hagin d'instal·lar
gran cosa...  difícil. Si te'n surts ja ens ho expliques.

Si, ja, el libreoffice base hauria de servir. Però jo les vegades que
el vaig provar (poc i fa temps) no em va semblar tan perfecte i
superpolit i infalible com per deixar gaire sols als usuaris,
dependent de qui fossin... Potser simplement vaig ser jo que no en
sabia o no m'hi vaig dedicar prou.

Re: How can I find packages manually installed using "dpkg -i"?

[tomas]

On Mon, Oct 02, 2023 at 10:05:46AM +, Ottavio Caruso wrote:
> I want to upgrade Bullseye to Bookworm and I want to remove all packages
> that I installed manually, downloading the .debs
>  and then using "dpkg -i".

[...]

If you're lucky, /var/log/dpkg.log in combination with one or both of
/var/log/apt/history.log and/or /var/log/apt/term.log and some elbow
grease (or some creative scripting) might help.

> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing in e-mail?

How true. However, people who need to understand this are most
likely to not read that far :-(

Cheers
-- 
t


signature.asc
Description: PGP signature

Re: How can I find packages manually installed using "dpkg -i"?

[Marco M.]

Am 02.10.2023 um 10:05:46 Uhr schrieb Ottavio Caruso:

> Before you say:
> 
> $ apt list '?narrow(?installed, ?not(?origin(Debian)))'
> 
> The problem with that is there are packages that I added from the
> Linux Mint repos (not manually) and that I want to keep and they all
> have the tag "local". For example:
> 
> mintmenu/now 6.1.5 all [installed,local]
> mintreport/now 1.3.5 all [installed,local]
> mintsources/now 2.1.9 all [installed,local]

That means it cannot be found in the currently enables repos.

Do you want to list such packages or the packages that are listed as
manually installed (and not automatically because another package
depends on them)?

Fwd: btrfs snapshots (of root file system)?

[Keith Bainbridge]

Try ext4

All the best

Keith BAINBRIDGE

+61 (0)447 667 468
keithr...@gmail.com

UTC + 10

>From my Apad

-- Forwarded message -
From: Keith Bainbridge 
Date: Mon, 2 Oct 2023, 20:32
Subject: Re: btrfs snapshots (of root file system)?
To: debian-user@lists.debian.org 


I use timeshift for this. It claims to use btrfs as an option. I've only
used rsync on extra, and that has saved my bacon a few times

All the best

Keith BAINBRIDGE

+61 (0)447 667 468
keithr...@gmail.com

UTC + 10

>From my Apad

On Sun, 1 Oct 2023, 15:10 hw,  wrote:

> Hi,
>
> with btrfs, how do I make a snapshot of the root file system?  The
> purpose is to update software and being able to go back to a previous
> state if necessary.
>
> There doesn't seem to be a command to create snapshots but only
> subvolumes?  How does a subvolume turn into a snapshot?  (The root
> file system is, of course, not on a subvolume.)
>
> How do I merge snapshots?  IIRC, when you remove a ZFS snapshot, the
> older state is merged to the state the snapshot is in.  Apparently
> btrfs can only delete snapshots --- and it seems like a bad idea to
> delete the root file system.  How would I boot from it when it's been
> deleted?
>
> Can I make a snapshot on a different volume?  The manpage doesn't say
> that the destination of a subvolume must be on the same volume, and in
> any case, I should be able to do that.
>
>

Re: btrfs snapshots (of root file system)?

[Keith Bainbridge]

I use timeshift for this. It claims to use btrfs as an option. I've only
used rsync on extra, and that has saved my bacon a few times

All the best

Keith BAINBRIDGE

+61 (0)447 667 468
keithr...@gmail.com

UTC + 10

>From my Apad

On Sun, 1 Oct 2023, 15:10 hw,  wrote:

> Hi,
>
> with btrfs, how do I make a snapshot of the root file system?  The
> purpose is to update software and being able to go back to a previous
> state if necessary.
>
> There doesn't seem to be a command to create snapshots but only
> subvolumes?  How does a subvolume turn into a snapshot?  (The root
> file system is, of course, not on a subvolume.)
>
> How do I merge snapshots?  IIRC, when you remove a ZFS snapshot, the
> older state is merged to the state the snapshot is in.  Apparently
> btrfs can only delete snapshots --- and it seems like a bad idea to
> delete the root file system.  How would I boot from it when it's been
> deleted?
>
> Can I make a snapshot on a different volume?  The manpage doesn't say
> that the destination of a subvolume must be on the same volume, and in
> any case, I should be able to do that.
>
>

Re: Does anyone own and use a Kindle Scribe?

[Eric S Fraga]

On Sunday,  1 Oct 2023 at 15:25, Joe wrote:
> Calibre converts/creates ebooks and is generally a useful accessory for
> a Kindle or other hardware reader. No, I'm not on commission.

+1 for calibre!

I use it for managing my Kobo devices.  Works very well.

-- 
Eric S Fraga via gnus (Emacs 30.0.50 2023-07-11) on Debian bullseye/sid

Re: Problèmes à l'installation si je ne veux pas refaire les partitions de swap

[Eric DEGENETAIS]

Le lun. 2 oct. 2023 à 10:37, Haricophile  a écrit :

> Hormis la solution intéressante proposée, je ne comprends pas ce qui
> empêche de créer plusieurs partitions swap (hormis le gâchis d'espace
> disque) ou de fixer le bon UUID dans le système.

Ça gâche de l'espace, c'est inutile puisque je ne m'en sers que pour me
rattraper aux branches dans de rares cas. Rectifier l'UUID est possible,
mais je trouve ce besoin agaçant.
La solution proposée par deboostrap me convient parfaitement. Elle a
d'ailleurs le bénéfice secondaire de passer par un chroot, donc de me
permettre de faire pas mal de travail en parallèle de l'utilisation de l'OS
primaire. Je ne le cherchais pas spécialement mais ça me convient plutôt.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Narcis Garcia]

El 13/9/23 a les 21:58, Alex Muntada ha escrit:

Hola, Julio i Narcis:


Tinc una base de dades remota postgresql i vull que altres
usuaris puguin llistar qualsevol informació d'aquesta sense
coneixements de SQL. Desconec si és fàcil introduir dades tipus
formulari, ja que en principi no ho necessito.

Vaig trobar dbgate  i m'està agradant.


Per aquest cas d'ús, m'han parlat bé de baserow.io, però no l'he
provat. A la feina tenim algunes instàncies de adminer.org i
phpmyadmin.net, i algun companys utilitzen dbeaver.io com a
gestor universal de bases de dades.

Per al cas d'ús d'en Narcís, com que de LibreOffice no en sé
gens, a banda del baserow.io se m'acut fer un formulari web amb
django o simplement un CRUD automàtic dels que pot muntar tot
solet.


Gràcies Alex;
m'interessa que es pugui treballar sense el navegador (aplicació 
d'escriptori), i no tancar les portes a què un dia es pugui desenvolupar 
una interfície web en PHP.


No sé si és que és escassa la gent que utilitza LibreOffice Base, i no 
s'enregistren incidències per al desenvolupament, perquè porto anys 
anant al darrere d'aquest tema (com havia fet amb Microsoft Access a la 
dècada de 1990) i quan no és un ai és una ceba.


LibreOffice Base segueix semblant la versió alfa d'un projecte de 
programari.


--

Narcis Garcia

__
I'm using this dedicated address because personal addresses aren't 
masked enough at this mail public archive. Public archive administrator 
should remove and omit any @, dot and mailto combinations against 
automated addresses collectors.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Narcis Garcia]

El 13/9/23 a les 9:51, Julio ha escrit:

Hola,

jo tampoc et puc ajudar amb libreoffice.

Però sí et puc comentar el meu cas. Tinc una base de dades remota 
postgresql i vull que altres usuaris puguin llistar qualsevol informació 
d'aquesta sense coneixements de SQL. Desconec si és fàcil introduir 
dades tipus formulari, ja que en principi no ho necessito.


Vaig trobar dbgate  i m'està agradant.

Sort


Gràcies;
normalment tinc en compte només programari que, o bé està als 
repositoris de Debian, o bé puc partir de les referències de l'enciclopèdia.
L'enciclopèdia per mi ja és un filtre per a saber que l'aplicatiu no va 
néixer ahir, quina llicència té, i que hi ha algun consens sobre la 
naturalesa del projecte.



El 12/9/23 a les 9:05, Narcis Garcia ha escrit:

Bon dia,

Estic intentant crear un document de base de dades amb LibreOffice per 
a compartir, connectat a una base de dades del servei remot MariaDB.
Em trobo que fer-ho mitjançant ODBC requereix algun tipus de 
configuració a l'entorn operatiu (poc portable), mitjançant JDBC no 
funciona* (Prova la classe: No s'ha pogut carregar el controlador 
JDBC), i directament funciona amb algunes mancances.

«Connect directly (using MariaDB C connector)»:

No desa claus primàries quan creo taules amb camps, i no reacciona 
quan demano crear un informe.
A més a més, si ho deixes obert perd la connexió i cap tancar tot el 
LibreOffice per a poder tornar a obrir i que connecti.


¿Algú s'ha barallat amb aquest tema i pt fer recomanacions?

El què busco és una forma senzilla de què, entre vàries persones 
cadascuna a casa seva, introduïm dades a una base de dades mitjançant 
un formulari, i podem treure un llistat.
Que no requereixi cap coneixement tècnic per a utilitzar-ho per 
primera vegada.



LibreOffice: 7.4
Debian: 11
(*) El paquet libreoffice-base-drivers està instal·lat, que inclou JDBC.


--
__

 El 2003 el català era la llengua habitual del 46 % dels catalans. Al 2018 
només del 36 %. Si els castellanoparlants no actuem, desapareixerà.

 El 3 de novembre representa el moment de l'any en el que les dones deixen 
de cobrar en comparació amb els homes. Hem d’ajudar a les dones a eliminar 
aquesta data.

 L’administració pública cada any es gasta milions d’euros en llicències de 
programari privatiu. Utilitzant programari lliure estalviem costos i incentivem 
l’economia local.

La neutralitat davant les desigualtats acaba accentuant-les.



--

Narcis Garcia

__
I'm using this dedicated address because personal addresses aren't 
masked enough at this mail public archive. Public archive administrator 
should remove and omit any @, dot and mailto combinations against 
automated addresses collectors.

Re: (deb-cat) LibreOffice i MariaDB/MySQL

[Narcis Garcia]

El 12/9/23 a les 11:00, Xavier Drudis Ferran ha escrit:

Ho sento, no ho he provat ni gens ni gaire això que dius,
suposo que no et podré ajudar...

El Tue, Sep 12, 2023 at 09:05:56AM +0200, Narcis Garcia deia:

Bon dia,

Estic intentant crear un document de base de dades amb LibreOffice per a
compartir, connectat a una base de dades del servei remot MariaDB.
Em trobo que fer-ho mitjançant ODBC requereix algun tipus de configuració a
l'entorn operatiu (poc portable),


I amb les altres opciosn no necessites configuració local ?
Al menys credencials o això ?


La única cosa que, de ben segur, haurà d'introduir l'usuari és la 
credencial per accedir a la base de dades.



mitjançant JDBC no funciona* (Prova la
classe: No s'ha pogut carregar el controlador JDBC),


tens libmariadb-java instal·lat ?


Necessito reduir els requisits tècnics al mínim, i el meu objectiu és 
que l'usuari només hagi de tenir LibreOffice i saber la seva credencial.

Si s'han d'instal·lar «extres» això complica les possibilitats d'èxit.


i directament funciona
amb algunes mancances.
«Connect directly (using MariaDB C connector)»:

No desa claus primàries quan creo taules amb camps, i no reacciona quan
demano crear un informe.


Ni idea, sembla alguna incompatibilitat.
Ho fa indiferentment del tipus de dades dels camps clau ?


Sembla que si, que és indiferent.
I els camps d'autocomptador numèric, no compten.


A més a més, si ho deixes obert perd la connexió i cap tancar tot el
LibreOffice per a poder tornar a obrir i que connecti.



M'imagino que algun timeout es deu poder configurar per algun lloc,
wait_timeout, interactive_timeout...
però si no vols configuracions locals ja no sé...

De detalls així suposo que ja en saps buscar tu...
https://stackoverflow.com/questions/51506416/mariadb-server-times-out-client-connection-after-600-seconds

A mi em sonava que sense tancar el LibreOffice podies obrir i tancar
connexions, però potser no ho recordo bé o ha canviat en les versions
actuals.


¿Algú s'ha barallat amb aquest tema i pt fer recomanacions?



Poc i fa massa temps. Ho sento. Sort.


El què busco és una forma senzilla de què, entre vàries persones cadascuna a
casa seva, introduïm dades a una base de dades mitjançant un formulari, i
podem treure un llistat.
Que no requereixi cap coneixement tècnic per a utilitzar-ho per primera
vegada.



Ni flors, Nextcloud forms ?
Framaforms ?
https://framaforms.org/abc/ca/
Framacalc ?
https://framacalc.org/abc/ca/

Però la funcionalitat pot no quadrar i instal·lar o mantenir el teu
servidor pot ser massa feina.


Necessito que es pugui fer amb una aplicació d'escriptori, 
independentment de què algun dia es desenvolupi una interfície web, que 
no podrà dependre de CMS que condicionin tot.



En tot cas si vas per ODBC, JDBC, etc. tingues en compte si les dades
van xifrades o no per la xarxa.

Per a xifrar-les normalment caldria configurar claus i certificats al
servidor (i si vols al client per autenticar però això és més
configuració local i igual no vols). I si la CA del certificat de
servidor no és pública, o no et vols refiar de totes les CAs
públiques, o vols fer alguna mena de pinning, potser configurar
truststores i mandangues a cada client...


D'acord.


LibreOffice: 7.4
Debian: 11
(*) El paquet libreoffice-base-drivers està instal·lat, que inclou JDBC.


Sospito que inclou part de JDBC, el costat de l'aplicació, però no el
costat de la BD, i llavors falta un controlador JDBC (en java)
específic per a la BD, que seria libmariadb-java, però tampoc he
provat ara fa poc.


El problema és requerir que l'usuari s'hagi d'instal·lar cosetes, i què 
això sigui viable amb GNU, Windows, etc.



--

Narcis Garcia

__
I'm using this dedicated address because personal addresses aren't 
masked enough at this mail public archive. Public archive administrator 
should remove and omit any @, dot and mailto combinations against 
automated addresses collectors.

Re: Debian will not boot any more, wrong UUID

[Steve McIntyre]

Hi Hans!

hans.ullr...@loop.de wrote:
>
>In short; I tried (as most people tell): Starting windows in secure mode, then 
>boot into the BIOS and there set from RAID to AHCI, afterwards start windows 
>as normal.
>
>This setting in BIOS was existent some time ago, but now it is complete gone 
>(this point is completele disappeared!)!!  I know that it is in RAID, because 
>Windows told so: BUS form = RAID.

Right. I have one of these machines as a test box locally, and I think
I know what the problem is.

The core issue is that the BIOS setup screen has a ridiculous
mis-feature - it hides some BIOS entries from the user, with no
indication that it has done so. On the model I have, it needs you to
hit Ctrl-s on each of the BIOS setup screens to show them. I've read
about other models where you need to hit other key combinations. Doing
a web search for " hidden bios settings" should help you here.

The "InsydeBIOS" thing is utter crap, basically. I'd *reallY* strongly
recommend getting rid of the machine and replacing it with something
less awful.

Be aware that if you switch storage from RAID to AHCI mode then you'll
probably lose access to the Windows installation - it will be
depending on the RAID setup.

-- 
Steve McIntyre, Cambridge, UK.st...@einval.com
Can't keep my eyes from the circling sky,
Tongue-tied & twisted, Just an earth-bound misfit, I...

Re: Problèmes à l'installation si je ne veux pas refaire les partitions de swap

[Haricophile]

Le Fri, 29 Sep 2023 16:00:29 +0200,
Eric DEGENETAIS  a écrit :

> Voici le problème : l'installeur me prend la tête avec les partitions
> de swap. _ Soit il les refait, et je dois remettre à jour l'OS "de
> production" pour éviter un délai au boot lié au fait que les UUID ne
> sont plus bons.

Hormis la solution intéressante proposée, je ne comprends pas ce qui
empêche de créer plusieurs partitions swap (hormis le gâchis d'espace
disque) ou de fixer le bon UUID dans le système.