-
Posts
24,171 -
Joined
-
Last visited
-
Days Won
851
Everything posted by Krydos
-
6721869 rajesha1_food localhost:46542 rajesha1_onlinebooks Sleep 2765 NULL 6721870 rajesha1_food localhost:46544 rajesha1_onlinebooks Sleep 2765 NULL 6721884 rajesha1_food localhost:46666 rajesha1_onlinebooks Sleep 2759 NULL 6721885 rajesha1_food localhost:46668 rajesha1_onlinebooks Sleep 2759 NULL 2765 is the number of seconds since the last data was transferred so about 46 minutes.
-
The error is most commonly caused by people not closing their mysql connections after the query has completely. I've noticed this is especially bad in java. Keep in mind java was never really designed or intended to run in a multiuser environment, so unless you tell your code explicitly to close the connections java is going to assume it has the whole server to itself. You had a whopping 12 mysqlconnections just sleeping open. Most of which hadn't sent a single byte of data in HOURS. I've closed them all for you. Perhaps this will help https://stackoverflow.com/questions/2225221/closing-database-connections-in-java
-
That's a security error. Read this https://stackoverflow.com/questions/10752055/cross-origin-requests-are-only-supported-for-http-error-when-loading-a-local Basically, if the file is hosted via https/http/etc you can assume the owner of the file understands that it's being shared. If it's a path like file://c:/ that means it could be ANYTHING on your harddrive, which you don't necessarily want someone on the internet being able to access.
-
[Solved] Requesting Postgresql Db Access From Pgadmin 4 & From Any Ip
Krydos replied to oswako's topic in Escalated Requests
Johnny is running PostgreSQL v8.4.20 which PgAdmin4 does not support. PgAdmin3 should work with Johnny if you want to use an older version. Ricky and Tommy are both running PostgrSQL v9.2.18 which will work with PgAdmin4. So your options are to downgrade PgAdmin, or switch servers. -
There you go http://changemyhud.tk/
-
There are two main differences between Johnny and Tommy. Johnny is our unstable experimental server which means it's really easy to get an account as signups are available all day. This also means that Johnny has frequent high load spikes, less uptime, and just generally more bugs. Tommy is stable, and part of the way we keep him stable is by limiting the number of new accounts that can be created each day. Free signups start at midnight UTC and generally fill within an hour or two. If you're in a hurry and want to skip the line for Tommy I recommend taking a look at https://www.heliohost.org/tommy/Johnny is our only server plan that offers Ruby on Rails. If you need to use RoR Johnny is currently your only option.If you need to have your project functional by August 6th you might be able to get access on Johnny, but it's kind of random how often new java slots open up. Personally I would switch to Tommy. Your choice though. Let us know if you have any other questions. Oh, I also wanted to mention that if you do go ahead with https://www.heliohost.org/tommy/ I can use some new scripts that we're beta testing that should have your account moved for you, and java would be active and ready to go all within a few hours.
-
War files cannot be deployed until java is enabled on your account. To request java access please go to https://johnny.heliohost.org:2083/frontend/paper_lantern/java/index.live.php and click the "Request Java" button. Keep in mind that since you picked the Johnny server the wait to receive Java on your account is considerable. We recommend choosing Tommy as the queue to receive Java is only a few hours.
-
Deployed. http://xitix.heliohost.org/xitix_blog/
-
[Solved] Requesting Postgresql Db Access From Pgadmin 4 & From Any Ip
Krydos replied to oswako's topic in Escalated Requests
The postgresql user oswako_postgres should now be able to remotely connect to the postgresql database oswako_ioteche from any IP. -
[Solved] Ssl Error: Sec_Error_Revoked_Certificate
Krydos replied to maicol07's topic in Escalated Requests
According to https://www.sslshopper.com/ssl-checker.html#hostname=maicol07.tk that ssl certificate should be good, but when I open the page in Chrome it says it doesn't trust it. Did you pay for that certificate?- 12 replies
-
Deployed. http://rajesha1.heliohost.org/FINTECH-PROJECTS/
-
Well, since I already deleted the block I don't know when for sure it happened. If you get blocked again let us know, and make sure you say in your post not to delete the block before Krydos has a chance to look at the logs. Any admin can remove the block for you, but figuring out why you're being blocked is going to take some log reading. I looked through the logs a bit and I found a couple messages from facebook and twitter to you, but no failed logins. If I knew the time that you were blocked I could try to figure out why.
-
Out of curiousity I looked up the exact time that your account was suspended and compared it to the server monitor for Johnny. Even without the black line marking when your account was suspended you can see the difference.
-
Deployed. http://rajesha1.heliohost.org/FINTECH-PROJECTS/
-
Do you know if you got blocked while your account was inactive or before or after?
-
/home/mediaku/public_html/video-download/getvideo.php Why not download your videos directly to your computer instead of getting suspended over and over?
-
Tommy blocked you for too many failed IMAP logins. Make sure you have the right password saved in any mail clients you may be using. I removed the block for you. Can you connect now?
-
I'm Getting An Error Trying To Connect To A Postgresql Database
Krydos replied to dranser's topic in Customer Service
Does it work now? -
The show processlist command will show something like this: mysql> show processlist; +---------+----------+-----------+----------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+----------+-----------+----------+---------+------+-------+------------------+ | 6039687 | cmh_user | localhost | cmh_data | Sleep | 9001 | | NULL | | 6039688 | cmh_user | localhost | cmh_data | Sleep | 9002 | | NULL | | 6275255 | cmh_user | localhost | cmh_data | Sleep | 9003 | | NULL | | 6396731 | cmh_user | localhost | cmh_data | Sleep | 9004 | | NULL | +---------+----------+-----------+----------+---------+------+-------+------------------+ Then to close the connection type kill 6039687; Where that number is the ID of the connection. However, if you already have the maximum number of connections open you won't be able to connect to issue those commands... So, just close your connections in your code.
-
Deployed. http://rajesha1.heliohost.org/FINTECH-PROJECTS/
-
Log in to mysql and run the query: show processlist; Depends on the language you're using. In php you could do something like // open the connection $con = new mysqli('localhost', $db_user, $db_pass, $db_data); // query // close the connection $con->close();
-
Deployed. http://rajesha1.heliohost.org/FINTECH-PROJECTS/
-
Well, the most common reason for the max_user_connections error is if you don't close your open mysql connections. For instance, right now you have four open connections that haven't transfered any data in almost two and a half hours! If you would just close those connections after the query then you wouldn't get that error. Don't worry I closed them all for you so you shouldn't be getting that error right now (until you open them all up again without closing them.) As far as the cronjob goes I would create the cron with a command similar to 23 23 * * * /bin/bash /home/cmh/public_html/cron.sh That means at 23:23 each day it will run that command and email you any output. And inside cron.sh put something like #!/bin/bash mysql --host=localhost --user=cmh_user --database=cmh_db --password=bestpasswordever --execute="update mytable set mytable.somedata = '1' where mytable.id = '1'" Let us know if you have any other questions.
-
Deployed. http://rajesha1.heliohost.org/FINTECH-PROJECTS/
-
How To Connect Jsp With Mysql Database In Heliohost
Krydos replied to national's topic in Website Management and Coding
Did you notice that this thread was from almost 4 years ago? It's highly unlikely he's spent the last 4 years trying to figure it out, but I guess if anyone searches and finds this thread it is good advice.