xrdp_sec_incoming: error reading /etc/xrdp/rsakeys.ini file

xrdp_sec_incoming: error reading /etc/xrdp/rsakeys.ini file  

Fix : run xrdp as root

Visual Studio 2010 and "Cannot publish because a project failed to build".

Problem is with visualmicro addon.

Tools->add-in manager - > Visual Micro Arduino
Uncheck "start" and "command line" and everything works

Apps on my Toshiba Thrive

Box.net
Stopwatch & Timer
PaintJoy
QuickPic
Whiteboard Pro
SSHDroid
Earth
Wifi Analyzer
Opera Mobile
Copilot Live USA
ColorNote
MyFitnessPal
Amazon AppStore
Parcels
Google Sky Map
MX VIdeo Player
ES File Explorer
Adsense Dashboard
Dolphin for PAD
Skype
TeamworkPM
Tapatalk
GetJar
Calculator
AdFree

My steps for rooting a toshiba thrive hmj 37.31.5.011

Toshiba thrive version HMJ 37.31.5.0011.

I got all the information from thriveforums.org threads.

1. Downgrade to HMJ37.01.5.0032
http://www.thriveforums.org/forum/dalepl-development/4359-downgrade-official-toshiba-hmj37-31-5-0011-hmj37-01-5-0032-rollback.html

2.) Boot into recovery mode ( power off -> hold power + volume up)
3.) Select white package, select 'install update from external card'
4.) Reboot - thrive is downgraded
5.) Turn on usb debugging in settings -> applications -> development
6.) Download dalenet easy flash tool http://www.thriveforums.org/forum/dalepl-development/1974-root-tool-dalenet-thrive-10-1-easy-flash-tool.html
7.) Download a rooted ROM
8.) Extract easy flash tool
9.) Plug in thrive, install adb drivers (they were part of easy flash tool zip) (takes a while)
10.) PS C:\Users\youri\Downloads\DaleNet-Thrive_10-Easy_Flash_Tool-v1.5\tools> .\adb.exe devices
* daemon not running. starting it now on port 5037 *
* daemon started successfully *
List of devices attached
280400643406517 device
11.) shutdown, boot into recovery mode
12.) select fast boot (usb icon)
13.) Device looks like hangs at 'starting usb download protocol'
14.) PS C:\Users\youri\Downloads\DaleNet-Thrive_10-Easy_Flash_Tool-v1.5\tools> .\fastboot.exe devices
?       fastboot
15.) Reboot it
16.)PS C:\Users\youri\Downloads\DaleNet-Thrive_10-Easy_Flash_Tool-v1.5\tools> .\fastboot.exe reboot
rebooting...

finished. total time: -0.000s

17.) Steps 9-16 confirm that the usb connection is good
18.) Reboot into fastboot again
19.) Run  thrive_easy_flash_tool.bat
20.) Select #1
21.) extract update.zip from rom image onto the sd card
22.) go to applications -> super user and update it
23.) root has been obtained
24. safe boot again
25.) thrive easy flash tool
26.) 3 - install  flash recovery
27.) Install clockwork
28.) thrive will hang at installing mrb image
29.) reboot into recovery, select the package icon
30.) should be in CWM mode, install zip from sdcard
31.) reboot from the cwm menu
32.) Should be on the right image now & rooted

VB.net defeat simple padding obfuscation

There is an applicationthat obfuscates a serial number by padding each character. Here is a de-obfuscator I made.

First: define the array with all the characters the algorithm uses:






    Public charArray() As Char = {"0", "1", "2", "3", "4", "5", "6", "7", "8", "9", _
                           "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", _
                           "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", _
                           "V", "W", "X", "Y", "Z"}

Function that will deobfuscate it.

    Private Function OffsetAChar(ByVal chartooffset As Char, ByVal offset As Integer)
        Dim posInArray As Integer = Array.IndexOf(charArray, chartooffset)
        Dim ArrayLength As Integer = charArray.Length

        If posInArray + offset = ArrayLength Then
            Return "0"
        End If

        If (posInArray + offset) <= ArrayLength And (posInArray + offset) > 0 Then
            Return charArray(posInArray + offset)
        End If

        If posInArray + offset = 0 Then
            Return 0
        End If

        If (posInArray + offset) < 0 Then
            Return charArray(ArrayLength + posInArray + offset)
        End If

        If (posInArray + offset) > ArrayLength Then
            Return charArray(Math.Abs(ArrayLength - (posInArray + offset)))
        End If

    End Function


Usage is simple:

        Dim charArray2() As Char

        Dim ArraySTring As String = txtDecode.Text
        ArraySTring = ArraySTring.Replace("-", "")
        charArray2 = ArraySTring

       txtCodeDecoded.Text += OffsetAChar(charArray2(0), -19).ToString.ToUpper


Figuring out the offset of two letters


    Public Function OffsetFinder(ByVal letter1 As Char, ByVal letter2 As Char)

        Dim CharPos1 = Array.IndexOf(charArray, letter1)
        Dim CharPos2 = Array.IndexOf(charArray, letter2)
        Return CharPos2 - CharPos1

    End Function

VB.net 2010 run an app, activate it, and send keys.

This isn't an elegant way to do it, but it works for me. It runs a program, sends alt+h, a, tab, then ctrl+c to copy text to a clipboard and puts the contents of the clipboard into a textbox.

In sendkeys:
 % = alt
vbTab = tab
^ = crl
{escape} = ESC

Imports System.Diagnostics.Process
Imports System.Threading

Public Class Form1


Public Sub GetSerials()
Dim pInfo As ProcessStartInfo = New ProcessStartInfo("C:\Program Files (x86)\CustomApp\Bin\customapp.exe")

      pInfo.WindowStyle = ProcessWindowStyle.Maximized
        Process.Start(pInfo)
        Thread.Sleep(3000)

AppActivate("CustomApp 1.1.5")


        System.Windows.Forms.SendKeys.SendWait("%")
        System.Windows.Forms.SendKeys.SendWait("h")
        System.Windows.Forms.SendKeys.SendWait("a")
        System.Windows.Forms.SendKeys.SendWait(vbTab)
        System.Windows.Forms.SendKeys.SendWait("^c")
        TextBox2.Text = (TextBox1.Text & " : " & Clipboard.GetText & vbCr)

        System.Windows.Forms.SendKeys.SendWait("{escape}")
        System.Windows.Forms.SendKeys.SendWait("%")
        System.Windows.Forms.SendKeys.SendWait("f")
        System.Windows.Forms.SendKeys.SendWait("q")



    End Sub


End Class

VB.net and oracle package that returns boolean

Public Function VALIDATE_NUMBER(ByVal num As String)

'connection string
 oraconnstring = "Data Source=" & OracleDataSource & ";User ID=" & OracleUserID & ";Password=" & OraclePassword & ";"

 'initialize command

        Dim oraclecmd As New OracleCommand
        oraConnection.Open()

        'Initiate the package command
        oraclecmd = oraConnection.CreateCommand
        oraclecmd.CommandType = CommandType.StoredProcedure
        oraclecmd.CommandText = "CUSTOM_PACKAGE.GET_NUM"

        'create parameters that will be passed with command
        Dim dbNum As OracleParameter
        Dim dbPartNum As OracleParameter
        Dim dbCode As OracleParameter
        'serialnumber is sent to package
        dbNum = oraclecmd.Parameters.Add("I_STR_NUMBER", OracleDbType.Varchar2)
        dbNum.Value = serialnum
        dbNum.Direction = ParameterDirection.Input
        dbNum.Size = 25
        'value is modified by oracle package
        dbPartNum = oraclecmd.Parameters.Add("O_STR_PART_NUMBER", OracleDbType.Varchar2)
        dbPartNum.Value = DBNull.Value
        dbPartNum.Direction = ParameterDirection.InputOutput
        dbPartNum.Size = 25
        'value is modified by oracle package
        dbCode = oraclecmd.Parameters.Add("O_STR_HEAT_CODE", OracleDbType.Varchar2)
        dbCode.Value = DBNull.Value
        dbCode.Value = "default"
        dbCode.Direction = ParameterDirection.InputOutput
        dbCode.Size = 25
        oraclecmd.ExecuteNonQuery()
'populate class
       numinfo.PartNumber = dbForgingPartNum.Value.ToString
       numinfo.Code = dbHeatCode.Value.ToString
 
 
        Return numinfo
 
        oraConnection.Dispose()
end function
-------------
if the package returns a boolean value, which vb.net/oracle adapter can't handle, then a solution is to create a wrapper around that package.
  oraclecmd = oraConnection.CreateCommand
 
        'initiate return value
        Dim ReturnValue As OracleParameter = oraclecmd.Parameters.Add(":ReturnValue", OracleDbType.Varchar2)
        ReturnValue.Direction = ParameterDirection.Output
        ReturnValue.Size = 1
 
        'Wrapper for the stored function (anonymous block)
        'boolean datatype is not available outside of pl/sql
 
        oraclecmd.CommandType = CommandType.Text
        oraclecmd.CommandText = "declare tmp boolean; ReturnValue varchar2(1) ;begin tmp := FS.GETSN('" & value & "');if tmp = true then :ReturnValue := 'T'; else ReturnValue := 'F'; end if; end;"
 
        'execute the anonymous block
        oraclecmd.ExecuteNonQuery()
 
        'convert returnvalue into a string
        Dim a As String = oraclecmd.Parameters(":ReturnValue").Value.ToString
A will be T or F.

pacman-key --init not enough random bytes available

Running pacman-key I get



[youri@slavluv ~]$ sudo pacman-key --init
gpg: Generating pacman keychain master key...


Not enough random bytes available.  Please do some other work to give
the OS a chance to collect more entropy! (Need 284 more bytes)

1.) Get RNG-TOOLS 

a.)[youri@slavluv aur]$ wget http://aur.archlinux.org/packages/rn/rng-tools/rng-tools.tar.gz

b.)[youri@slavluv aur]$ tar zxvf rng-tools.tar.gz

c.)[youri@slavluv aur]$ cd rng-tools

d.)[youri@slavluv rng-tools]$ makepkg -s

e.)[youri@slavluv rng-tools]$ sudo pacman -U rng-tools-3-2-i686.pkg.tar.xz

f.) change timeout=0 to timeout=10 in /etc/conf.d/rngd

2.) [youri@slavluv rng-tools]$ sudo rngd -f -r /dev/urandom

3.) [youri@slavluv ~]$ sudo pacman-key --init

Password:

gpg: Generating pacman keychain master key...

....+++++

................+++++

gpg: key DBCCC88E marked as ultimately trusted

gpg: Done

==> Updating trust database...

gpg: 3 marginal(s) needed, 1 complete(s) needed, PGP trust model

gpg: depth: 0  valid:   1  signed:   0  trust: 0-, 0q, 0n, 0m, 0f, 1u

Trying to play GTA vice city under linux with wine.

First I need to install wine:

[youri@slavluv Downloads]$ sudo pacman -S wine

Now to configure wine and create all the folders, and it also installs gecko packages. In config I added drive D: as /tmp/CD

[youri@slavluv Downloads]$ winecfg

