Attend XDA's Second Annual Developer Conference, XDA:DevCon 2014!
5,741,979 Members 45,558 Now Online
XDA Developers Android and Mobile Development Forum

Google Android and Linux for KAISER!!

Tip us?
 
enatefox
Old
#7461  
enatefox's Avatar
Senior Member
Thanks Meter 3
Posts: 1,846
Join Date: Jul 2008
Anybody know how to set up system-wide SOCKS5 proxy support? I got ConnectBot and can get connected to my server at home and want all DNS and regular traffic tunnelled through. I think Opera mini for Android is probably the worst browser next to the built-in one so I can't imagine it supports it. I'd like every widget, etc. through the tunnel. Any ideas? I've seen how to tether to a computer and give the computer a proxy through the phone modem but that's not the same.
 
ibanezbass
Old
#7462  
ibanezbass's Avatar
Senior Member
Thanks Meter 67
Posts: 264
Join Date: Jan 2009
Location: Oklahoma City
Alright, now is there anything u need from me to address the sms issue and isnt there a terminal command to funnel the wifi into a proxy?
Phone: LG G2; 32G
Tablet: Samsung Galaxy Tab Pro 8.4;
Dell Venue 8 Pro 32G; iPad 2 16G
Retired:
Flip Phones->iPhone->AT&T Tilt (WM6/6.5/Android 1.5/1.6)->
iPhone 3GS->iPhone 4->HTC Inspire 4G->iPhone 4S->
Samsung Galaxy S III->HTC One
 
natalic
Old
#7463  
Senior Member
Thanks Meter 30
Posts: 240
Join Date: Aug 2008

 
DONATE TO ME
http://scarlet-arrow.com/builds/Hero...09_DMAWIFI.rar

This is a Hero build with all the correct settings. Works out of the box, simply copy to your SD card.

Has Compcache and DMA wifi!
 
enatefox
Old
#7464  
enatefox's Avatar
Senior Member
Thanks Meter 3
Posts: 1,846
Join Date: Jul 2008
I would assume that the SSH implementation would be the same but not sure. I guess there's really one way to find out.

I would need a data.img that has texts saved and preferably one with a send error. This isn't exactly rocket science though. How good are you at SQL? I posted this but didn't hear back. At any rate, you just need to map the features needed (are they sending but saying failed? anything else?) and where they are handled by HTC's app. I can't get specific when a dump of the tables shows nothing to look at.
 
ibanezbass
Old
#7465  
ibanezbass's Avatar
Senior Member
Thanks Meter 67
Posts: 264
Join Date: Jan 2009
Location: Oklahoma City
alright i'll take a look. give me a few to load up linux.
Phone: LG G2; 32G
Tablet: Samsung Galaxy Tab Pro 8.4;
Dell Venue 8 Pro 32G; iPad 2 16G
Retired:
Flip Phones->iPhone->AT&T Tilt (WM6/6.5/Android 1.5/1.6)->
iPhone 3GS->iPhone 4->HTC Inspire 4G->iPhone 4S->
Samsung Galaxy S III->HTC One
 
roadhead
Old
#7466  
Member
Thanks Meter 3
Posts: 86
Join Date: Dec 2008
Wifi Works! I was even able to leave my office, have the 3g kick on by itself, and then revert back to Wifi when I was in range.

This is as good as my wife's G1 in that regard (better actually, as she goes from Wifi to EDGE)

Build is very fast moving about, never have to wait for Clock, Calender, Weather widgets to reload on the home screen

All in all I must say this project has come a long way from the first time I tried to use it, and found that I couldn't have working data AND a screen that flipped the correct way

Thanks a ton to all the developers who have worked so hard on this.

