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
 

lunes, 13 de julio de 2015

Unable to download/upgrade apps with google play, analysis, workaround, not yet good solution...

I began to suffer the next problem:
With a lot of free space on device, Google Play says it is unable to upgrade some apps

Message
"Error
Error downloading "xxxxx". There is insufficient space on the device"

It happens even with the smallest upgrade o new app (for example goo.gl URL Shortener, less than 1 MB, unable to be installed just after uninstall!!!!)

Just googling, I found this link, which points to "Google Play Services" 

http://forums.androidcentral.com/android-4-1-4-2-4-3-jelly-bean/450097-fixed-error-downloading-app-name-there-insufficient-space-device.html#post4054747

I found somewhere that removing Google Play Services upgrade / downgrading to factory version it began to work, and testing it, it works:
-Step 1: remove  Google Play Services upgrades
-Step 2: install app ugrades previously failing
-Step 3: reboot phone and reinstall again Google Play Services upgrades (Google Maps and Google Mail need last version!)

But it seems to be a temporal solution, as the error reappears
(It seems to be the same situation described here, just works for 5-10 mins http://android.stackexchange.com/questions/91840/regarding-the-error-downloading-insufficient-space-error-in-the-google-play-s)

So most times I have a new upgrade I have to do the whole process, so I need a real solution, not just a workaround.

Googling, I found more "patches" like this: http://www.pcadvisor.co.uk/how-to/google-android/how-fix-androids-insufficient-storage-available-error-message-3498845/ which indeed needs to install a new app... this is not a solution, as it seems you are going to have again the same problem, and it is just a tool to solve every time you have it.

This seems a real solution: to resize cache partition

http://android.stackexchange.com/questions/27083/google-play-error-downloading-app-insufficient-space

When I saw the error I checked this
shell@android:/ # df
Filesystem             Size   Used   Free   Blksize
...
/cache                 370M     6M   364M   4096


So it seems cache partition is not full ... and this is not exactly the problem?
I tried to remove just "Google Play Services" cache (663 KB to 0 KB), it took a while, and /cache partition usage did not change, and the error persists.



 
It seems clear it is a Gooble Play Services bug, I will try to search for a Google report about this and a good solution, not just a patch.
In XDA I found this post, somehow related
http://forum.xda-developers.com/showthread.php?t=1766378


Any new idea or new info will be appreciated!
I will edit this post with new info

Edit 2015/07/17: Tested that after five app install, same message appearse and I am not able to upgrade more apps, not just "Google Play Services". After reboot, with old Google Play Services, all apps are installed ok, including Google Play Services upgrade ...

Edit 2015/08/09: Tested that the same app can be installed from Fdroid if available, and even really big apps (like LibreOffice reader, 50 MB), so it is really a Google Play Services bug. Trying to install an app from web google play, it does install ok?

Edit 2015/08/21: It seems finally solved, but not intentionally. It has been working during last week. How? I decided to replace Twitter official client (it was installed as system app, so I removed it with Titanium backup), and I installed twidere (available in Google Play and F-Droid). After that, Google Play updates run smoothly ... maybe Google Play is not ready to find "wrong system apps", like a "system twitter".

Edit 2015/08/26: same problem, but message has changed.
It happened with a whatsapp update, after a lot of updates without problem, and after I installed some new apps from Google Play also without problem. Same workaround has worked with whatsapp update. Today it was happening with gmail update,I  was going to put here error message in english, but after changing language in settings ... it worked!
With spanish language again it fails again !
"Espacio de almacenamiento insuficiente
No hay suficiente espacio en este dispositivo para descargar "(nombre app)". Puedes eliminar aplicaciones o contenido que ya no necesites y volver a intentarlo.
[CANCEAR] [VER ALMACENAMIENTO]"
Somehow some google services are restarted after language change: for example gmail notifications reappear.
But in english again, same error
"Insufficient storage
This device doesn't have enough space to download "(app name). Consider deleting apps or content you no longer need and try again.
[CANCEL] [VIEW STORAGE]"

It will continue ...

sábado, 25 de abril de 2015

Tracking twitter and TTYtter

I would like to know if a special word appears in twitter ...

I found some tools
http://www.socialbrite.org/2011/01/11/guide-to-free-social-media-monitoring-tools/
but most of them are not free, just 30 days free trial.

But in previous link

  • Track is a little-known Twitter feature that lets you track keywords and have them sent directly to your mobile phone as soon as they’re posted.
It seems really old (2007) and it seems SMS is mandatory?
https://blog.twitter.com/2007/tracking-twitter

After some googling I found this
http://www.floodgap.com/software/ttytter/
No problem with ubuntu 14.04 to install with apt-get, and configure it

...
** This wizard will overwrite /home/enrique/.ttytterkey
Press RETURN/ENTER to continue or CTRL-C NOW! to abort.


Request from https://api.twitter.com/oauth/request_token ... SUCCEEDED!

1. Visit, in your browser, ALL ON ONE LINE,

https://api.twitter.com/oauth/authorize?oauth_token=xxxxxxx

2. If you are not already signed in, fill in your username and password.

3. Verify that TTYtter is the requesting application, and that its permissions
are as you expect (read your timeline, see who you follow and follow new
people, update your profile, post tweets on your behalf and access your
direct messages). IF THIS IS NOT CORRECT, PRESS CTRL-C NOW!

4. Click Authorize app.

5. A PIN will appear. Enter it below.

Enter PIN> xxxxx

Request from https://api.twitter.com/oauth/access_token ... SUCCEEDED!
Written keyfile /home/enrique/.ttytterkey

Now, restart TTYtter to use this keyfile.
(To choose between multiple keyfiles other than the default .ttytterkey,
 tell TTYtter where the key is using -keyf=... .)



How to send a track command?
With my first attempt "track" in comand line  ... result is a tweet with "track" text

http://www.splitbrain.org/blog/2008-01/22-list_of_twitter_commands

Trying with "/track word" it says
/track word
*** changed: track => word
*** (transmitting to background)
*** changed: track => word




Maybe is just that.
But how to test it works?

With /track I can't see expected result "Ask twitter to return a list of all currently tracked terms. " but
TTYtter> /track
*** invalid command
*** to pass as a tweet, type /%%





http://www.floodgap.com/software/ttytter/#built

With Ctrl+C I see
cleaning up.
*** you were tracking:
-track='word'

So it seems it is just for that session. Running again ttytter and quiting, it says just "cleaning up."

martes, 3 de febrero de 2015

N9000W malware finally found: com.skymobi.lockframe.iphone , /system/app/mopolocker.3xnote3_v3.032_20131127_suntel.apk

After some time, I noticed again new unwanted installations

http://sesionesfrikis.blogspot.com.es/2015/01/kinguser-replacement-by-superuser-by.html

I include here some screenshots
There is an "i" inside a circle notification 

And this informs a new app was installed "BubbleShoot"... not by me
Another app was installed at the same time "GoLink"
 A long press in "BubbleShoot" notification finally shows the app involved ... where is malware

App name is "SamsungNote3Locker", package "com.skymobi.lockframe.iphone"
with /system/app/mopolocker.3xnote3_v3.032_20131127_suntel.apk
I removed this package with Titanium backup, and I finally hope malware is removed.
I also checked no more com.skymobi.* packages are present with "pm list packages"

I found this package appears in some websites:
- AVG antivirus http://www.avgthreatlabs.com/android-app-reports/app/com.skymobi.lockframe.iphone/ 
Where it says "Active malware!
During the last 7 days potentially active malware was detected for this android app. (updated Feb 03, 2015 GMT) "

- In this forum, also with M-HORSE N9000W
"Aplicación maliciosa que instala aplicaciones sin hacer nada"
http://www.movilesdualsim.com/tema/aplicacion-maliciosa-que-instala-aplicaciones-sin-hacer-nada.85963/

- In this forum, where it appears "baidu browser" and "share it", some apps I also saw installed ...
http://forums.androidcentral.com/samsung-galaxy-s2/453282-mobile-internet-has-coo123-popup-anyone-know-how-fix.html

Edit: testing Sophos security, it find ExpandPointWall.apk "Potentially unwanted app. Category: Adware" in /storage/sdcard0/.1/ExpandPointWall.apk

Looking for *skymobi* files, I found:

/storage/sdcard0/Android/data/com.skymobi.pay.newsdk/
/storage/sdcard0/skymarket/com.skymobi.mopoplay.appstore/

viernes, 30 de enero de 2015

kinguser replacement by superuser by Koush.... but N9000W still has malware

I wrote in XDA (I am hunktb user)
http://forum.xda-developers.com/showpost.php?p=58491927&postcount=27
"I finally managed to replace kinguser with superuser (opensource, com.koushikdutta.superuser), so I have a clean system.
The phone is still rooted and new superuser app works fine."

http://forum.xda-developers.com/showpost.php?p=58492531&postcount=17

But after that (4 days ago,  no kinguser installed), I still have some malware:
In notification appears an "i" and it informs some app has been installed, for example
com.skymobi.oversea.gamecenter
com.skymobi.mopoplay.appstore
Another notification was about Whatsapp, already installed (but I think it would have been installed if it wasn't)

Internet Security detects malware in RomasterSu_1.1.4_140611_1000.apk used, but nothing installed.
Where is malware?
-I removed Cooee Kauncher (com.cooee.launcherS4)
-I removed kinguser

 With titanium backup I found two more apps I also removed:
-com-cooee.digitalclock (Digital Clock)
-com.cooee.floatwindow (FlasBarService)


I see an app with chinese name, package com.mediatek.factorymode
¿I should look for init script and review something not listed as package?
or ... maybe, new idea, ... if it installs app it could be a fake /malware Google Play???

Googling it
https://blog.gdatasoftware.com/blog/article/android-smartphone-shipped-with-spyware.html

Looking with titanium, Google Play Store 5.1.1 package is "com.android.vending", and it has some updates applied
If I remove updates, initial version is 4.6.17, and it updates again to 5.1.1, it seems from Google ...

I need more time, more ideas ...




lunes, 5 de enero de 2015

adbcontrol

Interesting tool
Used with my broken screen phone
http://marian.schedenig.name/2014/07/03/remote-control-your-android-phone-through-adb/
Just edited config.properties to put adb path
A little bit slow in screen refresh, but it works

domingo, 4 de enero de 2015

ijoy stone 4GB root and adb with ubuntu

I used chinese version iRoot2_2.0.6_141122_1811_1000_r.apk
and it intalled chinese root (com.mgyun.superuser in /system/app/irootsu.apk), but I installed superuser from koush using fdroid and it replaced it ok

adb shell does not work, despite setting usb debugging in config and tablet says "USB debugging enabled" when plugged

Some tests

adb shell
error: device not found

adb devices
List of devices attached


lsusb
Bus 002 Device 014: ID 2207:0010  

dmesg output when plugged

[ 7911.216166] usb 2-1: new high-speed USB device number 16 using ehci-pci
[ 7911.350384] usb 2-1: New USB device found, idVendor=2207, idProduct=0010
[ 7911.350396] usb 2-1: New USB device strings: Mfr=2, Product=3, SerialNumber=4
[ 7911.350403] usb 2-1: Product: Tablet Stone
[ 7911.350410] usb 2-1: Manufacturer: i-Joy
[ 7911.350415] usb 2-1: SerialNumber: D902013112900035A
[ 7911.352183] usb-storage 2-1:1.0: USB Mass Storage device detected
[ 7911.352403] scsi16 : usb-storage 2-1:1.0
[ 7912.353713] scsi 16:0:0:0: Direct-Access     i-Joy                          PQ: 0 ANSI: 2
[ 7912.354288] scsi 16:0:0:1: Direct-Access     i-Joy                          PQ: 0 ANSI: 2
[ 7912.356480] sd 16:0:0:0: Attached scsi generic sg2 type 0
[ 7912.356918] sd 16:0:0:1: Attached scsi generic sg3 type 0
[ 7912.364920] sd 16:0:0:0: [sdb] Attached SCSI removable disk
[ 7912.365533] sd 16:0:0:1: [sdc] Attached SCSI removable disk


Editing "/etc/udev/rules.d/99-android.rules, adding this and restarting does not solve it

SUBSYSTEM=="usb", ATTRS{idVendor}=="2207", ATTRS{idProduct}=="0010", MODE="0666"

sudo /etc/init.d/udev restart

Nothing new adding 0x2207 in .android/adb_usb.ini

But after all this, I decided to reboot ubuntu ... and then it worked





lunes, 29 de diciembre de 2014

M-HORSE N9000W

Edit: look here http://sesionesfrikis.blogspot.com.es/2015/02/n9000w-malware-finally-found.html

I received this new phone, and everything seems ok
Rooted with RoomMaster SU v2.0.8
http://www.mgyun.com/romastersu

After that, I made titanium backup from previous phone: Whatsapp, Telegram...
and everything ok

With titanium backup app I removed unwanted apps: Facebook Msn, yahoo, ...
Du Speed Booster, APUS Launcher, PlayApp


I see "Cooee launcher S4" and I am not sure if it is malware

I installed Nova Launcher, and Security Lock Screen, but I want to be sure if I can remove this launcher without side effects: in my previous phone there were some situations where previous launcher was started ...
After several days, I see some apps installed automatically... MALWARE!!!
Some of them (I think some of the removed also, like Du Speed Booster or something similar, about battery http://forums.androidcentral.com/general-help-how/365217-random-apps-keep-installing-themselves.html )
ShareIt: cc.taosha.toolbox.shareit (/data/app/cc.taosha.toolbox.shareit-1.apk)
Baidu Browser: com.baidu.browser.inter (/data/app/com.baidu.browser.inter-1.apk)

Avast detects shareit as a trojan, and Kinguser (com.kingroot.kinguser) as potentially unwanted.

There are two possibilities for me: Cooee Launcher S4" or may be king root
I see /system/app/cooee_note3_20131218.apk
Googling it some people suggest to do a factory reset... but it won't work, as it comes by default...
http://answers.informer.com/variations/663134/how-to-uninstall-cooee-launcher-s4/

http://www.techsupportquestions.com/2411/uninstall-launcher-malware-internal-storage-android-phone

 ¿but wich one? CooeLauncher is a system app, and removal seems to be dangerous (after nova install, I can make a backup with Titanium backup, and there is a /system/app mover app in Fdroid, but by making it user app instead system may not work). In the other hand, kinguser is started initially (it can be seen with SD Maid), and so it could make it.
I am going to remove kingroot, and after that check for some time. Kingroot can be installed again with romastersu if I need it...

One of unwanted apps is in chinese, as Romastersu ...
https://play.google.com/store/apps/details?id=cc.taosha.toolbox.shareit

The others
https://play.google.com/store/apps/details?id=com.baidu.browser.inter


One of the worst things: these unwanted apps are not only installed but also downloaded? at any time, I think that consuming bandwidth and bytes... but I am not able to identify anything in android traffic usage, as apps are small.

Update: after one day without kinguser, no more unwanted apps. I decided to install iRoot (iRoot2_2.0.6_141122_1811_1000_r.apk) which also install kinguser, and with app remover I noticed that

root@android:/storage/sdcard0/mgyun/root/app # ls
co.mc.tools.batterybooster_1_542038_ad65a2f81e50808a9aec27affde98caa.apk
com.beagleboys.nfceveryday_4_522889_337d05b29a5e8a160825133213ede2ba.apk
com.beardcocoon.castcountdown.android_6_522890_9a9577e294a10e628320e77888a9d6bb.apk
com.btakoss.flashlightcompass_2_523078_d6299309474702d11f36cdbb24578a0d.apk
com.salyangoz.automessage_6_471851_6d32d80f002752c9ad71ceb96d14dcfe.apk

So chinese root tool includes apks ... and maybe the apks are not downloaded, but installed when kinguser, which starts automaticaly with phone, decides so.
These apk are asociated with the main menu

I made another test, and installed RomasterSu_2.0.9_141226_1816_1000_r.apk (I deleted 2.0.8 version), and it did not put apks in the same folder.
I installed again iRoot2_2.0.6_141122_1811_1000_r.apk and I noticed the same folder is initially empty, so maybe it downloads it later, and it install them ... I can confirm the apps are installed without any prompt / user confirmation.

I should try to change kinguser by another su utility like superSU, but it seems not to be trivial: downloading from google play it does not install properly, it says su binary has to be udpated and it is unable to update it, so superSU finally does not work.



sábado, 22 de noviembre de 2014

Aswering calls from upper half screen operative...

I have ordered a new phone, but in the meanwhile, I need to answer calls

https://play.google.com/store/apps/details?id=com.sch.answergesturefree

... reducing thresold (negative) value, and drawing just a horizontal line in the upper part of the screen, I can answer calls.

To end calls, I have configured power button in android

miércoles, 19 de noviembre de 2014

Recovering files from android with broken and unresponsive screen

Mi "new phone" (August) is broken: my daughter was playing with it and it felt to the floor, and screen is broken.
It charges, usb works, buttons are working, but I am unable to even unlock screen, so I am unable un activate it as usb storage.

I have adb access, so I need to recover just files from internal memory; contacts and calendar are in gmail, so the info to extract are just some photos. 


Instead of using adb pull / adb push for each file, ... searching I found this

http://qtadb.wordpress.com/download/


After that, I discovered that:
Unlock movements:

input swipe 100 700 600 300

Entering PIN:
input tap 300 500 is "5"
input tap 300 600 is "0"
input tap 100 500 is "4"
input tap 400 600 is "enter"

input keyevent 4 is "return"
input keyevent 82 is "menu"
http://developer.android.com/reference/android/view/KeyEvent.html


With that I have been able to remove screen lock configuration...

sábado, 18 de octubre de 2014

.org and .es domains info. Cancelling .org domain in 1and1

Some time ago I bought two domains, .es and .org and I associated them to a Google Site.
In the beginnig the price was just 5€ each one, but after several years I realized I am not using at all .org domain, and, more important, .org domain "exposes" to all people personal data (email, phone number, even postal address!!...)

http://whois.domaintools.com/
Example for my .org domain (... replace personal data!)
Registrant ID:...
Registrant Name:...
Registrant Organization:
Registrant Street: ...
Registrant City:..
Registrant State/Province:...
Registrant Postal Code:...
Registrant Country:ES
Registrant Phone:+34.6...
Registrant Phone Ext:
Registrant Fax:
Registrant Fax Ext:
Registrant Email:...


With .es domain this info is not so detailed, because it appears 1and1.
% NOTE: The registry for this domain name does not publish ownership
%       records (whois records) in the standard format.  This data
%       represents the most likely status of the domain based on
%       information provided by the Internet's domain name servers (DNS).

domain: xxxx.es
status: taken
nameserver: ns63.1and1.es
nameserver: ns64.1and1.es

% For more information, please visit http://www.nic.es/


www.nic.es redirects... Looking in
http://www.dominios.es/dominios/es/busca-tu-dominio
And there, info is just mail and name, but no phone number and postal address
https://www.nic.es/sgnd/dominio/publicDetalleDominio.action

DATOS DEL TITULAR
Nombre del Dominio xxx.es
Estado Activado
Identificador ...
Titular ...
Fecha de Alta 16-10-2012
Fecha de Caducidad 16-10-2015
Agente Registrador 1&1 INTERNET
PERSONA DE CONTACTO ADMINISTRATIVO
  wedge
Identificador 60D5D7-ESNIC-F5
Nombre ...
Email ...
 
PERSONA DE CONTACTO TECNICO
wedge
Identificador 2A7DD0-ESNIC-F5
Nombre Hostmaster ONEANDONE
Email hostmaster@1and1.es
 

SERVIDORES DNS
Nombre Servidor IP
ns63.1and1.es 217.160.82.170
ns64.1and1.es 217.160.83.170

So I decedid to cancel .org domain.

I didn't see any option about cancel in control panel, https://clientes.1and1.es/
Googling, I finally found this
http://www.joomlaempresa.es/es/tutoriales/trucos-para-webmaster/125-como-dar-de-baja-un-dominio-en-1and1.html

Login in https://contrato.1and1.es/ I was able to cancell .org keeping .es domain at the same time. I fixed the ending date as the date where end my contract for that domain: meanwhile I am going to redirect  .org domain redirecting to a page where I inform that I am no longer using .org domain (right now I was redirecting both to the same Google site)

jueves, 9 de octubre de 2014

Removing old kernels in ubuntu

A very simple one:
Each time kernel is updated I realize there is some disk wasted with previous versions: I do not have grub menu, but I imagine it will contain a lot of them.

Looking for some info
https://help.ubuntu.com/community/Lubuntu/Documentation/RemoveOldKernels
It is easy to do it manually

But ¿how to do it automatically?
http://ubuntuforums.org/showthread.php?t=1961409
It seems some script on boot will do the job, but I think I will do it manually :-)

miércoles, 1 de octubre de 2014

error: malformed file, press any key to continue. Ubuntu solution

Just getting this message on boot and looking for info
https://bugs.launchpad.net/ubuntu/+source/grub2/+bug/1311247
Reading comments, this one is interesting
https://bugs.launchpad.net/ubuntu/+source/grub2/+bug/1311247/comments/25
There are serveral links to workarounds, like this one
https://forum.manjaro.org/index.php?topic=10354.msg103451#msg103451but some people say no workaround work for them, and it appears to be a real solution
https://bugs.launchpad.net/ubuntu/+source/grub2/+bug/1311247/comments/80
So, the more logical things to do are:
1- to wait for a grub2 update
2- look for a grub2 update compiled package
3- compile and install a grub2 update

The error is not critical, so it seems #3 is too much. 

Just looking for the grub2 version installed, there wasn't installed? (I do not use grub menu, I have just ubuntu installed, so it may be not necessary)
dpkg -l grub or grub2
So I try
sudo apt-get install grub2
And it install it!

Se instalarán los siguientes paquetes NUEVOS:
  grub2
...

Preparing to unpack .../grub2_2.02~beta2-9ubuntu1_amd64.deb ...
Unpacking grub2 (2.02~beta2-9ubuntu1) ...

After that I try
dpkg -l grub*
and it shows
||/ Nombre                          Versión              Arquitectura         Descripción
+++-===============================-====================-====================-====================================================================
un  grub                            <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
ii  grub-common                     2.02~beta2-9ubuntu1  amd64                GRand Unified Bootloader (common files)
un  grub-coreboot                   <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-doc                        <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-efi                        <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-efi-amd64                  <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-efi-ia32                   <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-efi-ia64                   <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-emu                        <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
ii  grub-gfxpayload-lists           0.6                  amd64                GRUB gfxpayload blacklist
un  grub-ieee1275                   <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-legacy                     <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-legacy-doc                 <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-linuxbios                  <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
ii  grub-pc                         2.02~beta2-9ubuntu1  amd64                GRand Unified Bootloader, version 2 (PC/BIOS version)
ii  grub-pc-bin                     2.02~beta2-9ubuntu1  amd64                GRand Unified Bootloader, version 2 (PC/BIOS binaries)
un  grub-xen                        <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
un  grub-yeeloong                   <ninguna>            <ninguna>            (no hay ninguna descripción disponible)
ii  grub2                           2.02~beta2-9ubuntu1  amd64                GRand Unified Bootloader, version 2 (dummy package)
ii  grub2-common                    2.02~beta2-9ubuntu1  amd64                GRand Unified Bootloader (common files for version 2)

So I see the package used is grub-pc (and I uninstall grub2 package)

Looking for #1 and #2, in new ubuntu version 14.10 utopic unicorn
https://launchpad.net/ubuntu/utopic/+package/grub-pc
there are .deb packages, but I am not sure if fix is included.
https://launchpad.net/ubuntu/utopic/+source/grub2/2.02~beta2-14
So I will wait for ubuntu 14.10, and after that, I will try again if I have time.


martes, 30 de septiembre de 2014

Inkscape trunk from PPA in ubuntu 14.04, error loading .svg files from wikimedia

I was trying to edit some .svg files from wikimedia
http://commons.wikimedia.org/wiki/File:Plum_pudding_atom.svg
http://commons.wikimedia.org/wiki/File:Rutherford_gold_foil_experiment_results.svg
But using inkscape from ubuntu 14.05 I was getting an error: unable to load.

Running from console
inkscape Rutherford_gold_foil_experiment_results.svg
...Rutherford_gold_foil_experiment_results.svg:18: namespace warning : xmlns: URI &ns_svg; is not absolute
     xmlns="&ns_svg;" xmlns:xlink="&ns_xlink;" xmlns:a="http://ns.adobe.com/AdobeSV
                     ^

...
Just searching it seems to be a bug
https://bugs.launchpad.net/inkscape/+bug/166371
and it seems logical, as one of .svg files says
Drawn by User:Fastfission in Illustrator and Inkscape. --Fastfission 15:04, 14 April 2008 (UTC)
It appears as fixed in Inkscape 0.48.5... but in ubuntu I have 0.48.4
So... I check this
https://launchpad.net/~inkscape.dev/+archive/ubuntu/trunk
and I install inkscape-trunk, which removes inkscape  (I also have LibreOfficeDev which coexists with LibreOffice)... and it works.