Hey all, just new to ISPCONFIG and just love it already. I have been developing in Joomla for awhile now and I think I have a little problem I hope others have had before. I seem to have an FTP and MYSQL permissions problem, and although I've been able to fix it with various chmod commands I don't think it's ideal from a hosting point of view. Not that I'm going to be running a commercial hosting platform but I am going to be setting up accounts for students and need them to be able to do most of this themselves. I think the problem relates to the fact that the MYSQL db that ISPCONFIG creates doesn't use the user account the site relates to. Consequently when Joomla tries to create the files etc it has permission problems. I've googled quite a bit and found a very good tutorial which suggested to chmod the web directory to www-data:www-data, which certainly fixed the problem, but I'm not convinced this is the best way. Because the doesn't allow Joomla modules such as the brilliant Joomla Xplorer to have full control over the folders via a web interface. I have other Joomla sites hosted on commercial servers and it all works without a problem. I'm no Linux pro but I can stumble my way around, and I think the problem stems to the fact that when you create a MYSQL db from within ISPCONFIG it doesn't appear to use the account that is the owner of the web directory of that site. Then when Joomla takes the MYSQL account, it doesn't have control over the web directory. I hope I have made myself understood? So my question is... 1. Am I doing something wrong? 2. How can I make the MYSQL db use the same account as for the web directory. Really hoping some of you ISPCONFIG gurus read this, sorry for the longwinded but I'm sure I'm not alone here, as I have found a lot of articles on how to chmod Joomla directories in an ISPCONFIG environment. Thanks in advance
I've written the howto "Joomla on an ISPConfig server within 10 easy steps" here: http://www.howtoforge.com/joomla_ispconfig Within this howto for security reasons i have chosen to use www-data instead of using chmod 777 for example. Maybe i do not answer your question exactly, but I host a lot of Joomla sites myself and personally i have a good experience with the permission-settings mentioned here: chgrp www-data administrator/backups chgrp www-data administrator/components chgrp www-data administrator/modules chgrp www-data administrator/templates chgrp www-data cache chgrp www-data components chgrp www-data images chgrp www-data images/banners chgrp www-data images/stories chgrp www-data language chgrp www-data mambots chgrp www-data mambots/content chgrp www-data mambots/editors chgrp www-data mambots/editors-xtd chgrp www-data mambots/search chgrp www-data mambots/system chgrp www-data media chgrp www-data modules chgrp www-data templates chmod g+w administrator/backups chmod g+w administrator/components chmod g+w administrator/modules chmod g+w administrator/templates chmod g+w cache chmod g+w components chmod g+w images chmod g+w images/banners chmod g+w images/stories chmod g+w language chmod g+w mambots chmod g+w mambots/content chmod g+w mambots/editors chmod g+w mambots/editors-xtd chmod g+w mambots/search chmod g+w mambots/system chmod g+w media chmod g+w modules And yes, sometimes filefolders are not accessible via FTP. This means that it this setup is not so comfortable for the webmaster, but security comes first.
The only way ive found to run joomla / mambo or another php package (not developing.. its funny) is to have a copy of sources on another folder, por example: /home/software/joomla /home/software/mambo /home/software/phpbb /home/software/oscommerce /home/software/claroline Owned by apache:apache.. Then, when some client want some of this packages, i just copy it inside the web folder.. then all run smoothly... ftp access, modules install, everything "perfect"...
Can't find apache I read this too, but I can't find the user apache on the server. I have a standard Ubuntu install and I'm using Webmin to administer it. Thanks for the replies
So do you mean that you then copy whilst logged in a either admin or sudo? Because I still don't understand how the folders get the right permissions. Every other site I have either setup and or administer via a commercial hosting solution uses the same account for both the MYSQL and the FTP account. Wouldn't this be easier, surely there is a way to do this? Why does the MYSQL require yet another unix account? Cheers
You can do this in ISPConfig as well, but then you must run your server with SuPHP instead of mod_php. There are several thraeds about suphp configuration in the forum, if you want to try this.
