jueves, 21 de mayo de 2020

Abrir fichero .mdb desde Ubuntu

Revisado 22 mayo 2020

En mayo 2020 recibo un fichero .mdb y yo uso ubuntu.

Compruebo que LibreOffice tiene paquete de base de datos, pero no viene por defecto: lo instalo

sudo apt-get install libreoffice-base

A pesar de ello no abre el fichero, y localizo este enlace
http://tahsinabrar.com/open-a-microsoft-access-accdb-file-in-ubuntu/

A partir de ahí descargo
https://sourceforge.net/projects/ucanaccess/files/latest/download
Descargo y descomprimo UCanAccess-5.0.0-bin.zip

Repito los pasos, pero falla al cargar el fichero

Revisando, lo que hay que poneren la configuración
"ucanaccess:///home/enrique/Descargas/Fichero.mdb"
sin el "jdbc:" inicial

Tras eso, se puede abrir y se ven las tablas
Pero da errores de validaciones. Pongo unos ejemplos:

Cannot load procedure 2 Cargar grupos usuario no tiene privilegios suficientes o objeto no encontrado: GRUPOS1 in statement [INSERT INTO Grupos
( IDGRUPO ,  GRUPO , "AÑO",  IDCURSO )SELECT Grupos1.IdGrupo, Grupos1.Grupo, Grupos1.Año, Grupos1.IdCurso
FROM Grupos1
WHERE (((Grupos1.Grupo)=grupoactual()) AND ((Grupos1.Año)=añoactual()) AND ((Grupos1.IdCurso) Between 1 And 6));]

Cannot load procedure 4 Cargar todo usuario no tiene privilegios suficientes o objeto no encontrado: IIA in statement [INSERT INTO "ALUMNO-GRUPO"
( IDALUMNO ,  IDGRUPO ,  DIVER ,  DA01 ,  DA02 ,  DA03 ,  DA04 ,  DA05 ,  DA06 ,  DA07 ,  DA08 ,  DA09 ,  DF01 ,  DF02 ,  DF03 ,  OD01 )SELECT IIA.IdAlumno, "ALUMNO-GRUPO1".IdGrupo, "ALUMNO-GRUPO1".Diver, IIA.DA01, IIA.DA02, IIA.DA03, IIA.DA04, IIA.DA05, IIA.DA06, IIA.DA07, IIA.DA08, IIA.DA09, IIA.DF01, IIA.DF02, IIA.DF03, IIA.OD01
FROM ((IIA INNER JOIN Alumnos ON IIA.IdAlumno=Alumnos.IdAlumno) INNER JOIN "ALUMNO-GRUPO1" ON Alumnos.IdAlumno="ALUMNO-GRUPO1".IdAlumno) INNER JOIN Grupos ON "ALUMNO-GRUPO1".IdGrupo=Grupos.IdGrupo
WHERE (((Grupos.Año)=añoactual()));]

El fichero es una BD interna que usa el centro con información de tutoría: cada tutor pone al final de curso información y al inicio de curso se tiene la información de los alumnos facilitada por el tutor anterior, esté o no esté en el centro. Es muy práctico, aunque también muy sensible a nivel RGPD; realmente solo está en un PC de jefatura de estudios y se rellena a través de unos formularios. Pero en esta situación de confinamiento se envía un fichero .mdb a cada tutor en su domicilio con sus tablas, de modo que rellena su parte y la envía, para que luego se vuelquen todos juntos, y al curso siguiente, tras asignar nuevo grupo a cada alumno, se pueden dar datos a los nuevos tutores.



Me temo que debo buscar otra opción, o un PC con windows ¿y microsoft access pirata?
https://ubunlog.com/3-alternativas-libres-microsoft-access-ubuntu/
A partir de ahí
https://community.kde.org/Kexi/Snapshots#Linux
El paquete flatpak lo instalo desde línea de comandos
Al instalar con flatpak da error

error: The application org.kde.kexi-stable/x86_64/master requires the runtime org.kde.Platform/x86_64/5.12 which was not found

Pero luego compruebo que se puede instalar desde línea de comandos  paquete kexi


Se ejecuta como kexi-3.2, no da error, permite ver tablas pero no formulario para introducir datos.





domingo, 9 de octubre de 2016

Adobe Reader version > 9.5 ubuntu (wine)

