beeseven
Aug 24 2006, 06:17 PM
| | I like to experiment with a lot of things and I was thinking of making a sort of instant messenger in Python, but I want to let people have actual accounts so I need to be able to access the mySQL remotely. If that's not possible, are we allowed to run Python scripts on the server? |
Comment/Reply (w/o sign-up)
BuffaloHELP
Aug 24 2006, 08:03 PM
Yes you can access SQL remotely but this is not recommended. When you code please check and double check so that it does not abuse SQL connection tries. Otherwise it will crash or shut down SQL server. As far as Python script goes, OpaQue has not said no to that. However the first sign of abuse or unstable the server admin will disallow your further usage and perhaps lead to account termination. So please make sure that you are not leaving any open "holes." Thank you.
Comment/Reply (w/o sign-up)
Lyon2
Aug 25 2006, 12:36 AM
BuffaloHELP, tell me something please, can i use the following program to remotly connect to my trap17 free hosting mysql server? MySQL-Front
Comment/Reply (w/o sign-up)
beeseven
Aug 26 2006, 06:08 PM
The mysql, I'm assuming is at mysql.trap17.com? And how would I run the script?
Comment/Reply (w/o sign-up)
michaelper22
Aug 27 2006, 03:16 AM
QUOTE(beeseven @ Aug 26 2006, 02:08 PM) 
The mysql, I'm assuming is at mysql.trap17.com? And how would I run the script?
The MySQL server can be accessed from your site's address. Example: My domain is nyceducated.info, so the server address I would use to access it would be nyceducated.info. Alternatively, you could use gamma.xisto.com. either way, remember to allow remote access to the MySQL server from your IP address in cPanel: Log in to cPanel, go to the MySQL Databases page, and scroll all the way down to the bottom, where you see the Access Hosts section. Type in either your IP address (if it's static; which I bet it isn't), or just '%', which acts as a wildcard. (See the attachment below for reference.) But as BuffaloHELP mentioned above, it is perfered that you only access MySQL locally, for performance and security purposes.
Comment/Reply (w/o sign-up)
beeseven
Sep 6 2006, 12:19 AM
Thanks, that was really helpful. I'd still like to know how to run a script, though. Edit: It doesn't seem to want to let me in. I'm trying to connect in Python using this: CODE conn = _mysql.connection(host='beeseven.trap17.com', user='beeseven', passwd='********', db='beeseven_forumz') But I'm getting this error: QUOTE Traceback (most recent call last): File "<pyshell#8>", line 1, in -toplevel- conn = _mysql.connection(host='beeseven.trap17.com', user='beeseven', passwd='*******', db='beeseven_forumz') OperationalError: (1045, "Access denied for user: 'beeseven@ip68-100-***-***.dc.dc.cox.net' (Using password: YES)") Comment/Reply (w/o sign-up)
beeseven
Sep 20 2006, 10:35 PM
I'm all about sharing solutions to problems, so I'll say that I figured out you can run a script using PHP's "system" command like so: CODE <?php
system("test.py");
?> and that will also print out all the output of the script.
Comment/Reply (w/o sign-up)
OpaQue
Feb 19 2007, 02:44 AM
QUOTE(Lyon2 @ Aug 25 2006, 06:06 AM) BuffaloHELP, tell me something please, can i use the following program to remotly connect to my trap17 free hosting mysql server?
MySQL-Front Yes, Configure your IP address in MYSQL section in CPanel.
Comment/Reply (w/o sign-up)
farsiscript
Feb 22 2007, 09:51 PM
Dear beeseven its not secure connect to one open mysql for share your database you must ping your script ip for example ( new hosting or script hosting ) and take an ip address then go to cpanel / mysql part and at bottom of page you can find one text "localhost" submit your ip address in textboxbottom of "localhost" text thanks
Comment/Reply (w/o sign-up)
cw123
Jun 18 2008, 01:11 AM
ok! I read this thread a few times and tried to use the mysql remotely. I set the ip of the other server who wants to use the mysql in Cpanel, I also change db host in script to my domain. but what I got is still negative. it says "Error establishing a database connection " . can anyone help me to address that? I just want some sites share the same database. my site is a personal blog site. so I think it's secure enough not to abuse the trap 17 sever. if it's not appropriate to do that! then just forget about it. thanks
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : access, mysql, remotely
- I Can't Access My Site
(7)
Mccodes With Mysql! [resolved]
I need help with this topic (6) Hey all, I was trying to install my McCodes game I bought recently, but every time I try to install
it, I get this error: QUOTE Write Config... Config written. Attempting DB connection
Warning : require(class/class_db_mysql.php) : failed to open stream: No such file or directory in
/home/lwadmin/public_html/installer.php on line 457 Warning :
require(class/class_db_mysql.php) : failed to open stream: No such file or directory in
/home/lwadmin/public_html/installer.php on line 457 Fatal error : require() : Failed
opening required 'class....
Mysql Server Down
(10) mysql (5.0.51a-community) failed What is happening? And btw, sometimes I get a message: could not
connect with mysql server. I use joomla 1.5 . but now, the server is down as shown on Server
status... please help....
I Can't Seem To Access My Site.
(8) I try to go to my hosted site http://saitunes.trap17.com and it just thinks, then it says the
operation timed out. Can anyone else access my site?....
My Site Is Crippled.
I can't access anything (10) Hey guys please help. I haven't been able to access my cPanel for a long time now. I think the
problem started when most members had those password problems. I think that's when I made too
many unsuccessful login attempts. Now I can't access my cPanel and any site hosted here. Someone
told me my IP is blocked but I don't know who to tell to have the problem resolved.
BuffaloHelp(sorry if it wasn't u Buff) stated in one post that he could reset password if nayone
would write a post with the line "Please reset my password". I did that but still there is....
Mysql Database Not Working
(3) well i'm getting an error message(a databass connection warning) for all of the parts of my site
that connects to a mysql database i check my database users pertmissions and i try to do the repair
database thing and it's still not woeking. am i the only person having this or is it an overall
trap17 issue and how do i fix it.....
It Went Well For A While
MySQL problem back in all its glory. (5) Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
effect. File(include/errors.xml) is not within the allowed path(s):
(/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
fopen(include/errors.xml) : failed to open stream: Operation not permitted in
/home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
incl....
Hosting Problem [resolved]
403 Forbidden Error occurs whenever I try to access my site (22) First off, let me say that I have spent considerable effort and time going through the forums
seeking solutions for this problem. I have even gone as far as to seek help from the Xisto Live
support team (they suggested I wait 2 hours and then get back to them. Well I did that, and there
has been no change, and live support is now down). I've also tried changing permissions on both
files and folders via Cpanel, but to no avail. I still end up with the same error: QUOTE
Forbidden You don't have permission to access /index.php on this server. Additionally, a 4....
No Site Access
(4) It was working the day before yesterday and then it started giving me error messages about not being
able to access the site. I can't access cpanel either. Neither page ever loads. I don't
have this problem with any other internet pages, just my site stuff on Trap17. My site's at
www.jzambrano.trap17.com btw. This is one of the few times I'll need it up for sure so I'd
appreciate if the issue can get fixed in the near future. ....
Can't Access My Site An Cpanel
already did some sugested things (6) I still can't get to my website and cpanel, Tings I did: requested xisto to unblock my ip
cleaned my cache/cookies Did this with both IE and FF When I am @ my dads house he can acces my
website. So I guess it is still an ip problem. I did read some posts but couldn't find a
solution. Thx in advance,....
Can't Access My Site....weird Issue
(5) Okay, so last night everything worked fine. I loaded up cpanel, fixed issues with the site after the
database move, etc. Today I'm unable to load up the site. It just keeps giving me ping
timeouts. With what I'm being told by others it is only me having this issue with my site, and
yet there have been 0 changes to my pc between it working and not. I have tried multiple times
during the day with no luck. Along with this, if I load my website using a proxy service then I do
not have any issues. The only time it will not allow me to access it is if I am "using" my....
Almost There, However.... [resolved]
Cannot access webmail yet. (7) After all the troubles over the past week, I have everything set up, my access to MySQL databases
restored, however, I cannot access my webmail yet. I log in on the screen before you get the choice
which webmail to use (Squirrel, Horde or Roundcube), and when clicking on Horde I get "Login failed
because your username or password are incorrect", with Squirrel mail i get; "ERROR: Connection
dropped by IMAP server." and Roundcube (probably as the name implies) keeps going round in circles.
According to the opening screen of cpanel, I have 3 email accounts (as it should be)....
How Do I Find My Mysql Password? [resolved]
Cannot access my MySQL (5) After all the recent problems, my account has been restored. I have setup my parked domain agin, and
that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
that's all). I had to create a new user for my databases, and created the user with exactly the
same username and password I had before, but some of my web pages do not let me access the pages I
have associated with my databases. Where could i find out what my DB password is? (Although I am as
good as sure I am using the right one). I have tried my old password, the new c....
Official: Can't Access My Cpanel - Supports From Admins
(71) Scroll down to Post #8 for Admin Support Ok I've read stuff here and there in the support
forum and shoutbox about the recent trap17 server problem. I'm extremely confused. Some people
say that their websites are working fine. Some people are experiencing different issues from mine,
had their website reset or something. I can access my website on the gamma server, so I assume that
if I unpark and park my domain again, I can get it to work like the last time. I accessed my cpanel
at bishoujo.trap17.com/cpanel because the 'Access CPanel' link on the fo....
I Cant Access The Server!
(1) i can not establish a connection AT ALL!! my ftp program (Core FTP LE) cannot connect, neither can
my online ftp..... also, i cannot log in to my cpanel!! in short, i cant do ANYTHING!!! can
anyone help me?? better question, is the server down? and im not aware of it? /mad.gif"
style="vertical-align:middle" emoid=":angry:" border="0" alt="mad.gif" />....
Remote Access Mysql
(8) Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies.....
Anonymous Ftp Access?
(2) Hi, my subdomain here is tf2maps.trap17.com, and I was wondering, how do you enable anonymous ftp
access for the public_ftp folder? I cant seem to find the option in Cpanel. And every time I try to
access http://tf2maps.trap17.com/public_ftp/tf/ it gives me a 404 error? Is there any way of
seeing my folders in the browser? Thank you! /biggrin.gif" style="vertical-align:middle" emoid=":D"
border="0" alt="biggrin.gif" />....
Server Issues? Web Site Down? Cpanel Access?
Server Migration issues to report. (48) I tried downloading my email from website this morning and Thunderbird said it couldn't access
it the server. Then I tried loading my website - to no avail. Does anyone have any idea what's
going on? Is anyone else experiencing this? Seems like this is the second time this spring this has
happened. Is an upgrade going on, or something? Thanks in advance for your help! ....
Sub Domain Problem : Urgent
Cannot access my sub domains (10) Hi, I am having some serious problems with my sub domains. I registered a site with trap17 named
http://zoebelkin.co.cc . Then I made 2 sub domains for the site. One is for the forums section
and the other is for the gallery section. 1> forums.zoebelkin.co.cc 2> gallery.zoebelkin.co.cc
Whenever I type these in the browser adress bar the browser gives an output that it cannot find the
web sites. But they are complete and should show something. Also using www. in front of the sub
domains didn't help. Is www. needed in front of the sub domains. Could you just....
Cannot Access Cpanel...
(3) hey guys, its starting to irritate me how my computer is somewhat dumb...I don't know if its
something I did or what, but maybe somebody can help. I go to my cpanel, from any link I try it says
internet explorer cannot find page or whatever the heck it says...but wait....i go to my
laptop...and what happens? perfect, however i hate my laptop to death cuz it does not have nearly
anything and im not supposed to use it for anything but work, and its connection SUCKS...so ya, does
anybody think they know how to fix it? im trying to download firefox and or opera right no....
Unable To Access Cpanel
(7) I'm not able to access the cPanel for my hosting account, I get the following error, CODE
The connection has timed out The server is taking too long to respond. I tried accessing the
cPanel from http://gamma.xisto.com/cpanel ....
Problems With Ftp Access
(1) Well topic title says its all I have problem with ftp access to my account here on trap17 so if
anyone has experienced similar issues lately. The problem is when I try to log on it disconnects me
from the server. I am using filezilla however I have tried to access trough file manager and it
works fine though it is not the same protocol. I must admit I have deleted some folders recently
however I am quite certain that it is all connected to the joomla installation and not some system
files but if there is some specified folder for ftp could you plese write down so I cou....
I Cannot Access My Site. [resolved]
Am I blocked by Firewall? (13) Hi, is there a server problem? All of a sudden I cannot get through to
http://www.vlaanderen-flanders.org.uk anymore, nor can I FTP. Could someone check this out,
please?....
Can't Access My Email Account [resolved]
(4) I couldn't access my email account for 3 days ago .. I use the Horde .. the problem is when I
click on Login the page loads itself and don't change!!!!.......
Installing Apache, Mysql, Phpmyadmin Locally
Solving the "php_mbstring.dll missing" (5) Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwizs, ....
Help Moving Mysql Files To A New Host
IPB files (2) Well, my partners on my forum has decided to move our site to a newer host. A paid one to be exact.
And we did that already. Now all we need to do is move our forum over to the new host. We want to
do this without losing all of our posts and other data. I know it has something to do with the MySQL
files but I don't really understand it. Some help would be appreciated. We are running Invision
Power Board 1.3.1 final Also, we're thinking about upgrading our board to a newer version of
IPB because we heard that its better in more ways than one. But then again, it....
Setting Up A Remote Mysql Connection
Need help! (3) Okay... I'm hosted here on Trap17. I would like to connect to a remote MySQL database located on
another server... can someone walk me through what I need to do to set this up, or if it can even be
done? Thank you in advance!....
Mysql Database Setup : Setting Up Mysql Database
Guide to use MySQL database in your site (7) A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
server. You can access it using the link in Cpanel. Cpanel can be accessed by
"www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
: IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
MYSQL Settings
(5) I am going to edit my mysql settings. Before i had freesql.org but that's slow. So now i
created one here. What is the host? What must i put in the server.....
Problems with PHPBB & my Access to files :S
(4) Ok another problem i'm having.. prolly my fault but ok.. i go to uploud my avatar on my forums
and it says this after i click submit Warning: copy(./images/avatars/486273215410e356f445f1.jpg):
failed to open stream: Permission denied in /home/zipmc/public_html/Forum/includes/usercp_avatar.php
on line 227 Warning: Cannot modify header information - headers already sent by (output started at
/home/zipmc/public_html/Forum/includes/usercp_avatar.php:227) in
/home/zipmc/public_html/Forum/includes/page_header.php on line 474 Warning: Cannot modify header
information - h....
Looking for access, mysql, remotely
|
Searching Video's for access, mysql, remotely
See Also,
|
advertisement
|
|
