-
Posts
24,867 -
Joined
-
Last visited
-
Days Won
886
Everything posted by Krydos
-
[Solved] Read-only remote access to mySQL with cpanel login
Krydos replied to gdflow's topic in Escalated Requests
I tested remote mysql to Johnny on my personal account. Everything works as expected. mysql> show grants for gdflow_admin; +-----------------------------------------------------------------------------+ | Grants for gdflow_admin@% | +-----------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'gdflow_admin'@'%' IDENTIFIED BY PASSWORD '<removed>' | +-----------------------------------------------------------------------------+ 1 row in set (0.01 sec) mysql> show grants for gdflow_drup254; +-------------------------------------------------------------------------------+ | Grants for gdflow_drup254@% | +-------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'gdflow_drup254'@'%' IDENTIFIED BY PASSWORD '<removed>' | | GRANT ALL PRIVILEGES ON `gdflow\_drup254`.* TO 'gdflow_drup254'@'%' | +-------------------------------------------------------------------------------+ 2 rows in set (0.01 sec) mysql> show grants for gdflow_sql112277; +---------------------------------------------------------------------------------+ | Grants for gdflow_sql112277@% | +---------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'gdflow_sql112277'@'%' IDENTIFIED BY PASSWORD '<removed>' | | GRANT ALL PRIVILEGES ON `gdflow\_gdflow`.* TO 'gdflow_sql112277'@'%' | +---------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) It looks like gdflow_admin has no remote access, gdflow_drup254 has remote access to the database gdflow_drup254, and gdflow_sql112277 has remote access to the database gdflow_gdflow. Even I can't know the password to any of those accounts (unless I bruteforced the hash) so I created a new mysql user to test. I granted the test account with all privileges to gdflow_drup254. Everything worked as expected. # mysql --host=64.62.211.131 --user=gdflow_krydos -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 64254 Server version: 5.6.35 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | gdflow_drup254 | +--------------------+ 2 rows in set (1.19 sec) mysql> -
We've been providing free tomcat java hosting for over 10 years and you're the first person to think they need to edit server.xml. If you want control of server.xml and everything else I recommend you check out https://www.heliohost.org/partners/vps
- 11 replies
-
- server.xml
- tomcat
-
(and 4 more)
Tagged with:
-
You're causing thousands of other people sharing your server emails to go to spam because you're dropping Tommy's senderscore with these emails. How about if we move your account to Johnny temporarily to give you some time to figure out your spam issue. If you can get the spam to stop we'll move you back to Tommy.
-
Did this help? https://www.helionet.org/index/topic/32234-undeploy-war-file/?p=145733
-
Well, before we waste too much time on this issue [Discuz!] (C)2001-2099 Comsenz Inc. This is NOT a freeware, use is subject to license terms Do you have a license to use this software?
-
An email has been sent to your contact address containing a link to your backup.
-
You never responded to my question. I'm guessing the answer is yes?
-
Make sure you're using FTP or SFTP. FTPS doesn't work.
-
You can't access it from http://claod.heliohost.org/ because then it would conflict with other deployed .war files. I've tried.
- 11 replies
-
- server.xml
- tomcat
-
(and 4 more)
Tagged with:
-
It deployed your .war file. I can see it at http://claod.heliohost.org/project/ You can deploy a new one as often as you'd like without asking us. If you use the same filename each time it will take considerably less time to deploy.
- 11 replies
-
- server.xml
- tomcat
-
(and 4 more)
Tagged with:
-
Try naming your .war rakesh73_blog.war and deploy that. Some users have had issues with cookies when the system appends your username to the front of the file.
-
Try it now.
-
You're on Tommy now. http://fortesting.me/ If you see a 404 error or a Johnny queued page please clear your browser cache, and flush your os dns records. Thanks for the donation. We really appreciate it.
-
Moving...
-
Ahh, here's the problem: https://stackoverflow.com/a/27276523 The reason my code works and yours doesn't is probably because I specify the timezone driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/krydos_test?serverTimezone=UTC" Your code probably stopped working when daylight savings time went into effect on March 11th.
-
Done. You should now be able to log in and your website should start working within 12 hours.
-
Unblocked. It looks like your SFTP client might have the wrong credentials.
-
Your account was archived because you haven't logged in for quite a while. We have a limited amount of space on our servers, and occasionally we have to remove the unused accounts to make space for new users. To prevent your account from becoming archived again please remember to log in at https://www.heliohost.org/login/ at least once every 30 days. Unarchiving...
-
Are you sure your username/password are correct?
-
I tried that exact same code with my Ricky account, and it works perfectly. What is the link to your script?