Accessing https://....:81 another way?

Discussion in 'Tips/Tricks/Mods' started by hairydog2, Nov 10, 2005.

Thread Status:
Not open for further replies.
  1. hairydog2

    hairydog2 New Member

    I'm currently working somewhere the sysadmins have a rather restrictive firewall.

    I can't reach port 81 of any external sites, and can't VPN out either. Is there a way I can get to port 81 to control my ISPConfig server?

    I do have other internet-connected computers I could go via.
     
  2. hairydog2

    hairydog2 New Member

    "import" a mysql database

    Being new to ISPConfig, when I was transferring a site over to the ISPConfig machine, I hadn't noticed the mysql database tab in ISPConfig, so I set up the database using phpmyadmin instead.

    I imported the data, and everything is working, but the mysql doesn't show up in ISPConfig as that user/sites's database.

    Is there any way I could make this database attach itself to the correct bit of ISPConfig, or would I have to recreate the database, then export and import the data?
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    You will have to recreate the database and import the data to the new DB.
     
  4. mystix

    mystix New Member HowtoForge Supporter

    i think, it should be possible to give a second IP-adress to the apache of ispconfig. Or am I wrong?

    ms
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    If you have a second IP address, you can change the httpd.conf of the ISPConfig httpd in /root/ispconfig/httpd/conf/ so that ISPCOnfig will only listen on this IP on port 80 and 443.
     
  6. rosa hsiao

    rosa hsiao New Member

    If I recreate a new database,ISPConfig will give me a default database named webxx_dbxx. How can I import my original database and change the database name as same as the original one (ex.: members). Otherwise,I have to modify all the php programs to use the new database. That would drive me crazy!
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    You cannot modify the database names that ISPConfig creates. If you want to use custom names, you will have to create the databases manually with e.g. phpmyadmin.
     
  8. hairydog2

    hairydog2 New Member

    Would this mean compiling Apache all over again? I thought there was a custom version of Apache involved, though I've never been clear why.
     
  9. mystix

    mystix New Member HowtoForge Supporter

    No you don't have to recompile anything.
    ISPConfig has his own apache and you have to make the changes in the httpd.conf of ISPConfigs apache who is located in /root/ispconfig/httpd/conf/.

    I think the advantage of a second webserver for the controlpanel is that the controlpanel is still rechable in case of problems with the main webserver and you can configure your own webserver the way you want and don't need to consider the special mods and configs for the controlpanel.

    ms
     
  10. rosa hsiao

    rosa hsiao New Member

    Do you mean I don't have to use ISPConfig to create database for my website?
    If the original database name of my website is called 'members' instead of 'web1_db1',I have to create the database name manually with usual phpmyadmin or mysql command? Under such condition,will ISPConfig still have any control over the database privilege for 'members'?
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    You dont have to create the databases in ISPConfig. But if you create the database in phpmyadmin you will also have to create the users and ppriviliges for this database with phpmyadmin.
     
  12. rosa hsiao

    rosa hsiao New Member

    If I want to create a client with 5 sites and also grant the client the ability to create 5 databases in ISPConfig. Can you tell or redirect me to a url as how to create different site users and privileges for different database names?

    How to change the default database name to a user defined one such as:
    'web1_db1' ===> 'members'
    'web2_db2' ====> 'catalogus'
     
  13. falko

    falko Super Moderator ISPConfig Developer

    Have a look at MySQL's GRANT syntax: http://dev.mysql.com/doc/refman/4.1/en/grant.html, or use phpMyAdmin to create new users.

    You can't do that with ISPConfig, you have to create the databases manually, e.g. with phpMyAdmin.
     
  14. rosa hsiao

    rosa hsiao New Member

    When client_A is assigned only to own 5 databases in ISPConfig,what will it happen if I create over 5 databases manually for the administrator of client_A with phpmyadmin? Or there is nothing to do with database limitation in ISPConfig?
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    If the databases where not created by ISPConfig you cannot limit the number in ISPConfig.
     
  16. hairydog2

    hairydog2 New Member

    Is it necessary to run on a different port? Why not a subdomain?

    Please note that this may not be practical: I'm just wondering why not.
     
  17. falko

    falko Super Moderator ISPConfig Developer

    If both Apaches ran on the same port, they would collide (i.e., one of them would refuse to start). If they ran on the same port, but on different IP addresses, then it's possible.
     
  18. hairydog2

    hairydog2 New Member

    I think that different IP addresses is where I shall have to go. It's only £12 per year extra.
     
  19. rosa hsiao

    rosa hsiao New Member

    Thanks. I think I finally figure out how ISPConfig handles with MySQL database.
     
Thread Status:
Not open for further replies.

Share This Page