[MOD] Zipalign And SQLite3 Binaries

Status
Not open for further replies.
Search This thread
By:
Advanced…
Q

qubbus

Senior Member
Dec 24, 2012
623
228
Last edited:
Danster840

Danster840

Senior Member
Feb 14, 2011
230
105
South Florida
hiyachi-32 said:
thanks.
I isntaled init d from playstore.
now can I flas this binari ?
Click to expand...
Click to collapse
Yes if after you install the app, as well as busybox and after the app confirms you have init.d reboot 2 times and check /data/ for test.log.

The app should right a test.log if it's working correctly. You can flash the zip but I recommend you update your sqlite3 binary with the one linked earlier 3.8.8

I did something similar to the post directly above this one. I used a different sql script to this one, but I use this zipalign script
 
Last edited:
  • Like
Reactions: hiyachi-32 and qubbus
hiyachi-32

hiyachi-32

Senior Member
Nov 12, 2013
258
57
İZMİR
REINDEX=SUCCESS
Database /data/data/com.sec.android.mimage.photoretouching/databases/common_button_table.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/media/0/Android/data/pl.solidexplorer/index.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/media/0/baidu/tempdata/ls.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/validity/template.db: VACUUM=SUCCESS REINDEX=SUCCESS
SQLite database VACUUM and REINDEX finished at 01-09-2015 00:04:47

Here is my part of log
Is it ok know?


SMG900H
Android 5(root)
 
Q

qubbus

Senior Member
Dec 24, 2012
623
228
hiyachi-32 said:
REINDEX=SUCCESS
Database /data/data/com.sec.android.mimage.photoretouching/databases/common_button_table.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/media/0/Android/data/pl.solidexplorer/index.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/media/0/baidu/tempdata/ls.db: VACUUM=SUCCESS REINDEX=SUCCESS
Database /data/validity/template.db: VACUUM=SUCCESS REINDEX=SUCCESS
SQLite database VACUUM and REINDEX finished at 01-09-2015 00:04:47

Here is my part of log
Is it ok know?


SMG900H
Android 5(root)
Click to expand...
Click to collapse

Is there anything to explain in word "SUCCESS"? :angel:

Sorry in init.d folder files MUST have permissions: - 0755 (rwx r-x r-x)
 
  • Like
Reactions: Danster840
hiyachi-32

hiyachi-32

Senior Member
Nov 12, 2013
258
57
İZMİR
qubbus said:
Is there anything to explain in word "SUCCESS"? :angel:

Sorry in init.d folder files MUST have permissions: - 0755 (rwx r-x r-x)
Click to expand...
Click to collapse
I guess its mean done :)

---------- Post added at 01:31 AM ---------- Previous post was at 01:19 AM ----------
Danster840 said:
Yes if after you install the app, as well as busybox and after the app confirms you have init.d reboot 2 times and check /data/ for test.log.

The app should right a test.log if it's working correctly. You can flash the zip but I recommend you update your sqlite3 binary with the one linked earlier 3.8.8

I did something similar to the post directly above this one. I used a different sql script to this one, but I use this zipalign script
Click to expand...
Click to collapse
OK what did step by step
1. Download squlit3 open zip copy file and move to system/etc/init.d folder
2. I open init.d and click squlite3 than pressed start button.
is it ok now? did I did this correctly ?
 
Danster840

Danster840

Senior Member
Feb 14, 2011
230
105
South Florida
I was originally speaking about installing init.d support, but as far as updating the sqlite binary, unpack the binary from the zip file and replace the sqlite binary in xbin with the 3.8.8 version in the zip. Only scripts go into init.d folder
 
  • Like
Reactions: hiyachi-32
I

intxeon

Senior Member
Aug 8, 2013
255
95
qubbus said:
Have you done everything as was said in this thread?
I and other users have this working. You had to do something wrong.
Click to expand...
Click to collapse

sqlite3 v3.8.8 in xbin and 91sqlite in init.d with right permissions for both folder.
I don't think I did something wrong because what I had to do was a simple copy&past in the right folders.
Anyway the sqlite script generates a log so it should works...
 
Q

qubbus

Senior Member
Dec 24, 2012
623
228
intxeon said:
sqlite3 v3.8.8 in xbin and 91sqlite in init.d with right permissions for both folder.
I don't think I did something wrong because what I had to do was a simple copy&past in the right folders.
Anyway the sqlite script generates a log so it should works...
Click to expand...
Click to collapse

busybox installed and init.d support from Gplay?
 
Q

qubbus

Senior Member
Dec 24, 2012
623
228
intxeon said:
Yes
Click to expand...
Click to collapse

Vaccum gives me the same errcode14 - seems to unable with access db...
working on it. But I used script from xstrestolite rom. Script from zip dont generate sqlite.log

Danster840 said:
Yes if after you install the app, as well as busybox and after the app confirms you have init.d reboot 2 times and check /data/ for test.log.

The app should right a test.log if it's working correctly. You can flash the zip but I recommend you update your sqlite3 binary with the one linked earlier 3.8.8

I did something similar to the post directly above this one. I used a different sql script to this one, but I use this zipalign script
Click to expand...
Click to collapse

what script did you used?
intxeon said:
sqlite3 v3.8.8 in xbin and 91sqlite in init.d with right permissions for both folder.
I don't think I did something wrong because what I had to do was a simple copy&past in the right folders.
Anyway the sqlite script generates a log so it should works...
Click to expand...
Click to collapse

what script sqlite are you using?
Script from this zip will not generate sqlite.log. How do yo know about errcode14?
 
Last edited:
  • Like
Reactions: intxeon
I

intxeon

Senior Member
Aug 8, 2013
255
95
qubbus said:
Vaccum gives me the same errcode14 - seems to unable with access db...
working on it. But I used script from xstrestolite rom. Script from zip dont generate sqlite.log



what script did you used?




what script sqlite are you using?
Script from this zip will not generate sqlite.log. How do yo know about errcode14?
Click to expand...
Click to collapse

Sqlite script

#!/system/bin/sh

LOG_FILE=/data/sqlite.log

#Interval between SQLite3 runs, in seconds, 604800=1 week
RUN_EVERY=86400

# Get the last modify date of the Log file, if the file does not exist, set value to 0
if [ -e $LOG_FILE ]; then
LASTRUN=`stat -t $LOG_FILE | awk '{print $14}'`
else
LASTRUN=0
fi;

# Get current date in epoch format
CURRDATE=`date +%s`

# Check the interval
INTERVAL=$(expr $CURRDATE - $LASTRUN)

# If interval is more than the set one, then run the main script
if [ $INTERVAL -gt $RUN_EVERY ];
then
if [ -e $LOG_FILE ]; then
rm $LOG_FILE;
fi;

echo "SQLite database VACUUM and REINDEX started at $( date +"%m-%d-%Y %H:%M:%S" )" | tee -a $LOG_FILE;

for i in `busybox find /d* -iname "*.db"`; do
/system/xbin/sqlite3 $i 'VACUUM;';
resVac=$?
if [ $resVac == 0 ]; then
resVac="SUCCESS";
else
resVac="ERRCODE-$resVac";
fi;

/system/xbin/sqlite3 $i 'REINDEX;';
resIndex=$?
if [ $resIndex == 0 ]; then
resIndex="SUCCESS";
else
resIndex="ERRCODE-$resIndex";
fi;
echo "Database $i: VACUUM=$resVac REINDEX=$resIndex" | tee -a $LOG_FILE;
done

echo "SQLite database VACUUM and REINDEX finished at $( date +"%m-%d-%Y %H:%M:%S" )" | tee -a $LOG_FILE;
fi;



It will give you VACUUM and REINDEX results
 
  • Like
Reactions: qubbus
Q

qubbus

Senior Member
Dec 24, 2012
623
228
intxeon said:
Sqlite script

#!/system/bin/sh

LOG_FILE=/data/sqlite.log

#Interval between SQLite3 runs, in seconds, 604800=1 week
RUN_EVERY=86400

# Get the last modify date of the Log file, if the file does not exist, set value to 0
if [ -e $LOG_FILE ]; then
LASTRUN=`stat -t $LOG_FILE | awk '{print $14}'`
else
LASTRUN=0
fi;

# Get current date in epoch format
CURRDATE=`date +%s`

# Check the interval
INTERVAL=$(expr $CURRDATE - $LASTRUN)

# If interval is more than the set one, then run the main script
if [ $INTERVAL -gt $RUN_EVERY ];
then
if [ -e $LOG_FILE ]; then
rm $LOG_FILE;
fi;

echo "SQLite database VACUUM and REINDEX started at $( date +"%m-%d-%Y %H:%M:%S" )" | tee -a $LOG_FILE;

for i in `busybox find /d* -iname "*.db"`; do
/system/xbin/sqlite3 $i 'VACUUM;';
resVac=$?
if [ $resVac == 0 ]; then
resVac="SUCCESS";
else
resVac="ERRCODE-$resVac";
fi;