Cheers!
Galaxy Nexus - CM 10.1 M2
Nexus7 - Stock
Nexus10 - Stock, Rooted
Nexus4 - Stock (Wife's)
 
ibanezbass
Old
(Last edited by ibanezbass; 18th August 2009 at 09:12 PM.)
#7467  
ibanezbass's Avatar
Senior Member
Thanks Meter 67
Posts: 264
Join Date: Jan 2009
Location: Oklahoma City
enatefox, i'm having a major brainfart lol how do u mount the data.img

scratch that i got it..

now what command do i need to run in sqlite3? if i type in .database i can see one called main

nevermind got it dumped. is that what u need? i'll pm it to u if it is.
Phone: LG G2; 32G
Tablet: Samsung Galaxy Tab Pro 8.4;
Dell Venue 8 Pro 32G; iPad 2 16G
Retired:
Flip Phones->iPhone->AT&T Tilt (WM6/6.5/Android 1.5/1.6)->
iPhone 3GS->iPhone 4->HTC Inspire 4G->iPhone 4S->
Samsung Galaxy S III->HTC One
 
enatefox
Old
#7468  
enatefox's Avatar
Senior Member
Thanks Meter 3
Posts: 1,846
Join Date: Jul 2008
You got anything good? ".tables" will show the tables, then you can "select * from <table_name>;" until you see stuff. Look for something related to error or fail. I'm used to MS SQL and MySQL but I'm sure I can translate some stored procedures I have that let me do full text searches and the like. You can send me the db files if you want so I can look for what to look for but unless you're randomizing the data, I'll have your personal info on it.
 
ibanezbass
Old
(Last edited by ibanezbass; 18th August 2009 at 09:49 PM.)
#7469  
ibanezbass's Avatar
Senior Member
Thanks Meter 67
Posts: 264
Join Date: Jan 2009
Location: Oklahoma City
Quote:
1|1|0|4xxxxxxxx0||xxxxxxxxxxxxxx||1|-1|2|||Hey|0||
2|1|129|1xxxxxxxxx0||xxxxxxxxxxxx|0|0|-1|1|0||Hey|145||+xxxxxxxxxx
3|1|129|1xxxxxxxxx0||xxxxxxxxxxxx|0|0|-1|1|0||Hey|145||+xxxxxxxxxx
first is sent, second are recieved. i sent the first then hit edit and sent it again but thats what it looks like on my phone.

also theres
Code:
Select Code
... WHERE thread_id = new.thread_id        AND (m_type=132 OR m_type=130 OR m_type=128)        AND msg_box != 3         AND pdu.m_id is NULL) +      (SELECT COUNT(DISTINCT pdu.m_id) FROM pdu LEFT JOIN threads       ON threads._id = thread_id      WHERE thread_id = new.thread_id        AND (m_type=132 OR m_type=130 OR m_type=128)        AND msg_box != 3        AND pdu.m_id is not NULL)   WHERE threads._id = new.thread_id;   UPDATE threads SET read =     CASE (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = threads._id)      WHEN 0 THEN 1      ELSE 0    END  WHERE threads._id = new.thread_id;   UPDATE threads SET unread_count =     (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = threads._id) +     (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND thread_id = threads._id)  WHERE threads._id = new.thread_id; END;
CREATE TRIGGER pdu_update_thread_read_on_update AFTER  UPDATE OF read  ON pdu   WHEN new.m_type=132    OR new.m_type=130    OR new.m_type=128 BEGIN   UPDATE threads SET read =     CASE (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND (m_type=132              OR m_type=130)            AND thread_id = threads._id)      WHEN 0 THEN 1      ELSE 0    END  WHERE threads._id = new.thread_id;   UPDATE threads SET unread_count =     (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = threads._id) +     (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND thread_id = threads._id)  WHERE threads._id = new.thread_id; END;
CREATE TRIGGER sms_update_thread_read_on_update AFTER  UPDATE OF read  ON sms BEGIN   UPDATE threads SET read =     CASE (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = threads._id)      WHEN 0 THEN 1      ELSE 0    END  WHERE threads._id = new.thread_id;   UPDATE threads SET unread_count =     (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = threads._id) +     (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND thread_id = threads._id)  WHERE threads._id = new.thread_id; END;
CREATE TRIGGER sms_update_thread_on_delete AFTER DELETE ON sms BEGIN   UPDATE threads SET      date = (strftime('%s','now') * 1000)   WHERE threads._id = old.thread_id;   UPDATE threads SET message_count =      (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads       ON threads._id = thread_id      WHERE thread_id = old.thread_id        AND sms.type != 3) +      (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads       ON threads._id = thread_id      WHERE thread_id = old.thread_id        AND (m_type=132 OR m_type=130 OR m_type=128)        AND msg_box != 3)   WHERE threads._id = old.thread_id;   UPDATE threads SET unread_count =     (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = old.thread_id) +     (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND thread_id = old.thread_id)  WHERE threads._id = old.thread_id;   UPDATE threads SET snippet =    (SELECT snippet FROM     (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, body AS snippet, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id;   UPDATE threads SET snippet_cs =    (SELECT snippet_cs FROM     (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id;   UPDATE threads SET priority =    (SELECT priority FROM     (SELECT date * 1000 AS date, pri AS priority, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, 0 AS priority, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id; END;
CREATE TRIGGER pdu_update_thread_on_delete AFTER DELETE ON pdu BEGIN   UPDATE threads SET      date = (strftime('%s','now') * 1000)  WHERE threads._id = old.thread_id;   UPDATE threads SET message_count =      (SELECT COUNT(sms._id) FROM sms LEFT JOIN threads       ON threads._id = thread_id      WHERE thread_id = old.thread_id        AND sms.type != 3) +      (SELECT COUNT(pdu._id) FROM pdu LEFT JOIN threads       ON threads._id = thread_id      WHERE thread_id = old.thread_id        AND (m_type=132 OR m_type=130 OR m_type=128)        AND msg_box != 3)   WHERE threads._id = old.thread_id;   UPDATE threads SET unread_count =     (SELECT COUNT(*)          FROM sms          WHERE read = 0            AND thread_id = old.thread_id) +     (SELECT COUNT(*)          FROM pdu          WHERE read = 0            AND thread_id = old.thread_id)  WHERE threads._id = old.thread_id;   UPDATE threads SET snippet =    (SELECT snippet FROM     (SELECT date * 1000 AS date, sub AS snippet, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, body AS snippet, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id;   UPDATE threads SET snippet_cs =    (SELECT snippet_cs FROM     (SELECT date * 1000 AS date, sub_cs AS snippet_cs, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, 0 AS snippet_cs, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id;   UPDATE threads SET priority =    (SELECT priority FROM     (SELECT date * 1000 AS date, pri AS priority, thread_id FROM pdu        WHERE m_type=132 OR m_type=130 OR m_type=128      UNION SELECT date, 0 AS priority, thread_id FROM sms)    WHERE thread_id = OLD.thread_id ORDER BY date DESC LIMIT 1)   WHERE threads._id = OLD.thread_id; END;
CREATE TRIGGER delete_obsolete_threads_pdu AFTER DELETE ON pdu BEGIN   DELETE FROM threads   WHERE     _id = old.thread_id     AND _id NOT IN     (SELECT thread_id FROM sms      UNION SELECT thread_id from pdu); END;
CREATE TRIGGER delete_obsolete_threads_when_update_pdu AFTER UPDATE OF thread_id ON pdu WHEN old.thread_id != new.thread_id BEGIN   DELETE FROM threads   WHERE     _id = old.thread_id     AND _id NOT IN     (SELECT thread_id FROM sms      UNION SELECT thread_id from pdu); END;
CREATE TRIGGER delete_obsolete_threads_sms AFTER DELETE ON sms BEGIN   DELETE FROM threads   WHERE     _id = old.thread_id     AND _id NOT IN     (SELECT thread_id FROM sms      UNION SELECT thread_id from pdu); END;
CREATE TRIGGER insert_mms_pending_on_insert AFTER INSERT ON pdu WHEN new.m_type=130  OR new.m_type=135 BEGIN   INSERT INTO pending_msgs    (proto_type,     msg_id,     msg_type,     err_type,     err_code,     retry_index,     due_time)   VALUES     (1,      new._id,      new.m_type,0,0,0,0);END;
CREATE TRIGGER insert_mms_pending_on_update AFTER UPDATE ON pdu WHEN new.m_type=128  AND new.msg_box=4  AND old.msg_box!=4 BEGIN   INSERT INTO pending_msgs    (proto_type,     msg_id,     msg_type,     err_type,     err_code,     retry_index,     due_time)   VALUES     (1,      new._id,      new.m_type,0,0,0,0);END;
CREATE TRIGGER delete_mms_pending_on_update AFTER UPDATE ON pdu WHEN old.msg_box=4  AND new.msg_box!=4 BEGIN   DELETE FROM pending_msgs  WHERE msg_id=new._id; END;
CREATE TRIGGER delete_mms_pending_on_delete AFTER DELETE ON pdu BEGIN   DELETE FROM pending_msgs  WHERE msg_id=old._id; END;
CREATE TRIGGER update_threads_error_on_update_mms   AFTER UPDATE OF err_type ON pending_msgs   WHEN (OLD.err_type < 10 AND NEW.err_type >= 10)    OR (OLD.err_type >= 10 AND NEW.err_type < 10) BEGIN  UPDATE threads SET error =     CASE      WHEN NEW.err_type >= 10 THEN error + 1      ELSE error - 1    END   WHERE _id =   (SELECT DISTINCT thread_id    FROM pdu    WHERE _id = NEW.msg_id); END;
CREATE TRIGGER update_threads_error_on_delete_mms   BEFORE DELETE ON pdu  WHEN OLD._id IN (SELECT DISTINCT msg_id                   FROM pending_msgs                   WHERE err_type >= 10) BEGIN   UPDATE threads SET error = error - 1  WHERE _id = OLD.thread_id; END;
CREATE TRIGGER update_threads_error_on_move_mms   BEFORE UPDATE OF msg_box ON pdu   WHEN (OLD.msg_box = 4 AND NEW.msg_box != 4)   AND (OLD._id IN (SELECT DISTINCT msg_id                   FROM pending_msgs                   WHERE err_type >= 10)) BEGIN   UPDATE threads SET error = error - 1  WHERE _id = OLD.thread_id; END;
CREATE TRIGGER update_threads_error_on_update_sms   AFTER UPDATE OF type ON sms  WHEN (OLD.type != 5 AND NEW.type = 5)    OR (OLD.type = 5 AND NEW.type != 5) BEGIN   UPDATE threads SET error =     CASE      WHEN NEW.type = 5 THEN error + 1      ELSE error - 1    END   WHERE _id = NEW.thread_id; END;
CREATE TRIGGER update_threads_error_on_delete_sms   AFTER DELETE ON sms  WHEN (OLD.type = 5) BEGIN   UPDATE threads SET error = error - 1  WHERE _id = OLD.thread_id; END;
CREATE TRIGGER part_cleanup DELETE ON pdu BEGIN   DELETE FROM part  WHERE mid=old._id;END;
CREATE TRIGGER addr_cleanup DELETE ON pdu BEGIN   DELETE FROM addr  WHERE msg_id=old._id;END;
CREATE TRIGGER cleanup_delivery_and_read_report AFTER DELETE ON pdu WHEN old.m_type=128 BEGIN   DELETE FROM pdu  WHERE (m_type=134    OR m_type=136)    AND m_id=old.m_id; END;
Phone: LG G2; 32G
Tablet: Samsung Galaxy Tab Pro 8.4;
Dell Venue 8 Pro 32G; iPad 2 16G
Retired:
Flip Phones->iPhone->AT&T Tilt (WM6/6.5/Android 1.5/1.6)->
iPhone 3GS->iPhone 4->HTC Inspire 4G->iPhone 4S->
Samsung Galaxy S III->HTC One
 
enatefox
Old
(Last edited by enatefox; 18th August 2009 at 09:56 PM.)
#7470  
enatefox's Avatar
Senior Member
Thanks Meter 3
Posts: 1,846
Join Date: Jul 2008
pending_msgs has this schema:
Code:
Select Code
err_type INTEGER,err_code INTEGER,retry_index INTEGER NOT NULL DEFAULT 0,due_time INTEGER,last_try INTEGER

CREATE TRIGGER update_threads_error_on_update_mms   AFTER UPDATE OF err_type ON pending_msgs   WHEN (OLD.err_type < 10 AND NEW.err_type >= 10)    OR (OLD.err_type >= 10 AND NEW.err_type < 10) BEGIN  UPDATE threads SET error =     CASE      WHEN NEW.err_type >= 10 THEN error + 1      ELSE error - 1    END   WHERE _id =   (SELECT DISTINCT thread_id    FROM pdu    WHERE _id = NEW.msg_id); END;
pdu holds the thread ID to reference the error and updates the threads table with an error ID. And so it continues as databases go.

You can send me the info, but I'll have private texts so you may want to go through for names and numbers. This is where I would start though. There should exist entries in threads where error is not null and <> 0 for example.

*EDIT, you pretty much should have it in your post above me now. Should find a better way to go over this. Can you create a new data.img, just text a couple of times to yourself or whatever and then after anonymizing it, send it my way? These are separate file-based db's but maybe we can profile it as it is sending via ADB.

Tags
android, htc, kaiser, linux, porting
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes