Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Web Hosting (http://www.go4expert.com/forums/web-hosting-talk/)
-   -   What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP (http://www.go4expert.com/forums/part-i-missing-ftp-server-ftp-client-t16885/)

Typr451 12Apr2009 04:04

What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
Hi!

I'm begining to work on a project and this is the part I love when I can't make effective Google-queries because I haven't got all the buzzwords down :)

Some years ago I did little project for a course with mainly JSP, SQL and Resin to act as a web-server. I configured Resin to connect the database to the web-pages. I had to place some sql- and jsp-packages for Resin to find aswell and everything worked.

This time I've decided to work with PHP, SQL and it's all supose to be on a FTP server. I found FileZilla which had got a lot of good comments and I've been able to contact and upload files to the FTP server.

I'm not really sure where I am now :) I think I need to know how to configure a FTP Server to work like Resin did for me and make it connect the database to the web-pages. It also need to find a PHP- and SQL-package. I've Googled for combinations of PHP, SQL, FTP, FileZilla and install/configure etc. but I can't really find anything interesting so it makes me think I'm missing some words.

shabbir 12Apr2009 11:29

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
FTP is something different than the server which would run your PHP Files.

I would try to give an example

First create a simple PHP file and name in xyz.php
Put the following content into the file
PHP Code:

<?php
echo phpinfo();
?>

Now open the filezilla and connect to your FTP server.
See if there is any folder named public_html / httpdocs or anything where you can host your php files for Apache server to run it.
After uploading the xyz.php file into the server use the browser to open the file

yourdomain.com/xyz.php

You should be able to see all the php configuration available on your server.

I hope it helps

Typr451 13Apr2009 05:46

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
Yes, thank you I understand much better what I'm working with now :)

The part about MySQL shown with phphinfo() seems to be installed, it shows a version and where to find socket-, include- and lib-files however the username and passwords are all blank so I don't think it've been configured properly.

The thing now is that I don't see the config-files or any files in FileZilla (FTP client, the server isn't mine) apart from the web-pages. I get quite a few tutorials with my searches but they all explain how to install everything from scratch on your own machine. I can see configure commands at the top of phpinfo but they seem to be arguments to where to find the config-files, and I sitll can't see them.

I can't find an answer to this so I'll ask, can I change the config-files (like the MySQL-config) with FileZilla? Should they be seen in the directory tree? Or do I have to contact the admin and let him go through the MySQL-configuration again and set a username and password? I've checked the options to show hidden files but they don't seem to be there, also trying to reach for example /var/mysql says "no such directory or file", so they really don't seem to be there.

I don't really think I should be able to get to the /var/mysql-folder, FileZilla doesn't give me access to his machine, only the Apache web server which only makes the web-pages available. Then through FileZilla I can change what files it makes available, however I'm hoping I'm wrong :)

Also to add a little answer to my first post: I was also thinking about a program like SQLyog to remotly create tables and such to the database. I still need the username/password for it to work though :)

shabbir 13Apr2009 10:04

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
For MySQL you need to run queries from your PHP Files only and do not need anything special folder access. phpMyAdmin would be there in your control panel to see the databases, create them and other stuff.

Typr451 13Apr2009 23:11

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
Don't I still need a MySQL-username and password for phphMyAdmin? I mean "root" and something? In the MySQL-part of the printout from phpinfo it says "no value" on host, password, port, socket and user so I think MySQL itself haven't been configured.

I got phpMyAdmin to work I think (with lots of warnings), I follwed the instructions and placed the files for the web server to find and I could get into the configure file with phpMyAdmin/setup. However I had to enter a password there as well, wouldn't that be the password you set when you confiure MySQL?

It seems too insecure to be able to set that password by simply typing /setup in someone's URL, but I tried whatever for password and tried to login with it from /phpMyAdmin but it wasn't right.

I've also read a couple of tutorials for phpMyAdmin and they seem to say you'll use your root/password for MySQL in the config-files, still I'm hoping I'm wrong. It'll save me some trouble :)

shabbir 13Apr2009 23:34

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
Yes you would need the username and password but what I meant is you would not need any special folder for it.

Typr451 19Apr2009 00:18

Re: What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP
 
I'm not sure I should say this, but if it says "no value" apparently you're able to login to phpMyAdmin with username/password " " or space. I'm saying this now because I've taken are of the issue on my sever, still not fun for new people setting up their database and forgetting to set a password, or careless people leaving the phpMyAdmin on their server. This wasn't possible with SQLyog.


All times are GMT +5.5. The time now is 23:00.