Krydos

Glad your problem got solved! Please spare a few minutes to take our brief survey: http://feedback.heliohost.org/ Your participation in this survey is greatly appreciated.

Thank you for reporting this. It seems Horde webmail on Johnny had some corrupted datafiles. I fixed the issue and it should be working again now. Let us know if you're still having issues checking your mail with Horde.

So, you're saying that it will only work with version 4.4.0 and if I can't upgrade the system to the absolute latest version it isn't worth upgrading it at all because it still won't work?

There are always plans to upgrade everything. The way we prioritize what gets upgraded and in what order is when users show interest in something being upgraded and how many users it will benefit. So, thanks for showing your interest in this feature.

If the manual installation is too complicated to figure out, you can always install open real estate with softaculous with this link http://johnny.heliohost.org:2082/frontend/x3/softaculous/index.live.php?act=software&soft=445

Your account was resuspended for failure to take care of the malware problem during your allotted 24 hour period. The offending files have been deleted, and your account has been manually unsuspended. If you still see the suspended page then you should try clearing your browsers cache.

Make sure the .war file is located in /home/<username>

Can you find out what version you need then? Perhaps if you ask the developers of the Ioncube PHP Encoder 8 software, or if you can find a website that lists the system requirements. I'd be happy to upgrade this for you, but I need to know what version you need.

Stevie currently has ioncube loader 4.0.9 Johnny currently has ioncube loader 4.2.2 The latest version of ioncube loader appears to be 4.4.0 What version do you need?

./deploy_java deyi freephoto.war User deyi found. Unable to find file: freephoto.war Usage: deploy_java <username> <.war file>

This database name is incorrect because all databases that users can create have their username appended to the front of it. If you type in "test" then the database name is "schimpfk_test". Hence the "cannot select database" error.

What do you need the ftpd logs for? What do you need the ftpd logs for?

Why do you need more than 4 simultaneous connections? If you just close your connections after each use most people only need 1.

Fixed.

Download http://area52.heliohost.org/djangotest.zip Extract to a directory in your public_html Create /home/<username>/.python_egg_cache Chmod 777 .python_egg_cache Edit /home/<username>/public_html/<djangofolder>/dispatch.wsgi sys.path.append("/home/<username>/public_html/<djangofolder>"); os.environ['PYTHON_EGG_CACHE'] = '/home/<username>/.python_egg_cache'

What do you need more than 4 mysql connections for?

It looks like this has nothing to do with your database, but rather you had permalinks set up and then lost your mod_rewrite rules located in your .htaccess file. I'm not very familiar with wordpress, but I think if you log into your admin area and check your permalink settings you can get this fixed. The other option is if you have a backup of your site you can restore the .htaccess file you had.

Count: 17 Time=9.89s (168s) Lock=0.45s (7s) Rows=0.0 (0), b2scs[b2scs]@localhost DELETE FROM `joomla_session` WHERE `time` < 'S' -- Count: 4 Time=40.89s (163s) Lock=0.14s (0s) Rows=7.2 (29), b2scs[b2scs]@localhost SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id -- Count: 7 Time=19.57s (137s) Lock=0.27s (1s) Rows=0.0 (0), b2scs[b2scs]@localhost INSERT INTO `joomla_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES ('S', N, N, 'S', N, 'S') -- Count: 8 Time=14.97s (119s) Lock=0.01s (0s) Rows=0.0 (0), b2scs[b2scs]@localhost INSERT INTO `joomla_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`) VALUES ('S','S','S','S','S','S','S','S','S','S') -- Count: 55 Time=1.63s (89s) Lock=0.06s (3s) Rows=27.0 (1486), b2scs[b2scs]@localhost SELECT `update_id` FROM `joomla_updates` WHERE element = 'S' AND type = 'S' AND client_id = 'S' AND folder = 'S' -- Count: 159 Time=0.52s (82s) Lock=0.02s (2s) Rows=1.9 (302), b2scs[b2scs]@localhost SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > 'S' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, N) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE N END AS parents_published FROM joomla_content AS a LEFT JOIN joomla_content_frontpage AS fp ON fp.content_id = a.id -- Count: 4 Time=18.33s (73s) Lock=0.14s (0s) Rows=0.0 (0), b2scs[b2scs]@localho st UPDATE `joomla_update_sites` SET `last_check_timestamp` = 'S' WHERE `update_site_id` = 'S' -- Count: 49 Time=0.97s (47s) Lock=0.02s (1s) Rows=2.0 (98), b2scs[b2scs]@localhost SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias)!=N THEN CONCAT_WS('S', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM joomla_categories as c LEFT JOIN joomla_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) -- Count: 1 Time=39.22s (39s) Lock=0.04s (0s) Rows=11.0 (11), b2scs[b2scs]@localhost SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joomla_modules AS m LEFT JOIN joomla_modules_menu AS mm ON mm.moduleid = m.id

Unfortunately, python is heavily tied to cPanel, so if we upgrade the default version of python it could break a lot of other functionality. The good news is that multiple versions of python can coexist easily on the same server without interfering with each other; you just use different shebang lines to access the version that you need.

What is the file name of the .war file?

Ok, I finally got around to testing some of this stuff for you. Yes, SFTP only works for the root FTP account so that won't work for you. I set up a FTP account that only has access to one subdirectory, and successfully connected to it with FTP protocol with TLS. I tested this on both Johnny and Stevie. Here are some example settings that work with Filezilla. Just replace the portions in <> with your information: Host: ftp.<domain>.heliohost.org Port: 21 Protcol: FTP Encryption: Require explicit FTP over TLS Logon type: Normal User: <ftpusername>@<domain>.heliohost.org Password: <ftppassword> The first time you connect there will be a popup asking if you want to trust the self-signed SSL certificate. Let us know if you're still having trouble connecting to FTPS.

What server is your account located on, and which version of python are you using?

I recommend looking at http://heliohost.grd.net.pl/monitor/ and choosing a time when the server load is load.

Well, if you choose "every minute" then you would be running 1440 crons per day which is 1438 more than you're allowed and your account will be suspended. If you choose "every five minutes" then you would be running 288 crons per day which is 286 more than you're allowed and your account will be suspended. If you choose "twice an hour" then you would be running 48 crons per day which is 26 more than you're allowed and your account will be suspended. If you choose "once an hour" then you would be running 24 crons per day which is 22 more than you're allowed and your account will be suspended. If you choose any of the other options you should be fine as long as you don't set up multiple jobs. For instance if you choose "once a day" but then have 3 different jobs that all said "once a day" that would be a total of 3 cron jobs per day and your account will be suspended. I also recommending setting your cron jobs to run at random times of the day. For some reason everyone thinks their crons need to run at exactly midnight or exactly 3:00 pm or whatever. However, if everyone else crons are running at that same time then the server load spikes up and accounts get suspended for it. If you choose a random time like 1:39am then you have even less chance of being suspended.

I've got no problem running commands for you, but I'm not going to run any random command that any random person posts here. Furthermore, if that command just creates tables on a database, wouldn't it be easier to just run the command on your local machine, export the database, and import the .sql to a database hosted on Heliohost. That way it doesn't matter to us what the command does or doesn't do.