Latest version for ubuntu is 9.5, but some spanish e-admin requires at least v11, as it has some digital signature functions

With 16.04 LTS normal wine, installation fails

Some links:
https://planetadiego.com/2016/01/28/utilizar-el-lector-de-pdf-adobe-reader-xi-en-ubuntu-fedora-y-otras-distribuciones-linux/

http://www.estudionexos.com/post/instalar-la-ultima-version-de-adobe-acrobat-reader-en-debian-8-gnulinux-usando-wine/

https://appdb.winehq.org/objectManager.php?sClass=version&iId=27093

 With "winetricks atmlib" it fails
https://github.com/Winetricks/winetricks/issues/600

Manually downloaded and placed in
.cache/winetricks/win2ksp4/W2KSP4_EN.EXE

With "winetricks riched20" it fails
Downloading http://download.microsoft.com/download/WindowsInstaller/Install/2.0/NT45/EN-US/InstMsiW.exe failed

but trying again

winetricks riched20
Executing w_do_call riched20
riched20 already installed, skipping


And AdbeRdr11008_es_ES.exe installed ok


sábado, 27 de agosto de 2016

UltraStar Deluxe in Ubuntu 16.04 LTS

Original USB mics without problem
https://sourceforge.net/p/ultrastardx/wiki/Setup%20Singstar%20Microphones%20(Linux)/

(I understand 80% as 80% of "bar", there is no number)
Download UltraStar Deluxe v1.3.2-beta SourceCode.zip (88.2 MB)


After that, with "./configure"
configure: error: no Free Pascal Compiler found  

So looking here
https://sourceforge.net/p/ultrastardx/wiki/Compiling%20UltraStar%20Deluxe%20on%20GNU-Linux/

sudo apt-get install fpc
After that

configure: error:
Package sdl2 was not found in the pkg-config search path.


Just googling
sudo apt-get install libsdl2-dev


New error
configure: error:
Package SDL2_image was not found in the pkg-config search path.


sudo apt-get install libsdl2-image-dev

configure: error:
Package sqlite3 was not found in the pkg-config search path.

But I do have sqlite3 installed

sqlite3 ya está en su versión más reciente (3.11.0-1ubuntu1).

Full message
Perhaps you should add the directory containing `sqlite3.pc'
to the PKG_CONFIG_PATH environment variable


But with some googling I installed
sudo apt-get install libsqlite3-dev

Next error
configure: error:
Package lua was not found in the pkg-config search path



Next install
sudo apt-get install liblua5.3-dev

Next error
configure: error:
Package libavformat was not found in the pkg-config search path.

Next install
sudo apt-get install libavformat-dev

Next error:
configure: error:
Package portaudio-2.0 was not found in the pkg-config search path.
Next install
sudo apt-get install portaudio19-dev

But that uninstall some packages
jaaa libasound2-plugins:i386 libjack-jackd2-0 libjack-jackd2-0:i386 sonic-visualiser
and it shows some dependencies


After that, with make

src/media/UMediaCore_FFmpeg.pas(44,3) Fatal: Can't find unit swscale used by UMediaCore_FFmpeg
Fatal: Compilation aborted


After more googling

sudo apt-get install libswscale-dev

Problem desapears with a new ./configure (not retrying make directly)

New error, almost at the end

Linking ../game/ultrastardx
/usr/bin/ld.bfd: aviso: ../game/link.res contiene secciones de salida. ¿Olvidó -T?
/usr/bin/ld.bfd: no se puede encontrar -lSDL2_gfx
/usr/bin/ld.bfd: no se puede encontrar -lSDL2_mixer
/usr/bin/ld.bfd: no se puede encontrar -lSDL2_net
/usr/bin/ld.bfd: no se puede encontrar -lSDL2_ttf
Error: Error while linking
Fatal: There were 1 errors compiling module, stopping


New install
sudo apt-get install libsdl2-gfx-dev libsdl2-mixer-dev libsdl2-net-dev libsdl2-ttf-dev

And ... it works

Path for songs

sudo mkdir /usr/local/share/ultrastardx/songs
sudo chmod 777 /usr/local/share/ultrastardx/songs


domingo, 31 de julio de 2016

Adobe Acrobat Reader install in 16.04.01 LTS 64 bits

I use evince, but sometimes Adobe Acrobat software it is mandatory (Madrid administration)

http://www.krizna.com/ubuntu/install-adobe-reader-ubuntu-14-04/


http://ardownload.adobe.com/pub/adobe/reader/unix/9.x/9.5.5/enu/AdbeRdr9.5.5-1_i386linux_enu.deb


dpkg -i does not work

Dependencies

libgtk2.0-0:i386 libatk1.0-0:i386 libcairo2:i386 libgdk-pixbuf2.0-0:i386 libglib2.0-0:i386 libglib2.0-0:i386 libpangocairo-1.0-0:i386 libpangoft2-1.0-0:i386 libpixman-1-0:i386 libxcb-render0:i386 libxcb-shm0:i386 libpango-1.0-0:i386 libharfbuzz0b:i386 libgraphite2-3:i386 libthai0:i386 libdatrie1:i386


With all that packages, installed

Edit:
http://installion.co.uk/ubuntu/xenial/multiverse/n/nspluginwrapper/install/index.html
Not found !?
https://launchpad.net/ubuntu/xenial/+package/nspluginwrapper

https://launchpad.net/ubuntu/xenial/amd64/nspluginwrapper/1.4.4-0ubuntu5

nspluginwrapper depende de nspluginviewer (= 1.4.4-0ubuntu5); sin embargo:
  El paquete `nspluginviewer' no está instalado.
 
