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

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.

 

"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?

 

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

ms

 

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!

 

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.

 

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

 

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'?

 

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'

 

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.

 

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?

 

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.

 

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.

 

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

 

Thanks. I think I finally figure out how ISPConfig handles with MySQL database.