Related
I get my 02 Mini S Variant Wizard next week, one thing I'm hoping do do is to log on to our Unix servers via Telnet over Wireless Lan. From a PC I use "PuTTY" which can cope with the specific screen emulations we use. Is there a suitable Telnet client for the Wizard?
Many thanks,
Mark.
putty is available for Pocket PC and seems to work ok..do a google for it.
lyallb said:
putty is available for Pocket PC and seems to work ok..do a google for it.
Click to expand...
Click to collapse
Thanks for that! So does this mean that software listed as for the "Pocket PC" will typically work on a Wizard?
Mark.
I've heard good thing about pockeTTY. It does telnet/ssh. This was the winner in pocketpcmag's comparison. Going to give it a try later on.
Mark Falsebeard said:
one thing I'm hoping do do is to log on to our Unix servers via Telnet over Wireless Lan
Click to expand...
Click to collapse
Are you really (still) using Telnet? I would change that to SSH as soon as you can! Telnet is not save at all.
By the way.... http://www.pocketputty.net/
Are you really (still) using Telnet? I would change that to SSH as soon as you can! Telnet is not save at all.
Click to expand...
Click to collapse
I'm aware that Telnet isn't very secure, however I don't have any say in the connection method. Our firewalls are currently MacAddress specific and Fixed IP Address specific so I'm pretty confident that the server is secure.
I'm intending to connect via WEP encrypted wireless LAN (rather than via the internet) whilst at home and/or at work.
Another solution could be to connect via Terminal Services to the Windows SBS Server and use the PuTTY that's already on my account on there.
For the moment I haven't a clue what would be possible or the best way to procede as I've not got the phone yet. My enquiries are related to working out what it will be possible for me to do and what software would be needed to do it.
The XDA was ordered today, along with a 2gb MiniSD Card and I'm really looking forward to getting it.
Mark.
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
I know this is a strange request, but I've needed this feature more than once.
I have been using WaveSecure for a while and it is fantastic, and has located my phone more than once (did I leave my phone at work or is it out in the car???) as well as retreiving SMSes when needed if I didnt have the phone, but the features are pretty much limited to that.
However, would it be possible to have remote desktop capabilities on the phone itself? Having the phone as the server and the desktop as the viewing client?
I understand the challenges, especially considering the fact that the IP addresses are dynamic. However that shouldnt be a problem.
I know leaving the server open all the time listening could cause a battery drain issue so sending a simple SMS command to open the program and begin listening as well as reply or e-mail the current IP address would fix this problem. In my experience the phone will keep the same IP address for a good few minutes so if a SMS command could wake up the data connection, and then somehow reply with the phone's current IP address that would be fantastic. If not would it be possible to port a dynamic DNS type of application to run on the phone similar to what you'd run on a PC if you have a dynamic IP address.
Traffic also shouldn't be a problem as my 3G connection on my phone uploads faster than my road runner turbo! I can regularly upload at 600-700kbps compared to my road runner's 512kbps. Plus you're only having to transmit 320x480 pixels at say 256 colors.
I know there were programs like this for win mo but how hard would it be for android?
This is also what I'm looking for. Screencast is cool, but I would love some remote android goodness. Kinda like Mymobiler and SOTI Pocket Controller.
superstudinor said:
This is also what I'm looking for. Screencast is cool, but I would love some remote android goodness. Kinda like Mymobiler and SOTI Pocket Controller.
Click to expand...
Click to collapse
Yeah, I used MyMobiler on my touch pro but that was only via USB (atleast at the time I used it)
BTT....
10char
anyone????
http://www.toremote.com/ i think you might want to look at this maybe its what your looking for. good luck
H4k3r4r34l said:
http://www.toremote.com/ i think you might want to look at this maybe its what your looking for. good luck
Click to expand...
Click to collapse
He's looking for it the other way around, at least if I am reading it correctly.
While I don't know of any pre-existing solutions, I can envision exiting tools that would collectively allow you to do what you want, there would just need to be some sort of wrapper / script that could pull it all together from different tools.
For example, PicMe, the utility used typically for screen shots, has a 'live' option to view/control your phone from your computer's web browser, and you connect to it over WiFi and/or the Mobile Network.
So, if there was a way to send a command to your phone to email you its current Sprint IP address, then automatically fire up PicMe (which can be hidden), you could then access the phone on the PicMe port (8082), to view the screen, see what is going on, or control the phone, etc.
What I don't know, and I haven't looked, is if there is any sort of scripting engine / macro tools that could allow you to utilize the existing tools to automate the various tasks. Would be cool though.
Wow, PicMe is awesome!!! However I can't figure out how to control it. I goto the live view and it does nothing.
Hmm, never mind. Re-booted and it worked fine! THAT'S FREAKING AWESOME!!!
Now, the only thing I'd really need is to write a simple application that will intercept a SMS (similiar to mobile defense or wave secure) that will e-mail as well as reply via SMS my current IP address, then launch the picme application. I say e-mail because if you don't have access to -a- phone, you can SMS via sprint.com and then check e-mail for the ip address.
THIS IS FANTASTIC!!!
Thank you sooo much!
poor_red_neck said:
Hmm, never mind. Re-booted and it worked fine! THAT'S FREAKING AWESOME!!!
Now, the only thing I'd really need is to write a simple application that will intercept a SMS (similiar to mobile defense or wave secure) that will e-mail as well as reply via SMS my current IP address, then launch the picme application. I say e-mail because if you don't have access to -a- phone, you can SMS via sprint.com and then check e-mail for the ip address.
THIS IS FANTASTIC!!!
Thank you sooo much!
Click to expand...
Click to collapse
Keep us updated please. Would love to have this figured out
let me know when you figure something out
If you haven't already finished the SMS intercept idea, I think the best way would be to incorporate it as some type of "firewall"... like those apps in the market. Just put some extremely obscure message into the SMS, something like "adsf;lkasdf jaeo8taupwetap0", and have the program only filter that. Just make sure the message is obscure, you don't want anyone's SMS turning it on/off!
Well, this may take some time.
I haven't studied the SDK for android yet, and its been a while since I've fiddled with java... soooo.... I dunno if this is even in my scope.
Just thought of a new question. I use excel a ton and frequently need to go to my bosses office to ask questions about certain things. If I were logged onto the companies wifi, would I be able to optain access to the shared drives my NT account (assuming somehow I login from my Xoom) to manually bring the document to my boss, and have the work be easily done in one place???
The quickest way might be to install one of the remote desktop clients out there. Even on the 4.3’’ screen of the Evo, it can be a real pain to use, but I suspect a MUCH more pleasant experience on this.
By tomorrow afternoon, it is my intent to have my xoom talking to a dedicated Win7 vm that lives on one of my servers. Hopefully, I’ll be able to get to a point where creds are saved and I end up with a 1-click process to access the enterprise. Im REALLY banking on the idea that rdp will be usable on this larger screen.
I know that’s not exactly what you were looking for, but I’d be willing to bet that somebody is / has worked on a file browser that will see network shares and store credentials. I will certainly look around.
AndyMan386 said:
Just thought of a new question. I use excel a ton and frequently need to go to my bosses office to ask questions about certain things. If I were logged onto the companies wifi, would I be able to optain access to the shared drives my NT account (assuming somehow I login from my Xoom) to manually bring the document to my boss, and have the work be easily done in one place???
Click to expand...
Click to collapse
I can do this at home now with my Android phone using AndroXplorer on wifi. Just need to create a shortcut to a share on my PC using UNC path. Not sure if your company will have any restrictions on WiFi or not and also not sure if that app will work on Honeycomb. But it is definitely possible.
Hey guys, I'm looking for an SSH client (remote ssh client?) for my Xoom. I'm a server admin, and I need access to my servers via SSH when I'm away from my desktop. I've found a few apps, but they all appear to be local (that is, they're designed to give terminal access to the xoom, not remote terminal access).
I don't mind paying for a good app, so has anyone found a good honeycomb SSH app yet?
I've had luck with ConnectBot.
It supports key auth and is free.
Sent from my Thunderbolt
intangibleDroid said:
I've had luck with ConnectBot.
It supports key auth and is free.
Sent from my Thunderbolt
Click to expand...
Click to collapse
If anyone was wondering how to get it into landscape mode you go to Settings->Rotation Mode make sure its set to "Automatic".
I will second the endorsement for connectbot. It works quite well on the xoom. Connectbot has been my go to program for SSH since the g1.
It does not have any functionality specific to tablets but it works quite well.
Awesome! Thanks, guys!