And it is not available in xenial amd64

https://launchpad.net/ubuntu/+source/nspluginwrapper/1.4.4-0ubuntu5

But it seems it is ok to use i386 and other version
https://bugs.launchpad.net/ubuntu/+source/nspluginwrapper/+bug/853738
So downloaded and installed from
http://packages.ubuntu.com/wily/i386/nspluginviewer/download

After that

sudo dpkg -i nspluginviewer_1.4.4-0ubuntu5_i386.deb

sudo nspluginwrapper -i /opt/Adobe/Reader9/Browser/intellinux/nppdf.so

nspluginwrapper -l
/usr/lib/mozilla/plugins/npwrapper.nppdf.so
  Original plugin: /opt/Adobe/Reader9/Browser/intellinux/nppdf.so
  Plugin viewer: /usr/lib/nspluginwrapper/i386/linux/npviewer
  Wrapper version string: 1.4.4-1


sábado, 14 de mayo de 2016

Network manager error

[   27.379197] init: network-manager main process (946) killed by SEGV signal
[   27.379216] init: network-manager main process ended, respawning
[   27.499154] init: network-manager main process (956) killed by SEGV signal
[   27.499177] init: network-manager main process ended, respawning
[   27.562899] init: network-manager main process (962) killed by SEGV signal
[   27.562923] init: network-manager main process ended, respawning
[   27.626491] init: network-manager main process (969) killed by SEGV signal
[   27.626515] init: network-manager main process ended, respawning


Solved:

https://bugs.launchpad.net/ubuntu/+source/network-manager/+bug/1539634
http://askubuntu.com/questions/727127/last-upgrade-crashes-network-manager-no-internet-connection-no-applet


sudo ifconfig eth0 up
sudo dhclient
sudo apt-get install libnl-3-200=3.2.21-1 libnl-route-3-200=3.2.21-1 libnl-genl-3-200=3.2.21-1
sudo service network-manager restart



miércoles, 17 de febrero de 2016

Pendrive unable to read "error -71" "unable to enumerate USB device"

A 8GB pendrive was not working in windows, and the owner gave it to me because I use linux and "she heard it is more powerful"

Just inserted in linux, it wasn't working
dmesg output

Feb 17 13:08:51 invitado kernel: [  125.540289] usb 5-1: new full-speed USB device number 2 using uhci_hcd
Feb 17 13:08:52 invitado kernel: [  125.956083] usb 5-1: device not accepting address 2, error -71
Feb 17 13:08:53 invitado kernel: [  126.892059] usb 5-1: new full-speed USB device number 6 using uhci_hcd
Feb 17 13:08:53 invitado kernel: [  127.304292] usb 5-1: device not accepting address 6, error -71

Feb 17 13:09:18 invitado kernel: [  152.228211] usb 5-1: device descriptor read/64, error -71
Feb 17 13:09:27 invitado kernel: [  161.192330] hub 5-0:1.0: unable to enumerate USB device on port 1
 

Some googling
https://paulphilippov.com/articles/how-to-fix-device-not-accepting-address-error No way ... my webcam is also USB

Second attemp
http://askubuntu.com/questions/117524/usb-device-not-accepting-address   

Changed kernel and reboot, same message, not working

Without reboot, the same link has more info
$ sudo -s
# cd /sys/bus/pci/drivers/uhci_hcd
# echo */usb5
# echo 0000:... > unbind 


I tested with usb5, and after some time, it worked

Feb 17 13:16:51 invitado kernel: [  605.137210] uhci_hcd 0000:00:1d.0: remove, state 4
Feb 17 13:16:51 invitado kernel: [  605.137223] usb usb5: USB disconnect, device number 1
Feb 17 13:16:51 invitado kernel: [  605.143482] uhci_hcd 0000:00:1d.0: USB bus 5 deregistered

...
Feb 17 13:18:02 invitado kernel: [  676.036272] usb 6-1: device not accepting address 27, error -71
Feb 17 13:18:05 invitado kernel: [  679.004846] usb 2-1: new high-speed USB device number 6 using ehci-pci
Feb 17 13:18:05 invitado kernel: [  679.027777] usb 2-1: New USB device found, idVendor=1516, idProduct=1213
Feb 17 13:18:05 invitado kernel: [  679.027790] usb 2-1: New USB device strings: Mfr=1, Product=2, SerialNumber=3
Feb 17 13:18:05 invitado kernel: [  679.027797] usb 2-1: Product: DISK 2.0
Feb 17 13:18:05 invitado kernel: [  679.027803] usb 2-1: Manufacturer: USB
Feb 17 13:18:05 invitado kernel: [  679.027808] usb 2-1: SerialNumber: 0016E667DC4FA9C122CFB75A
Feb 17 13:18:05 invitado mtp-probe: checking bus 2, device 6: "/sys/devices/pci0000:00/0000:00:1d.7/usb2/2-1"
Feb 17 13:18:05 invitado mtp-probe: bus: 2, device: 6 was not an MTP device
Feb 17 13:18:05 invitado kernel: [  679.118474] usb-storage 2-1:1.0: USB Mass Storage device detected
Feb 17 13:18:05 invitado kernel: [  679.121708] scsi6 : usb-storage 2-1:1.0
Feb 17 13:18:05 invitado kernel: [  679.121821] usbcore: registered new interface driver usb-storage
Feb 17 13:18:06 invitado kernel: [  680.120776] scsi 6:0:0:0: Direct-Access     USB      DISK 2.0         1.00 PQ: 0 ANSI: 2
Feb 17 13:18:06 invitado kernel: [  680.123775] sd 6:0:0:0: Attached scsi generic sg2 type 0
Feb 17 13:18:06 invitado kernel: [  680.125789] sd 6:0:0:0: [sdb] 16035840 512-byte logical blocks: (8.21 GB/7.64 GiB)
Feb 17 13:18:06 invitado kernel: [  680.128287] sd 6:0:0:0: [sdb] Write Protect is off
Feb 17 13:18:06 invitado kernel: [  680.128293] sd 6:0:0:0: [sdb] Mode Sense: 23 00 00 00
Feb 17 13:18:06 invitado kernel: [  680.129111] sd 6:0:0:0: [sdb] No Caching mode page found
Feb 17 13:18:06 invitado kernel: [  680.129118] sd 6:0:0:0: [sdb] Assuming drive cache: write through
Feb 17 13:18:06 invitado kernel: [  680.133230] sd 6:0:0:0: [sdb] No Caching mode page found
Feb 17 13:18:06 invitado kernel: [  680.133237] sd 6:0:0:0: [sdb] Assuming drive cache: write through
Feb 17 13:18:07 invitado kernel: [  680.890912]  sdb: sdb1
Feb 17 13:18:07 invitado kernel: [  680.896727] sd 6:0:0:0: [sdb] No Caching mode page found
Feb 17 13:18:07 invitado kernel: [  680.896740] sd 6:0:0:0: [sdb] Assuming drive cache: write through
Feb 17 13:18:07 invitado kernel: [  680.896744] sd 6:0:0:0: [sdb] Attached SCSI removable disk
Feb 17 13:18:08 invitado udisksd[2165]: Mounted /dev/sdb1 at /media/enrique/MIRIAM on behalf of uid 1000