Krydos

You got blocked for trying to log in to FTP with the wrong password too many times. Unblocked.

So they sign up for your emails on a "crewing company" website? How do they unsubscribe from your emails?

Deployed. http://vickydev.heliohost.org/SpringLogin/ Since you're on Johnny it can take up to 24 hours to start working. Your next deployment, as long as you don't change the .war name, can be done quicker.

Well, you must have been doing something wrong then because I checked. No permissions. I added permissions. Checked again, and now there are permissions showing up.

It's a little frustrating that you won't even try doing what I'm telling you to do to fix your issue. I prefer to teach people rather than do everything for them, but since you're refusing to do it yourself I logged into your account, went to the mysql database page, selected the mysql user crafto_sql, selected the mysql database crafto_sql, clicked add, selected all of the permissions, clicked make changes, and now your user has access to the database. All of which you could have done yourself. Let us know if it still isn't working.

Go to https://tommy.heliohost.org:2083/frontend/paper_lantern/mail/pops.html and create the email address we're going to use in this tutorial. For this example we'll use admin@rutaj6.heliohost.org Now go to https://tommy.heliohost.org:2083/frontend/paper_lantern/mail/filters/managefilters.html and click "Manage Filters" next to the email address we just created. Click "Create New Filter". Name the filter "Pipe Test". For testing let's set it to trigger whenever the Subject contains the string "Pipe Test". Select "Pipe to a Program". In the box type |/home/rutaj6/email/email_handler.phpThat first character is a pipe which is a vertical line. If you want the email to be delivered to your inbox in addition to piping to your script you can click the + on the right side, and set up Deliver to Folder: Inbox. This way it'll pipe it to your script AND put it in the inbox. Create /home/rutaj6/email/email_handler.php with permissions 755. The first two lines are very important. The first line has to be the shebang which is #! and then the path to the PHP version you want to use. The -q flag suppresses the output of php headers. If you echo any output of any kind in your script it will be emailed back to the sender as an error. This includes headers. The second line has to be <?php There can't be any blank lines or random characters or windows line endings. Any of that stuff will mess it up. #!/opt/cpanel/ea-php71/root/usr/bin/php-cgi -q <?php // listen for incoming emails $sock = fopen("php://stdin", "r"); $email = ""; // read email into buffer while (!feof($sock)) { $email .= fread($sock, 1024); } // close socket fclose($sock); // log received email $file = "/home/rutaj6/email/email.log"; $fh = fopen($file, 'a'); fwrite($fh, "$email\n\n\n"); Create /home/rutaj6/email/email.log with permissions 644. Now send an email to yourself at admin@rutaj6.heliohost.org and make sure "Pipe Test" is in the subject line to trigger the filter. If everything worked it should write your email to /home/rutaj6/email/email.log. From there the sky is the limit. You can process this raw input as much as you want and do whatever. Also, completely unrelated to this tutorial, please be aware that each user is only allowed one account as stated in our Terms of Service. Please delete all accounts in excess of one by going to http://www.heliohost.org/classic/support/scripts/delete Possessing more than one account could result in all of your accounts being suspended. Let us know if you need help consolidating your accounts down into one.

There is nothing you NEED to do on the command line. I prefer the command line is all. You can do everything you need to do through cpanel. I was just posting the command line output of my checking for the permissions on that mysql user and not seeing any.

Where do you get your email addresses from exactly? How did the owner of the email address grant you permission to send them email?

Add developershub.tk to cpanel then. Just because cpanel knows how to handle requests for that domain doesn't mean the requests for that domain will go to Tommy.

I don't use OSX or Windows 7, but I think if you install https://dev.mysql.com/downloads/workbench/ on your Mac it includes the mysql command line client.

Installed.

Yeah, it's unlikely that the command mysql is installed by default on either of those operating systems.

Username? Server? Python version?

You don't need ssh access to get mysql on a command line. Add remote access to your database in cpanel and then in a command prompt type: mysql --host=johnny.heliohost.org --user=crafto_sql --database=crafto_sql -p

For FTP 10 failed logins within 1 hour = blocked.

Unexpected end of file usually means you missed closing something, like ", ', or } or something.

The .war file hasn't changed since the last deploy at https://www.helionet.org/index/topic/28907-deploy-war-application-request/?p=131741 Please only request deploys once.

Create MX records where ever your DNS is hosted and point them to johnny.heliohost.org or tommy.heliohost.org.

You may use any of our servers in the EU. No, putenv() is not disabled.

Deployed. http://tk.heliohost.org/hebertbc_plataforma/

mysql> show grants for crafto_sql; +---------------------------------------------------------------------------------------------------------+ | Grants for crafto_sql@% | +---------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'crafto_sql'@'%' IDENTIFIED BY PASSWORD '<removed even though it is just a hash>' | +---------------------------------------------------------------------------------------------------------+ 1 row in set (0.10 sec) Try adding your permissions again. If it had permissions on crafto_sql there would be a line like GRANT ALL PERMISSIONS ON `crafto_sql`.* to 'crafto_sql'@'%'

The + sign in php is a mathematical operator not a concatenation operator. $username+"_"+$subject = 0 not a string.

Check out https://www.helionet.org/index/topic/27822-how-do-i-use-flask-on-johnny/?p=128919

Have you granted your mysql username cratfo_sql permissions (such as select) on the database crafto_sql?

Works for me. http://segurodeautognp.com/