Markie
Posts: 251
|
| Posted: 04/06/2006, 12:30 PM |
|
Today I got the news that my provider will change the IP address of my MySQL server. Now I will have to change the server settings of all my Codecharge applications.
Do I have to open all applications in CCS again, change the server settings and re-compile all pages again, FTP all files to the server again etc. (which is a darn heavy job to do).
Or, is it possible to just change some settings in some files and FTP that files to my new server (which is a less demanding job). Can I change the server settings in files (like with Notepad or something like that) ? If so, which files do I have to work on ?
I hope it's possible !
Markie
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
 |
 |
WKempees
|
| Posted: 04/06/2006, 1:26 PM |
|
Are your CCS applications on machine's different to the MySQL machine?
If not, if they are on the same machine, than connection will be and remain
localhost.
If they are on different machine to the MySQL machine, than in each
applications common.php on the server
you will find
$CCConnectionSettings = array (
"Connection1" => array(
"Type" => "MySQL",
"Database" => "***************",
"Host" => "localhost",
"Port" => "",
[continued.............]
change the text behind "Host"=>"new ip nummer here"
Walter
"Markie" <Markie@forum.codecharge> schreef in bericht
news:244356c3b49f04@news.codecharge.com...
> Today I got the news that my provider will change the IP address of my
> MySQL
> server. Now I will have to change the server settings of all my
> Codecharge
> applications.
>
> Do I have to open all applications in CCS again, change the server
> settings and
> re-compile all pages again, FTP all files to the server again etc. (which
> is a
> darn heavy job to do).
>
> Or, is it possible to just change some settings in some files and FTP that
> files to my new server (which is a less demanding job). Can I change the
> server
> settings in files (like with Notepad or something like that) ? If so,
> which
> files do I have to work on ?
>
> I hope it's possible !
>
> Markie
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
WKempees
|
| Posted: 04/06/2006, 1:27 PM |
|
The other approach, changing the project setting Server profile will however
benefit you in the future
if you ever have to change something in an application and need to upload
it, you are bound to forget the ip has changed.
Never postpone ..........
Walter
"WKempees" <kempe819@planet.nl> schreef in bericht
news:e13th5$e48$1@news.codecharge.com...
> Are your CCS applications on machine's different to the MySQL machine?
> If not, if they are on the same machine, than connection will be and
> remain localhost.
> If they are on different machine to the MySQL machine, than in each
> applications common.php on the server
> you will find
>
> $CCConnectionSettings = array (
> "Connection1" => array(
> "Type" => "MySQL",
> "Database" => "***************",
> "Host" => "localhost",
> "Port" => "",
>
>
> [continued.............]
>
>
> change the text behind "Host"=>"new ip nummer here"
>
> Walter
>
>
>
>
>
>
> "Markie" <Markie@forum.codecharge> schreef in bericht
>news:244356c3b49f04@news.codecharge.com...
>> Today I got the news that my provider will change the IP address of my
>> MySQL
>> server. Now I will have to change the server settings of all my
>> Codecharge
>> applications.
>>
>> Do I have to open all applications in CCS again, change the server
>> settings and
>> re-compile all pages again, FTP all files to the server again etc. (which
>> is a
>> darn heavy job to do).
>>
>> Or, is it possible to just change some settings in some files and FTP
>> that
>> files to my new server (which is a less demanding job). Can I change the
>> server
>> settings in files (like with Notepad or something like that) ? If so,
>> which
>> files do I have to work on ?
>>
>> I hope it's possible !
>>
>> Markie
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
kangus
Posts: 47
|
| Posted: 04/06/2006, 1:48 PM |
|
I keep my local test server IP in my windows/system32/drivers/etc/hosts file alias with tn n meaing the number of the test server as sometimes I have several boxes I'm building....
hosts file content:
10.1.128.1 t1 CCS ajax companyx.loc companyy.loc
10.1.128.2 t2 mail.server.loc
I can reach a project by http://ajax if I have apache setup with ajax as a virtual host.
If I change my test server I only change my hosts file NOT any of the projects
All my projects have connectors built using dbc1 and the ODBC connectors point to my virtual hosts.
_________________
PHP 4/5 mySQL 4.1/5 CCS 3.x |
|
|
|
Markie
Posts: 251
|
| Posted: 04/07/2006, 1:33 AM |
|
Dear Walter (another time you helped me out !)
The server and MySQL server are on the same machine. But, at the time I created the files I had to point the settings to my on-line MySQL server, as I don't have MySQL installed on my local machine. So, the settings in common.php point to the on-line IP address.
Now, my provider told me I can point all MySQL settings to 127.0.0.1 as it will be stable and more secure.
Is it possible for my to use 127.0.0.1 in common.php
Thanks again,
Markie
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
|
|
|
WKempees
|
| Posted: 04/07/2006, 2:26 AM |
|
127.0.0.1 is Localhost !
So folowing the described method
change
Host" => "localhost",
or
Host" => "127.0.0.1",
"Markie" <Markie@forum.codecharge> schreef in bericht
news:2443623f6143a0@news.codecharge.com...
> Dear Walter (another time you helped me out !)
>
> The server and MySQL server are on the same machine. But, at the time I
> created
> the files I had to point the settings to my on-line MySQL server, as I
> don't
> have MySQL installed on my local machine. So, the settings in common.php
> point
> to the on-line IP address.
>
> Now, my provider told me I can point all MySQL settings to 127.0.0.1 as it
> will
> be stable and more secure.
>
> Is it possible for my to use 127.0.0.1 in common.php
>
> Thanks again,
>
> Markie
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
