Hi,
I'm new to this forum and the world of XDA's, I was given one for Christmas and now I am looking at developing software to extend it, after finding out that MSN Messenger does not work with Pay-As-You-Go on O2 (and other providers) because of the limitation of other ports, I've decided to build a proxy for messenger so that it can connect over the HTTP protocol.
I have a lot of previous experience with Messenger at the protocol level, I have developed many pieces of software which connect to the servers as normal clients would, most importantly I have a good understanding of how the Proxy system works.
I have not developed in many system-level languages before, however. I am mainly a PHP coder and am learning VB .NET at college, however I plan on doing this project in either VB .NET or C++.
What I require help with is how to actually pick-up/hijack the commands sent to the server, before they are sent to the server. Is there any way of doing this without MSN supporting a proxy, I've seen it done on many pieces of software, but does anyone here have the knowledge to help me do that? Once I have the messenger interface the Proxy system will be a breeze to complete.
Would anyone be able to help me out with the above, in terms of a section of code, or a suggestion for a website to look at?
Many Thanks
Andy
P.S. Sorry my explanation is a bit vague but that is the best way to explain it, I could draw a picture of what I mean if anyone requires
I believe what you are trying to do is of great importance for many users..
I can't help in the proraming field.. since my info in this field are really limited..
However.. I would sugget another soulotion ..
why don't try creating an application that works as socks server for the msn messenger...
there many similar programs for the PC.. like www.hopster.com
if you can port it into PPC platform, it will be awesome
Happy holidays :wink:
Haves
8125
Updated Rom that supports Push email
Exchange server with SP 2 installed.
Have Nots
Properly Configed server
Push email working
Anybody with experience want to help me out?
guess not... I wonder if I put a reward of helping me do this up. paypal?
A bit more exacly informations please! Is your server configured with a Certificate? (IIS changed to HTTPS only?)
And search the forum, here are already many threads about that.
lutzs said:
A bit more exacly informations please! Is your server configured with a Certificate? (IIS changed to HTTPS only?)
Click to expand...
Click to collapse
I got lost on the certification part... sorry. I had a good friend help me set t up.
You know, the search function of the forum is a powerfull tool.
If you used it, you'd figure out there are a lot of threads already about this.
Here's one for you to start with.
http://forum.xda-developers.com/viewtopic.php?t=41788&highlight=push+mail+doc
On page 2 there is a link to a site that contains a word document on howto set it up. Try that first.
I have it working but not 100%.
Im currently in the CNS (computer networking) field, and I do use my phone (Tilt) for a lot of things in my field. But the one thing I wish I had on my Tilt was a program that I can sniff out all the Ip's in my location. There be a lot of times where I just leave my laptop in my truck and when I'm trying to secure my network I like to use my ip sniffer to see if any ports are left open and if they are unsecured. It will be much easier if there was a program like that for my Tilt. If anyone can help me or at least point me into the right direction that would be wonderful. Thank every one for you furture help.
Please reply at:
http://forum.xda-developers.com/showthread.php?t=384442
PS
I tried handy sniffer "does not work for my tilt"
and I also tried "I think it was called airsniffer" something like that and again did not work for me
--------------------------------------------------------------------------
Attn: Admins I do have this in another post because I have a Tilt but, I also I wanted to put it in the Networking post. Please if you can have all reply's go to the Tilt section.
Hi All,
Does anyone know of a SQL client for Android? Just something for running basic queries when I need to check on a system and can't be arsed waiting for a computer to boot up. The databases I use are MS SQL Server.
I've searched about and can't find anything. I've also had a look at the dev docs for Android and it looks like it should be straight forward using the java.sql class but unfortunately Java isn't in my skill set at the moment and the day job & life in general doesn't leave me with much time to learn it.
If there isn't a program does anyone have any plans to write one ;-)
Cheers
Keith
Anyone ???
It'd be pretty darn insecure to open up your databases to use a remote client like that, why not just use something like phpmyadmin for it? It runs fine in the android browser and theres tons of alternatives that probably have iphone themes that would work great. Alternatively you could get debian set up and grab one of the hundreds of apps to do it in the repository
I need this as well. I'm constantly on SQL Enterprise Manager on my PC and when mobile, I have to teamviewer to my desktop and run queries there, which is such a torture.
I've bought RemoteDB, which I can't seem to get to work properly, I can't switch databases and the connection registry is very confusing.
Anybody?!
Also interested
I'm also interested in this topic.
As far as opening your db's up to the internet, that's a bogus argument. Anyone remotely managing enterprise databases will be using a vpn tunnel, and not the open web.
Having an Android app to connect to Microsoft SQL and Oracle would be extremely helpful. I've been trying to figure out how to mod Oracle's SQLDeveloper to do just that but without any success so far.
aSQL - Remote Control, new launch
Remote Control Client for Microsoft SQL Server 2005/2008/2008R2/2012.
aSQL - Remote Control Lite is a powerful Microsoft SQL Server client providing Access to your server in your Pocket. Access all of your databases, Jobs and Processes as well from your mobile device.Simple and Fast application providing advanced features.
aSQL - Remote Control Lite Provide features like:
- Providing connectivity to different servers on your Network.
- Ability to store Server Information for future use.
- Job START/STOP only a click away.
- Kill any running Processes From your mobile device.
- View Databases details - View File size.
Google Play Store link -
"market://details?id=com.sqlforce.aSQL"
SQL Client
Hi Guys
I looked for something like this for a while as well, and couldn't find anything that did what I wanted, so I made one myself
Key features I wanted are the following
Be able to connect directly to a db server. I used the jdts jdbc driver for Java to get this right
Be able to connect to any SQL Server db. I'll add support for Postgres and MySQL if this gains any popularity
List of all databases on the server (excluding system dbs) and allow you to quickly switch between them
List tables in the currently selected db, and generate Select statements for them
List stored procedures in the currently selected db, and pull the code for them so you can change it
Use a tabbed interface for the different sql queries, to allow you to run many queries at once
This is all done and works really well. Large queries take longer to run than they would on a pc, but they run nonetheless.
Let me know what you think, and feel free to suggest features. If enough people like it and use it, I'll bite the bullet and buy the developer so I can publish it on the Play store
I hope you enjoy it
ps. The installer is signed with the standard testing key, so you will need to go into your settings and allow applications from unknown sources
pps. I ask for internet access to get access to the network sockets, but dont actually connect to the internet.
danegoodwin -
I've downloaded it and played with it a bit - looks good. One feature I'd suggest off the top is storing the connection info. It's a pain having to enter the server address and username each time.
If you are still looking for a SQL client I had written one as well.
It should cover most of the popular databases and works well with tablets and phones.
SQLTool Pro
https://play.google.com/store/apps/details?id=com.nraboy.sqltool
I'm also open to suggestions and questions if anyone decides to give it a try.
nraboy said:
If you are still looking for a SQL client I had written one as well.
It should cover most of the popular databases and works well with tablets and phones.
SQLTool Pro
https://play.google.com/store/apps/details?id=com.nraboy.sqltool
I'm also open to suggestions and questions if anyone decides to give it a try.
Click to expand...
Click to collapse
so, this one does BOTH MySQL and MS SQL, and, your other one *just* MySQL ?
thanks, anyone
abbots said:
so, this one does BOTH MySQL and MS SQL, and, your other one *just* MySQL ?
thanks, anyone
Click to expand...
Click to collapse
Correct. The pro version will handle MySQL, MS SQL, PostgreSQL, Sybase, and Oracle up to version 10.1.
The MySQL version is strictly MySQL.
nraboy said:
Correct. The pro version will handle MySQL, MS SQL, PostgreSQL, Sybase, and Oracle up to version 10.1.
The MySQL version is strictly MySQL.
Click to expand...
Click to collapse
thanks for reply (and for nice app!)
nice, looks good... even better, seems to work well....connected to remote MySQL OK
suggestion: please auto-suggest correct ports for relevant SQLs
so, editing can only be done via queries ? (time to learn SQL syntax..?)
next, I'll try connecting to MS SQL, whilst I know a tiny bit about MySQL, I know nothing about MS, might be asking for help...
Nic,
need some help, if you can:
having issues with MS SQL, MS SQL is on a cloud server, for all I know, port could be blocked..
I've setup definition with port 1433, get 'failed to connect'
how to t/s outside of the app ?
should "telnet host 1433 " work ?
I'm getting
# telnet mssql2008.xx.yy 1433
Trying 202.111.22.33...
telnet: connect to address 202.111.22.33: Connection timed out
what else can I try ?
thanks for any pointers!
abbots said:
thanks for reply (and for nice app!)
nice, looks good... even better, seems to work well....connected to remote MySQL OK
suggestion: please auto-suggest correct ports for relevant SQLs
so, editing can only be done via queries ? (time to learn SQL syntax..?)
next, I'll try connecting to MS SQL, whilst I know a tiny bit about MySQL, I know nothing about MS, might be asking for help...
Nic,
need some help, if you can:
having issues with MS SQL, MS SQL is on a cloud server, for all I know, port could be blocked..
I've setup definition with port 1433, get 'failed to connect'
how to t/s outside of the app ?
should "telnet host 1433 " work ?
I'm getting
# telnet mssql2008.xx.yy 1433
Trying 202.111.22.33...
telnet: connect to address 202.111.22.33: Connection timed out
what else can I try ?
thanks for any pointers!
Click to expand...
Click to collapse
Hinting a default port is a good idea. I will see about adding in an upcoming release.
Yes right now anything beyond a simple select or delete must be done with a custom query. My goal is to make it more like the desktop editors, but since I am the only developer it might take a while. But I am not saying it won't happen.
If telnet is failing to connect then there is a firewall rule blocking your IP. Three things could fix this.
1. Add your IP to the database allow list (talk to the DBA)
2. If you can connect to the network the DB is on via VPN then you should. The db might be restricted to local IP
3. Use the SSH features of SQLTool to connect to a server on the databases allow list
You were smart to try the telnet. I would have done the same thing.
Feel free to contact me here or through the tools site. I'm happy to help
nraboy said:
You were smart to try the telnet. I would have done the same thing.
Click to expand...
Click to collapse
ahem, not that smart.....
forgot to specify sql type...... ooops
suggestion: don't allow save unless all req. stuff filled in...
OK, I seem to be in.
can I dump/backup with this app ?
thanks.
decent app, well done, wish you success in further development, if I can help in any way, happy to try
now I need to figure out how to dump this MS SQL into my Linux machine
abbots said:
ahem, not that smart.....
forgot to specify sql type...... ooops
suggestion: don't allow save unless all req. stuff filled in...
OK, I seem to be in.
can I dump/backup with this app ?
thanks.
decent app, well done, wish you success in further development, if I can help in any way, happy to try
Click to expand...
Click to collapse
Nice catch on the SQL Type. I will work to correct that.
For dump / backup are you referring to data or structure or both? Right now I have exporting DDL on my things to do list, but if you're referring to something else I'd like to hear it.
Thanks for the compliments on my app. I definitely want to hear more suggestions if you have them. Also please don't forget to rate well when you get a chance
Hi!
I was reading a post from microgeek about getting together on 'kik' to talk about G3 or android in general. I decided to take it further. Here you can share your imo , kik, watsapp or any other IM IDs. That way, If you find anything, new like any app, game, trick hack, we can immediately share. Also if people face any problems, doubts, questions, we can discuss it easily. Just a suggestion.
If this thread is useful, we'll keep it, or else we can delete it. :silly:
[Joining IRC as explained by pixdev]
IRC app
https://play.google.com/store/apps/...result#?t=W251bGwsMSwxLDEsIm5ldC5hbmRjaGF0Il0.
Everyone add me on kik. My ID is : Geekabyte.
Good idea, but i think an irc channel would be better.
TearsDontFalls said:
Good idea, but i think an irc channel would be better.
Click to expand...
Click to collapse
I have never used irc. is it good, does it have andriod app? I just searched mirc, its a paid service..why? whats so special about it?
Shree_Jamdar said:
I have never used irc. is it good, does it have andriod app? I just searched mirc, its a paid service..why? whats so special about it?
Click to expand...
Click to collapse
There are free options like AndChat and AndroIRC.
Wikipedia said:
Internet Relay Chat (IRC) is a protocol for real-time Internet text messaging (chat) or synchronous conferencing. It is mainly designed for group communication in discussion forums, called channels, but also allows one-to-one communication via private message as well as chat and data transfer, including file sharing.
Click to expand...
Click to collapse
I've just registered the channel '#g3' on freenode.net. A quick way to get started is to go to http://webchat.freenode.net, enter your XDA username as the nickname (so we can identify you), enter 'g3' in the channel and then (after doing the capcha) press connect. It's similar on AndChat and AndroIRC, although you have to choose your server (the server is irc.freenode.net or freenode.net depending on your client).
I would recommend registering your nick (to avoid impersonation by other members), go here for more details.
pixdev said:
There are free options like AndChat and AndroIRC.
I've just registered the channel '#g3' on freenode.net. A quick way to get started is to go to http://webchat.freenode.net, enter your XDA username as the nickname (so we can identify you), enter 'g3' in the channel and then (after doing the capcha) press connect. It's similar on AndChat and AndroIRC, although you have to choose your server (the server is irc.freenode.net or freenode.net depending on your client).
I would recommend registering your nick (to avoid impersonation by other members), go here for more details.
Click to expand...
Click to collapse
I am just learning IRC commands, I have changed the title of the thread too!