/system/xbin/sqlite3 $i 'REINDEX;';
resIndex=$?
if [ $resIndex == 0 ]; then
resIndex="SUCCESS";
else
resIndex="ERRCODE-$resIndex";
fi;
echo "Database $i: VACUUM=$resVac REINDEX=$resIndex" | tee -a $LOG_FILE;
done

echo "SQLite database VACUUM and REINDEX finished at $( date +"%m-%d-%Y %H:%M:%S" )" | tee -a $LOG_FILE;
fi;



It will give you VACUUM and REINDEX results
Click to expand...
Click to collapse

THX, found another one.
Have no clue why this is not working well, errcode14 is reffered to no access to DB. When Vacuum command is started, there must me created templorary DB, it seems that there is no rights to do it.
 
  • Like
Reactions: Danster840
Danster840

Danster840

Senior Member
Feb 14, 2011
230
105
South Florida
qubbus said:
THX, found another one.
Have no clue why this is not working well, errcode14 is reffered to no access to DB. When Vacuum command is started, there must me created templorary DB, it seems that there is no rights to do it.
Click to expand...
Click to collapse
After double checking and trying two different scripts I get same, vacuum error only. I must of just noticed the success and not the errors. I'm thinking it could be lollipop doing it to me? Zip align script fails as well all together since I went to touch wiz lollipop. I confirmed that the binary at least for me isn't causing it. I get same error with the supplied binary. Could someone also confirm that binary version isn't causing this?
 
A

Atento

Senior Member
Jun 18, 2010
623
244
Curitiba
If I just replace SQLite 3.8.8 without this script, will it work? Is this script really necessary to make everything work?
 
  • Like
Reactions: qubbus
Status
Not open for further replies.

Similar threads

H
[MOD] HX-CAMERA-Mod_1.3_07/30_Video/Photo_Quality_and more
Replies
300
Views
194K
P
PanzerfaustH8
Wuby986
[MOD][GUIDE][HOWTO] * Enable Private Mode with custom rom*
Replies
332
Views
125K
S
Snwn
_alexndr
[MOD][SCRIPT][HOWTO] Enable Call Recording on any Samsung Galaxy S5 (stock ROM)
Replies
65
Views
101K
Hippie459MN
Hippie459MN
SkywalkerZ
  • Poll
[MOD]Smart Debloater[G900F][KK/LP/MM][v5][8/11/16][AROMA][Dev-Friendly]
Replies
240
Views
131K
C
C64Ever
Marcelo765
  • Locked
  • Poll
[ROM][TW][6.0.1] [NEMESIS REBORN] [V5.5] [N7/S8/S9] [07/10/18] by BAN (MAGNO)
Replies
2K
Views
525K
FSadino
FSadino

Top Liked Posts

24 Hours All time
  • There are no posts matching your filters.
  • 13
    la2o
    la2o
    WORKS ON ALL ANDROID DEVICES

    Be sure to have busybox and init.d support, thank you.

    Hello everyone. Today, I present my first mod for you guys XD

    This installs the zipalign and sqlite3 binaries, also puts scripts in the init.d folder.

    These will improve performance and smoothness of apps :)

    HOW TO INSTALL?

    1) Download the zip file

    2) Put it in your phone

    3) Boot into recovery and flash it :)

    HOW TO REMOVE?

    1) Download the removetweaks.zip

    2) Put it in your phone

    3) Boot into recovery and flash :)
    View
    2
    Danster840
    Danster840
    hiyachi-32 said:
    thanks.
    I isntaled init d from playstore.
    now can I flas this binari ?
    Click to expand...
    Click to collapse
    Yes if after you install the app, as well as busybox and after the app confirms you have init.d reboot 2 times and check /data/ for test.log.

    The app should right a test.log if it's working correctly. You can flash the zip but I recommend you update your sqlite3 binary with the one linked earlier 3.8.8

    I did something similar to the post directly above this one. I used a different sql script to this one, but I use this zipalign script
    View
    1
    ManDone.vRs
    ManDone.vRs
    Hello mate ! I will give a try ;) Thanks !
    View
    1
    la2o
    la2o
    aegeuss said:
    Buddy,

    Thanks for the effort but my device started to reset itself up after the boot process giving an error "Authorization failed." I could hardly delete the files in init.d folder and installed busybox again but it did not fix the problem. I still get the same error and resets. I am on Omega Rom v7 with ktoons kernel.

    Please attach here asap a resep .zip file so that users like me can go back when they face the same problem. I am waiting for it.

    Regards.
    Click to expand...
    Click to collapse

    Alright, sorry to hear that.
    I'll make another zip file ASAP
    View
    1
    davidwilson83
    davidwilson83
    Thread closed at OP's request
    View

New posts