moogly
|
| Posted: 02/23/2006, 7:17 AM |
|
hello
I don't know if i'm stupid but I don't find how to install an runtime (php/mysql) on a remote server. This server is not my machine so a can't change any MYSQL or PHP parameters .
I tried to change the Common.php file
"Type" => "MySQL",
"Database" => "test",
"Host" => "mysqlfr",
"Port" => "",
"User" => "tes1",
"Password" => "***r",
but it doesn't work.
how can i work
regards
|
|
|
 |
moogly
|
| Posted: 02/23/2006, 7:52 AM |
|
I'm sure this request is common...but I don't find the solution in the forum (or I don't undestand..)
Locally I work with easyphp and it work. but my ISP has a linux server and when I finish to upload all the php or the html, I don't know what are the modifications I need to do
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 02/23/2006, 9:43 AM |
|
moogly
I don't know if I fully understand your problem but here goes. On the remote server is the database on the same server as the code?? If so your configuration file is probably incorrect. Try this instead.
Type" => "MySQL",
"Database" => "test",
"Host" => "localhost",
"Port" => "",
"User" => "useraccount",
"Password" => "useraccount_password",
In most cases Host should be localhost. Assuming that you set the database up on the remote server you should already have the database name, user (useraccount name) and password already. Plug them in (database, useraccount and useraccount_password) and give it a go......
Also, here is a link that may be of help: http://docs.codecharge.com/studio3/html/UserGuide/Worki...s/Overview.html
|
 |
|
moogly
|
| Posted: 03/04/2006, 1:29 AM |
|
hello mamboBROWN
thank for your reply!
I already have a web site php/mysql and a would like to add some forms perhaps with codecharge.
but my sit is nos located in localhost. It is available in internet and my provider doens't let me touche the server configuration , he juste gave me my linuxaccount / linuxpassword / mysqlpassword /mysqlhostname.
but I dont know how to install my php code in this host .
thank
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/05/2006, 8:22 AM |
|
moogly
When I say that your Host should be "localhost" I am not talking about your computer at home/work I am talking about the code being located on the server where the code is located. By saying localhost the software knows to use the default system information. This in no way is allowing you to change the server configurations.
In regards to your code, your provider has provided you with an FTP account (linuxaccount, linuxpassword). This will allow you to upload your code to the server. (see link below)
It seems like you are really new to this. If so you may want to see if your provider can walk you through uploading and configuring your software (or if they have a FAQ-frequently asked question- section).
Here is a link that may be helpful to you: http://docs.codecharge.com/studio3/html/UserGuide/Worki...ngSettings.html
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/05/2006, 8:29 AM |
|
moogly
Also, just as a suggestion you might want to consider reading the CCS documentation. It can be very helpful. I know its boooooooring and you want to get to the action but it really does help. Believe it or not when I first got involved with CCS, I printed all of the documentation and read all the sections that were of interest to me (And I still don't know everything but I know enough to be dangerous  ).
Just as a note. The links above are to the online documentation. If you want the pdf version here is the link for that: http://support.yessoftware.com/tutorials.asp
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/05/2006, 11:20 PM |
|
moogly,
Without more information it may be not possible to determine if the application doesn't work, or the configuration is wrong, or database doesn't exist, or database cannot be connected to, etc.
At minimum you should use localhost as mamboBROWN mentioned:
"Type" => "MySQL",
"Database" => "test",
"Host" => "localhost",
"Port" => "",
"User" => "tes1",
"Password" => "***r",
If that doesn't work then you can ask your hosting company for help since this is standard configuration.
But first install PHP and MySQL, and test your application on your own computer. This way you will be sure that the application works at all.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
moogly
|
| Posted: 03/08/2006, 4:05 AM |
|
Thank for all these replies!
For peterr : my database is working : For the test I'm using easyphp 1.8
I ve already tried the tools "phprun" and joomla with it.
When I tried to "add new connection" with your parameters (in the server part of the windows"add new connection" I've got the error message :"datalink error" => test connection failed because of provider initialization error,
I havent got this problem when I configure the connection with the "design" windows and an ODBC source.
thank
|
|
|
|
rexd
|
| Posted: 03/13/2006, 1:31 PM |
|
Quote moogly:
...
my database is working : For the test I'm using easyphp 1.8
I ve already tried the tools "phprun" and joomla with it.
When I tried to "add new connection" with your parameters (in the server part of the windows"add new connection"
...
is easyphp 1.8 running on the remote [internet] server?
-:[pls test]:-
Use phpMyAdmin on the remote site to ensure the database "test" exists
Make a fresh empty CCS project
Use an FTP client to your remote host and download the config files for Joomla, phpMyAdmin etc
Load these up in your favourite text-editor
Search these files for your mysqlusername provided by your internet host
The search should find the MySQL section of each applications config file
Read the sections returned
These sections will contain the values required by the Make New Connection settings in CCS, they might be different to the values in the above posts if your host uses a non-standard configuration (hostname, port etc)
Without editing any CCS files as yet
Make New Connection in CCS
Use the values from the search
[Note]
The database sections of the config files will differ greatly but the individual values returned by the search should match exactly in each of the downloaded config files
HTH
|
|
|
|
|
