Eladesor
|
| Posted: 06/13/2001, 6:34 AM |
|
Hi,
Apols to the group for the 'newbee' questions, but I'm trying to use CC with
PHP and MySql (which is alien to me).
I have managed (with lots of kind help) to create and run a copy of the CC
demos on my workstation in PHP & MySql. My problem is transferring and
running this on a unix server.
Previously when I have created ASP and FTP'd it to a MS Server, all runs ok.
But when I try to FTP PHP & MySql to a unix server I constantly receive
Database error: pconnect(localhost, , $Password) failed. MySQL Error: ()
Session halted.
My ISP has a MySql manager on it, but it only creates new tables. Do I need
to create / edit / do whatever..... on the server before ftp'ing from CC?
Should I 'Dump' the table from PhpMyAdmin? if so what do I do with the file
afterwards?
Sorry, but where PHP & Mysql are concerned I might as well be on a parallel
universe.
Many thanks, regards to the group.
Eladesor.
|
|
|
 |
Hellen
|
| Posted: 06/13/2001, 7:05 AM |
|
Eladesor,
have you created MySQL db on Unix server? Note, you can't upload it as .mdb,
it should be created rigth on server
It looks like you've entered incorrect settings in Site/Properties/Database
tab. Please check, the next shpuld be set up:
- Database Name
- Login
- Password
- Db Type: MySQL
- Host: host name or IP
You can also read more about it at :
http://support.codecharge.com/tutorials/myodbc.html
Regards,
CC Support
"Eladesor" <WebMaster@EverythingButComputers.com> wrote in message
news:9g7q60$jts$1@mail.tankhill.com...
> Hi,
>
> Apols to the group for the 'newbee' questions, but I'm trying to use CC
with
> PHP and MySql (which is alien to me).
>
> I have managed (with lots of kind help) to create and run a copy of the CC
> demos on my workstation in PHP & MySql. My problem is transferring and
> running this on a unix server.
> Previously when I have created ASP and FTP'd it to a MS Server, all runs
ok.
> But when I try to FTP PHP & MySql to a unix server I constantly receive
> Database error: pconnect(localhost, , $Password) failed. MySQL Error: ()
> Session halted.
>
> My ISP has a MySql manager on it, but it only creates new tables. Do I
need
> to create / edit / do whatever..... on the server before ftp'ing from CC?
> Should I 'Dump' the table from PhpMyAdmin? if so what do I do with the
file
> afterwards?
> Sorry, but where PHP & Mysql are concerned I might as well be on a
parallel
> universe.
>
> Many thanks, regards to the group.
> Eladesor.
>
>
>
>
|
|
|
|
Eladesor
|
| Posted: 06/13/2001, 7:41 AM |
|
Thanks for the reply Hellen,
But I still don't understand.
> have you created MySQL db on Unix server? Note, you can't upload it as
..mdb,
> it should be created rigth on server
Eh? as prevously stated "PHP and MySql (which is alien to me)." Sorry have
no idea what your talking about.
> It looks like you've entered incorrect settings in
Site/Properties/Database
> tab. Please check, the next shpuld be set up:
> - Database Name
> - Login
> - Password
> - Db Type: MySQL
> - Host: host name or IP
Whilst running on workstation, all seetings are correct (as it runs), when
using server have changed Ip and login & Password accordingly.
> You can also read more about it at :
> http://support.codecharge.com/tutorials/myodbc.html
Already printed this and read it.
I'll read up a bit more - thanks for trying.
Regards
Eladesor.
<snip>
|
|
|
|
Joachim Uersfeld
|
| Posted: 06/13/2001, 11:35 AM |
|
> I constantly receive
> Database error: pconnect(localhost, , $Password) failed. MySQL Error: ()
There ist no username. I think, without a username and a passwort it isn't
possible to connect to mySQL. You should insert this in the database
properties in CodeCharge.
Joachim
|
|
|
|
Jeff Stuart
|
| Posted: 06/13/2001, 4:15 PM |
|
Eladesor, yes, you should dump the db from phpMyAdmin (which I assume is on
YOUR workstation yes?). It will save it as a .sql file. Then, using your
hosts mysql manager, import the .sql file and use the included SQL commands
to actually create your database.
As far as your error goes, it looks like you are doing 2 things wrong. 1)
You are not providing the correct hostname to the database and 2) You are
not providing the correct username/password. Fix those 2 and then you
should be in business. If not, come on back and yelp! :)
--
Jeff Stuart
jstuart@neo.rr.com
"Eladesor" <WebMaster@EverythingButComputers.com> wrote in message
news:9g7q60$jts$1@mail.tankhill.com...
> Hi,
>
> Apols to the group for the 'newbee' questions, but I'm trying to use CC
with
> PHP and MySql (which is alien to me).
>
> I have managed (with lots of kind help) to create and run a copy of the CC
> demos on my workstation in PHP & MySql. My problem is transferring and
> running this on a unix server.
> Previously when I have created ASP and FTP'd it to a MS Server, all runs
ok.
> But when I try to FTP PHP & MySql to a unix server I constantly receive
> Database error: pconnect(localhost, , $Password) failed. MySQL Error: ()
> Session halted.
>
> My ISP has a MySql manager on it, but it only creates new tables. Do I
need
> to create / edit / do whatever..... on the server before ftp'ing from CC?
> Should I 'Dump' the table from PhpMyAdmin? if so what do I do with the
file
> afterwards?
> Sorry, but where PHP & Mysql are concerned I might as well be on a
parallel
> universe.
>
> Many thanks, regards to the group.
> Eladesor.
>
>
>
>
|
|
|
|
Eladesor
|
| Posted: 06/13/2001, 4:40 PM |
|
<snip>
Thanks,
Have found out that my host requires me to use my control panels login
/password and database name = login for the database, which is where I think
I was going wrong.
The other part which has been confusing me is that the servers MySql admin
doesn't support import, only create new database / table.....
Obviously this has meant that I could not (i think) import the .sql file
correctly. To try and resolve it I found a php file called 'mpanel' which
should allow access to my host's Mysql and also supports import. - Well
that's the theory;).
Thanks for the help, everyone - really appreciated :)) To round the day off
with a bit of humour (for you) as I result of my 'novice' to say the least
skills, after uploading 'mpanel' and trying to use it - I managed to bring
my hosts system down, which resulted in me being locked out of the system
for about two hours whilst they reset my server and control panel! Ah well,
look on the bright side, I might not have fixed my problem, but I sure
highlighted one for them :)
Regards
Eladesor.
|
|
|
|
|