Make the folder in CD in tmp and mount the iso. "-o loop" (modprobe loop if it's not loaded)

[youri@slavluv tmp]$ mkdir CD
[youri@slavluv tmp]$ sudo mount -o loop /home/youri/Downloads/Grand\ Theft\ Auto\ Vice\ City\ -\ PC/GTA_Vice_City.iso CD/

Run the setup:

[youri@slavluv tmp]$ wine CD/setup.exe




Went through install (did not choose to use radio stations)

Using the no-cd crack (I have the cd but not cd-rom drive, so I have to download it, it's not illegal if you have the licensed CD)

[youri@slavluv Grand Theft Auto Vice City - PC]$ cp -f Crack/gta-vc.exe /home/youri/.wine/drive_c/Program\ Files/Rockstar\ Games/Grand\ Theft\ Auto\ Vice\ City/


Now I went to install directory ( /home/youri/.wine/drive_c/Program Files/Rockstar Games/Grand Theft Auto Vice City ) and ran wine gta-vc.exe


It messed up my screen/didn't work.

Mounting the play CD the same way I did the install CD loaded the game. All the textures are blocky though. Probably would work fine at this point for someone with a decent video card..


Errors:

fixme:d3d:CompareFunc Unrecognized WINED3DCMPFUNC value 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:swapchain_gl_present Render-to-fbo with WINED3DSWAPEFFECT_FLIP
fixme:d3d:CompareFunc Unrecognized WINED3DCMPFUNC value 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:swapchain_gl_present Render-to-fbo with WINED3DSWAPEFFECT_FLIP
fixme:d3d:CompareFunc Unrecognized WINED3DCMPFUNC value 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:StencilOp Unrecognized stencil op 0
fixme:d3d:swapchain_gl_present Render-to-fbo with WINED3DSWAPEFFECT_FLIP
fixme:d3d:CompareFunc Unrecognized WINED3DCMPFUNC value 0

Disabling "Allow pixel shader" in wine settings  fixes the blockiness. Game is still slow though.

lighttpd fastcgi issues

Suddenly "mod_fastcgi" being enabled in "server.modules" for lighttpd is causing problems.

 2011-04-21 19:30:58: (log.c.166) server started
2011-04-21 19:30:58: (mod_fastcgi.c.978) bind failed for: unix:/var/run/lighttpd/php-fastcgi.socket-0 Permission denied
2011-04-21 19:30:58: (mod_fastcgi.c.1399) [ERROR]: spawning fcgi failed.
2011-04-21 19:30:58: (server.c.938) Configuration of plugins failed. Going down.

Fix:

[youri@nemesis run]$ sudo gpasswd -a youri http
Password:
Adding user youri to group http

Or I should maybe make lighttpd run as http user again.

Mapping the cell locations from an iphone db on google maps

IOs stores the GPS locations of towers it connects to in this file:

/var/root/Library/Cache/locationd/consolidated.db

It's an sqlite3 file... So here is a script to pull the longtitude and lattitudes and turn them into a simple KML file.

#/bin/bash

#this is the KML heading
echo '<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.0">
<Document>

  <name>youri</name>'
 
#pull the longitude and latitude from sqlite3
for i in $(sqlite3 consolidated.db 'select longitude,latitude from celllocation';)
do coordinate=$(echo $i | sed 's/|/,/g')



echo '<Placemark><name>'$coordinate'</name><Point><coordinates>'$coordinate',0</coordinates></Point></Placemark>'
done;

echo '</Document></kml>'

I added this to my lighttpd.conf and restarted it.

  ".kml"       =>      "application/vnd.google-earth.kml+xml",

Then it's just a matter of passing the kml file to google maps..

http://maps.google.com/maps?q=http://$yourserver/output.kml

I noticed a bunch of towers I never connected to  (far away places) so there are some problems with this.

Gnome-shell annoying bug.

Accidentally hitting the print screen button (which I do a lot because of this stupid keyboard) I get an annoying popup:

Text was empty (or contained only whitespace)

and in /.xsession-errors

Window manager warning: Error on command 33 "": Text was empty (or contained only whitespace)

Went to system settings - > keyboard -> shortcuts and disabled the printscreen shortcut for now.

Update: removing ~/.gconf and ~/.gnome* fixes this.

Convert mp3 to iphone ringtone.

Convert the mp3 too a wav first.

[youri@nemesis ringtone]$ mplayer -ao pcm Loudest_Ringtone.mp3 -ao pcm:file="ringtone.wav"

Then wav to m4r. M4r is the format iphone wants ringtones in.

[youri@nemesis ringtone]$ faac ringtone.wav -o loudest.m4r -w

Transfer file to iphone. I use sftp.

[youri@nemesis ringtone]$ sftp root@yphone:/Library/Ringtones

root@yphone's password:

Connected to yphone.

Changing to: /Library/Ringtones

sftp> put loudest.m4r

Uploading loudestm4r to /private/var/stash/Ringtones.wljzz0/loudest.m4r

loudest.ringtone.m4r                                                           100%  306KB 305.8KB/s   00:01   

sftp> exit

Avant-window-navigator system notification daemon applet crashed

GStreamer-CRITICAL **: gst_debug_add_log_function: assertion `func != NULL' failed
aborting...

Solution: re-install avant-window-navigator-bzr & awn-extras-applets-bzr

configure: error: The xdg python module is required (pyxdg or python-xdg)
    Aborting...

Stupid python3!

Solution: sudo ln -s /usr/bin/python2 /usr/bin/python

Joining many AVI files together & changing framerate

convert into one file:

for i in $(ls); do cat $i >> bigavi.avi; done

mencoder -forceidx -oac copy -ovc copy bigavi.avi -o FINAL.avi

framerate (25):

ffmpeg -i FINAL.avi -f yuv4mpegpipe - | yuvfps -s 25:1 -r 25:1 | ffmpeg -f yuv4mpegpipe -i  - -b 1000k  faster.avi

Remove dead repo (installed by package) from cydia via ssh

Failed to fetch http://ispaziorepository.com/./Packagez.gz HTTP/1.1 404 Not found.

Can't remove the repo through cydia, it was installed by JB tool.


 [youri@nemesis ~]$ ssh root@192.168.1.6 
root@192.168.1.6's password:

yPhone:~ root# rm /etc/apt/sources.list.d/ispazio.net.list


Fixed.

Upgrading ubuntu 10.10 to natty narwhal

youri@zexlette:~$ sudo do-release-upgrade -d

This hangs at "Calculating the changes"

youri@zexlette:~$ sudo aptitude update

youri@zexlette:~$ sudo aptitude full-upgrade

1164 packages upgraded, 135 newly installed, 78 to remove and 0 not upgraded.
Need to get 623MB of archives. After unpacking 3,940kB will be freed.

E: Couldn't configure pre-depend x11-common for x11-utils, probably a dependency cycle.

youri@zexlette:~$ sudo dpkg --force-depends --remove x11-xkb-utils
[source]

youri@zexlette:~$ sudo aptitude full-upgrade

mjpg-streamer on arch with uvc webcam

[youri@nemesis ~]$ pak -S mjpg-streamer-uvc

[youri@nemesis ~]$ mjpg_streamer
MJPG Streamer Version.: 2.0
 i: Using V4L2 device.: /dev/video0
 i: Desired Resolution: 640 x 480
 i: Frames Per Second.: 5
 i: Format............: MJPEG
Unable to set format: Invalid argument
 Init v4L2 failed !! exit fatal
 i: init_VideoIn failed

[youri@nemesis ~]$ mjpg_streamer -i "input_uvc.so -d /dev/video -y" -o "output_http.so"
MJPG Streamer Version.: 2.0
 i: Using V4L2 device.: /dev/video
 i: Desired Resolution: 640 x 480
 i: Frames Per Second.: 5
 i: Format............: YUV
 i: JPEG Quality......: 80
 o: www-folder-path...: disabled
 o: HTTP TCP port.....: 8080
 o: username:password.: disabled
 o: commands..........: enabled

501: Not Implemented!
no www-folder configured

http://localhost:8080/?action=stream works

Cydia: Parsing dependency pre-depends

Cydia shows error: parsing dependency pre-depends

SSH'ing and doing apt-get update shows this:

Reading package lists... Error!
E: Problem parsing dependency Pre-Depends
E: Error occurred while processing com.sinfuliphone.adblocker (NewVersion1)
E: Problem with MergeList /var/lib/apt/lists/www.sinfuliphonerepo.com_._Packages
E: The package lists or status file could not be parsed or opened.

Problem is that Pre-Depends: is empty for some packages.

 Solution until sinful fixes things: 

rm /var/lib/apt/lists/www.sinfuliphonerepo.com_._Packages 

or remove pre-depends from adblocker and tlert in sinfulliphonerepo

Cydia 'unable to parse package file'

Cydia error:

Unable to parse package file /var/lib/apt/lists/cydia.xsellize.com_. _Pacakges.IndexDiff (1)

SSHing into phone and deleting the file fixes it.

Amarok PHP and mYSQL

 <?php  
 //charset=utf-8 makes it so unicode output doesn't get gobbled up by browser  
 header("Content-type: text/html; charset=utf-8");  
 echo '<p>Youri\'s id3v2 script</p>';  
   
   
 //connect to mysql and select amarokdb  
 $link=mysql_connect("localhost", "username", "password") or die(mysql_error());  
 echo "Connected to MySQL<br />";  
 mysql_select_db("amarokdb") or die(mysql_error());  
   
 echo "Connected to Database<br />";  
   
 //this makes the mysql db play well with utf8  
 mysql_set_charset('utf8',$link);  
   
   
 //globally retrieve all variables in the url string  
 $variable = $_GET['what'];  
 $bitratevariable = $_GET['bitrate'];  
 $coversaction = $_GET['coversaction'];  
 $idofartist= $_GET['idofartist'];  
 $artistName= $_GET['artistName'];  
   
   
 //navigation  
 echo "<a href=?what=bg1cd>Look for albums that have a CD num set</a> <br />";  
 echo "<a href=?what=blt128>Look for tracks with bitrate lower than 128kbps</a> <br />";  
 echo "<a href=?what=covers&coversaction=lookup>Look up covers</a> <br />";  
 echo "<a href=?what=nulltracknum>Look for tracks with no tracknumber set</a>";  
 echo '<br/><br/>';  
 echo "Look up bitrates<br />";  
   
 echo "[<a href=?what=bitrate&bitrate=128>128</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=160>160</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=192>192</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=256>256</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=320>320</a>] ";  
 echo '<br/><br/>';  
   
   
   
 //return the artist's name when an artist iD is passed  
 function getArtist($artistnum)  
 {  
      $artist = mysql_query("SELECT * FROM `artists` where `id` = $artistnum");  
      while ($row = mysql_fetch_array($artist))   
      {  
           return $row{'name'};  
      }  
 }  
   
 //returns the album's name when an album id is passed  
 function getAlbum($albumnum)  
 {  
      $album = mysql_query("SELECT * FROM `albums` where `id` = $albumnum");  
      while ($row = mysql_fetch_array($album))   
      {  
           return $row{'name'};  
      }  
        
   
 }  
   
 //this lists all the artists in the database except for various artists  
 function listArtists()  
      {  
   
 //select UNIQUE artist ID's from a join table of artists and album (join by referencing artists id column with albums artist column  
 /*  
 artists      albums      
 ID NAME     NAME      ARTIST  
 88 ARTIST     ALBUM     88  
 */  
   
        $result = mysql_query("select distinct artist from artists join albums on albums.artist=artists.id ORDER BY `artists`.`name`");  
   
   
 //walk through the result and pull artist id and artistname  
      while ($row = mysql_fetch_array($result))   
      {  
 //urlencode for spaces in artists and utf8 artists  
           $artistID = $row{'artist'};  
           $artistNameSQL=getArtist($artistID);  
           echo "<a href=?what=covers&coversaction=getArtistAlbums&idofartist=$artistID&artistName=",  
           urlencode($artistNameSQL),  
           ">$artistNameSQL</a><br />";       
              
   
      }  
      }  
        
        
   
   
 //listallalbums belonging to artist ID when given an artist ID       
 //artistname is passed only for html output  
 function listAlbumsById($idofartist,$artistName)  
      {  
        
        
      $albums = mysql_query("SELECT * FROM `albums` where `artist` = $idofartist" );  
        
           echo "<strong>$artistName</strong><br />";  
           while ($row = mysql_fetch_array($albums))   
           {  
           $album = $row{'name'};  
        
 //amarok stores album covers by getting and md5sum hash of lowercased artist and album  
 //mb_strtolower works on unicode white strtolower doesn't  
           echo "<div style=\"display: inline-block\">";  
           echo "$album<br />";  
           echo "/home/youri/.kde4/share/apps/amarok/albumcovers/large/",md5(mb_strtolower("$artistName$album",'UTF-8')),"<br/>";  
           echo "<img width=500px src=./albumcovers/",md5(mb_strtolower("$artistName$album",'UTF-8')),"><br/>";  
           echo "</div>";  
           }  
        
      }  
   
   
 if ($variable=="bg1cd")  
 {  
      $result = mysql_query("SELECT * FROM `tracks` WHERE `discnumber` IS NOT NULL");  
      while ($row = mysql_fetch_array($result))   
      {  
           $artist = getArtist($row{'artist'});  
           $album = getAlbum($row{'album'});  
           echo "$artist - $album <br />";  
      }  
   
 }  
   
 elseif ($variable=="blt128")  
 {  
        
      $result = mysql_query("SELECT * FROM `tracks` WHERE `bitrate` < 128 ORDER BY `tracks`.`artist` ASC");  
      $num_rows = mysql_num_rows($result);  
   
      echo "$num_rows Tracks<br /><br />";   
        
           while ($row = mysql_fetch_array($result))   
      {  
           $artist = getArtist($row{'artist'});  
           $album = getAlbum($row{'album'});  
           $tracknumber = $row{'tracknumber'};  
           $title = $row{'title'};  
           $bitrate = $row{'bitrate'};  
           echo "$artist - $album - $tracknumber - $title [$bitrate]<br />";  
      }  
 }  
   
 elseif ($variable=="bitrate")  
 {  
   
      $result = mysql_query("SELECT * FROM `tracks` WHERE `bitrate` = $bitratevariable");  
      $num_rows = mysql_num_rows($result);  
        
      $totaltrax = mysql_query("SELECT * FROM `tracks`");  
      $num_rows_total = mysql_num_rows($totaltrax);  
        
      echo "$num_rows Tracks are $bitratevariable kbps ";   
      echo "out of a $num_rows_total total tracks<br />";  
        
      $percentage=($num_rows/$num_rows_total *100);  
        
      echo "Which equals: ";  
      echo number_format($percentage, 1)."%<br/>";  
   
   
 }  
   
 //if covers is called with lookup, list artists  
 //if covers is called with get artistalbums, then get artist's albums  
 elseif ($variable=="covers")  
 {  
   
   
      if ($coversaction == "lookup" )  
      {  
           listArtists();  
      }  
        
      elseif ($coversaction == "getArtistAlbums" )  
       {  
         
        
       listAlbumsById($idofartist,$artistName);  
         
       }  
   
 }  
   
   
   
 elseif ($variable=="nulltracknum")  
 {  
      $result = mysql_query("SELECT * FROM `tracks` where `tracknumber` is null");  
      while ($row = mysql_fetch_array($result))   
      {  
      $artist = getArtist($row{'artist'});  
      $album = getAlbum($row{'album'});  
      $title = $row{'title'};  
      }  
   
 }  
 ?>  

iPhone 3GS log.

Jailbreak:

3GS 16GB jailbroken with spirit.

Spirit2pwn (old bootroom) -> sn0wbreeze -> 4.1

(Change hosts file/must have shsh for 4.1 saved)


Unlock:

Cydia -> Search -> ultrasn0w -> install


Installous:

Cydia -> Manage -> Edit -> Add -> cydia.hackulo.us
Cydia -> Search -> Installous -> Install


SSH

Change default passwords:

ssh mobile@192.168.1.6 (default passwd: alpine)

passwd

su root

passwd

TomTom

Mount iPhone under gnome, copy and paste tomtom 1.6 ipa onto filesystem.

ssh to phone as root

mv /var/mobile/Media/tomtom1.6.ipa /var/mobile/Documents/Installous/Downloads/

Go to installous and downloads and install ipa.

Favorites/settings restore:

iPhone:/private/var/mobile/Applications/D59505E5-17DF-4B2D-AD2A-73729133B4FC/Documents/USA, Canada, & Mexico mobile$ mv /User/Media/mapsettings.cfg ./


Apps: 

• Camera Plus Pro
• Skype
• Google Voice
• Calling Card
• TomTom
• iWebcamera
• OPlayer
• Ustream Broadcaster
• iSSH
• iFile
• Atomic Web

Tweaks:

• Winterboard
• Silent Camera Theme
• Glasklart Classic 4.0
• SBSettings
• SBSettings Glasklart theme
• Glasklart Battery theme 
• User Wallpaper
• User Lock Wallpaper
• Five Icon Dock
• Volume Boost
• Make it Mine
• ISHShit 
• Typophone 4
• Metadata removr

Change Calling Card Icon:

Find /var/stash/Themes.ZAZeaY/Glasklart%20Icons.theme/Bundles/com.apple.mobilephone/icon.png

Copy it to /var/stash/Themes.ZAZeaY/Youri's Icons/Icons/Calling Card.png

Settings->Winterboard-> Summer Board mode [ON] and enable "Youri's Icons" theme.

Respring.


Rename Applications

Add cydia source http://cydia.myrepospace.com/Tw1zTiD-Chris2
Install rename II
Respring


LockInfo

Add cydia repo http://www.sinfuliphonerepo.com
Lockinfo

HTC plugin

iAdKiller

Add cydia repo http://cydia.xsellize.com/
Install iAdKiller


Screenshot

phpMyAdmin collated db in utf8_bin shows hex data instead of UTF8 text

Expanding options and setting 'show binary contents' then pressing 'Go' fixes it.

and $cfg['DisplayBinaryAsHex'] = false;

 in /usr/share/webapps/phpMyAdmin/config.inc.php

CLRF characters in my PKGBUILD!

makepkg
==> ERROR: PKGBUILD contains CRLF characters and cannot be sourced.

Solution:

sed -i 's/^M//' PKGBUILD

[ctrl+v][ctrl+m] for the ^M symbol.

Control amarok through dbus with SSH.

 The session needs to know $DBUS_SESSION_BUS_ADDRESS, so get that first and then run qdbus.

export DBUS_SESSION_BUS_ADDRESS=`cat /proc/$(pidof kded4)/environ | tr '\0' '\n' | grep DBUS | cut -d '=' -f2-` ; qdbus org.kde.amarok /Player org.freedesktop.MediaPlayer.PlayPause

Xorg wouldn't start with latest updates.

One of these in my Xorg.0.log after upgrading to latest mesa ati-dri and libgl

[    27.289] 0: /usr/bin/X (xorg_backtrace+0x28) [0x49f1a8]
[    27.289] 1: /usr/bin/X (0x400000+0x60239) [0x460239]
[    27.289] 2: /lib/libpthread.so.0 (0x7f42d79da000+0xf1c0) [0x7f42d79e91c0]
[    27.289] Segmentation fault at address (nil)


Removing 'nomodeset' from /boot/grub/menu.lst fixes it.

updating phpbb from 3.0.7-pl1 to 3.0.8

navigate to forum dir
#wget http://www.phpbb.com/files/release/phpBB-3.0.7-PL1_to_3.0.8.tar.bz2

#bunzip2  phpBB-3.0.7-PL1_to_3.0.8.tar.bz2

#tar xvf phpBB-3.0.7-PL1_to_3.0.8.tar

go to forum/install & click update tab

'proceed to next step' -> 'update database' -> 'update my database now' -> 'continue the update process now'

'download modified archive'

tar xvf update_3.0.7-PL1_to_3.0.8.tar

rm -r install/

All files are up to date with the latest phpBB version. You should now login to your board and check if everything is working fine. Do not forget to delete, rename or move your install directory! Please send us updated information about your server and board configurations from the Send statistics module in your ACP.

phpmyadmin with arch + lighttpd

install phpmyadmin

#yaourt -S phpmyadmin php-mcrypt

edit lighttpd.conf

add alias.url = ( "/phpmyadmin/" => "/usr/share/webapps/phpMyAdmin/") to  /etc/lighttpd/lighttpd.conf

edit .htaccess

#deny from all to /etc/webapps/phpmyadmin/.htaccess

edit php.ini
open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/:/usr/share/webapps/:/etc/webapps
in
/etc/php/php.ini

extension=mcrypt.so
extension=mysql.so

works.

mp3 backup script with rsync

#!/bin/sh


dir="/media/mp3"
ext="mp3"
backupdir="/media/6e6fad14-604b-499f-ac0f-6667aadb478f/MP3S"




find $dir -type f | grep -v \.$ext\$


if [ $? -eq 0 ]
then
echo
echo "Not continuing with backup"
echo "Found non mp3 files"
else


echo "Continuing with backup"
rsync -avur "$dir/" "$backupdir/"
echo "Backup complete"
fi

Kernel patch that does wonders bash.

Here is how I am doing my bash script.
 (As explained here: www.webupd8.org/2010/11/alternative-to-200-lines-kernel-patch.html)


in ~/.bashrc


if [ "$PS1" ] ; then                                                                                                                               
    mkdir -m 0700 /cgroup/$$
    echo $$ > /cgroup/$$/tasks
    echo 1 > /cgroup/$$/notify_on_release
fi


in /etc/rc.local

mount -t cgroup cgroup /cgroup -o cpu
chmod 0777 /cgroup
echo "/sbin/rm_cgroup" > /cgroup/release_agent

in /sbin/rm_cgroup

#!/bin/sh
rmdir /cgroup/$1

then chmod +x /sbin/rm_cgroup and sudo mkdir /cgroup

Source.