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

[hairydog2]

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.

[hairydog2]

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?

[till]

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?
You will have to recreate the database and import the data to the new DB.

[mystix]

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.

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

ms

[till]

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

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.

[rosa hsiao]

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

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!

[till]

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.

[hairydog2]

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.

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.

[mystix]

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

[rosa hsiao]

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.

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

[till]

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.

[rosa hsiao]

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.

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'

[falko]

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

How to change the default database name to a user defined one such as:
'web1_db1' ===> 'members'
'web2_db2' ====> 'catalogus'You can't do that with ISPConfig, you have to create the databases manually, e.g. with phpMyAdmin.

[rosa hsiao]

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?

[till]

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

[hairydog2]

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.

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.

[falko]

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

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.

[hairydog2]

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.

[rosa hsiao]

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

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