Joomla & MySql config and chmod permissions

Discussion in 'Installation/Configuration' started by normdouglas, Dec 26, 2006.

  1. normdouglas

    normdouglas New Member

    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
     
  2. Hans

    Hans Moderator ISPConfig Developer

    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.
     
    Last edited: Dec 26, 2006
  3. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    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.. :p

    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"...
     
  4. normdouglas

    normdouglas New Member

    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
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess the user is called www-data on your server.
     
  6. normdouglas

    normdouglas New Member

    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
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page