Hi,
I am a total beginner and installing Drupal. I only know html and css. I have zero knowledge in PHP. I have a domain name and a pay hosting service totally standard. (1 Base MySQL 4, Php4 , Php 5)
I have downloaded the drupal folder from the drupal site. It is now on my destop. (Windows xp home)
I am following the Drupal handbook instructions.
1. DOWNLOAD DRUPAL
well, its done. Yeah, that was easy.
2. CREATE AND PREPARE THE DRUPAL DATABASE
Before you proceed to the next step you should know:
- "username" - the username for connecting to the database
- "password" - the password for that username
- "databasename" - the name of the database.
Okay, I went on the managerV3 of my host and I created a database, just by pressing a button.
I see now the following:Between brackets is the translation in english of this funny language called french.
Gestion de MySQL (MySQL manager):
robocrowevo vide(empty) sql MySQL 4 Activer le mode développement (Activate the development mode)
A few minutes later, i received the ID/ password for my database by email. So I have now my "username", my "password" and my "database name". Good, I can process to next step!
Depending on the database of your choice, please read either
INSTALL.mysql.txt (for MySQL) or INSTALL.pgsql.txt (for PostgreSQL).
Ok, I guess I use mysql, so I read the explanation there.
All I know is when I connect myself to the Phpmyadmin of my host, I see the following:
"Database robocrowevo running on mysql4"
In the Mysql installation description, I have this:
First, you must create a new database for your Drupal site
(here, 'databasename' is the name of the new database):
mysqladmin -u dba_user -p create databasename
MySQL will prompt for the 'dba_user' database password and then create
the initial database files. Next you must login and set the access
database rights:
mysql -u dba_user -p
Again, you will be asked for the 'dba_user' database password.
At the MySQL prompt, enter following command:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';"
Right ok , so I put the command in the box called:Run SQL query/queries on database
mysqladmin -u dba_user -p create robocrowevo.
I got an error message. I thought, maybe this database has already been already created, so no need to create it one more time.
I skipped the rest, although it is probably a mistake...
3. CONNECTING DRUPAL:
The moment of true...
The default configuration can be found in the
'sites/default/settings.php' file within your Drupal installation.
Before you can run Drupal, you must set the database URL. Open the
configuration file and edit the $db_url line to match the database
defined in the previous step:
$db_url = "mysql://username:password@localhost/databasename";
Ok, this is easy, I just replace the words "username", "password" and "databasename" by this same info sent by my provider. I found the file in my drupal directory (still on my computer desktop) and did the changes.
Oki doki. I decided at that point to upload everything in the www folder of the host server, using filezilla. A few minutes later, that was done and I have a folder Drupal 4.7.3 on my remote site.
I skipped the explanation about hosting several site with one drupal configuration
4. CONFIGURE DRUPAL:
You should consider creating a "files" subdirectory in your Drupal
installation directory. This subdirectory stores files such as
custom logos, user avatars, and other media associated with your
new site.
Ok done, on the remote server, I created in the drupal folder a folder called "files". By right clicking on this new file (i think this is a filezilla option), I select "file attributes" then owner permission as well as public permission, and ticked "read" and " write". Why did I do that?
The sub-directory requires "read and write" permission
by the Drupal server process. You can change the name of this
subdirectory at "Administer > Settings > File system settings".
The thing is: I dont have a clue where to find this Administer...
I hope you had the patience to read all this. I will report all my progress in this installation.
This is exactly where I am...What do i do next?
Comments
Administer
Next you point your browser at your installation.
Then follow the links to create the first user account.
After you create the first account, login and go to:
www.example.com/?q=admin/settings
'File system settings' is the 4th option block.
--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.
--
http://ken.therickards.com
Thanks Agentrickard ! If I
Thanks Agentrickard !
If I go to: http://www.robocrow.com/, as I have removed my index.html file from the root, I see:
Name Last modified Size Description
Parent Directory 04-Sep-2006 22:10 -
drupal-4.7.3/ 04-Sep-2006 21:44 -
memo/ 02-Sep-2006 11:03 -
I click on the Drupal folder, i got:
Unable to connect to database server
This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database server is down.
The MySQL error was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
I am pretty sure i used the correct info in settings.php file, I think something is not activated on my database...I will check in the forum of my hosting provider.
MySQL
BTW: Thanks for the excellent listing of the steps you took. It make support much easier.
The mysql commands listed in the instructions weren't SQL queries, they were the command lines you type in at the command prompt. You probably don't have a command prompt on your hosting account, so you have to try and do the same thing via some sort of web interface (ie phpmyadmin in your case).
mysqladmin -u dba_user -p create databasenameThis creates a new empty database and this has already been done for you by your host, and they gave you the details. So far so good.
mysql -u dba_user -pThis is another command line that connects to the database to run some queries.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';"
This is a SQL query that you run to set up some permissions and create your database user. All of this (or at least most of it) will have already been done for you. But beware, your host might not let you have the LOCK TABLES bit which may cause trouble for you later. See the troubleshooting FAQ in the Drupal handbook.
Yep, you were right. That was the mistake :)
The rest of those steps talk about running a SQL script that creates all the Drupal tables in your database. There are different files for different database types, you need to use the correct one. It will use the command line example, but basically you will use phpmyadmin instead to import that script file into your database. Look for a SQL tab in phpmyadmin or some other import functionality, then upload the appropriate SQL file into phpmyadmin.
Worry about the files directory permissions later. Drupal will still run if it can't write to that directory. We'll just concentrate on setting up the database for now...
--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
Example Knowledge Base built using Drupal
--
Anton
Hi Styro, Thank you for your
Hi Styro,
Thank you for your time.
In the command prompt, I wrote (copying-pasting) exactly the following:
mysql - u dba_user - p
I pressed the "go" button
I got:
Error
SQL-query :
mysql - u dba_user - p
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql - u dba_user - p' at line 1
Then I tried:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON robocrowevo.*
TO 'robocrow'@'localhost' IDENTIFIED BY '*********';"
(where * is my password.)
I got:
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ErrorSQL - query : GRANT SELECT ,
INSERT ,
UPDATE ,
DELETE
Am I in the right version of database? It says at the top: Database robocrowevo running on mysql4
It does not seem to recognize what I say though...
The other info I wanted to give is this one:
On top of the dialog box, I see:
[ Structure ] [ SQL ] [ Export ] [ Search ] [ Query ] [ Drop ]
I am in the [SQL] section and not the [Query] box which actually cannot be selected. I can only go in [Structure],[SQL] and [Drop]
All those steps
should already be done for you.
The commands like
mysql -u dba_user -paren't used at all if you have phpmyadmin. They are for the unix sysadmins who are starting with a blank server. Also theGRANT......should already be done for you.Ignore those steps
This is the step in INSTALL.mysql.txt you still need to do:
2. LOAD THE DRUPAL DATABASE SCHEMA
Once you have a database, you must load the required tables into it.
Depending on the version of MySQL you are using, you must use the
file 'database.4.0.mysql' (for MySQL 4.0 or lower) or
'database.4.1.mysql' (for MySQL 4.1 or higher). Both files are
located in Drupal's database directory.
If you use a web-based control panel, you should be able to upload
the appropriate file and run it directly as SQL commands.
But those unix commands at the bottom of the page aren't what you try to run. What you need to do is go to the [SQL] tab in phpmyadmin, and in the "Or Location of the text file:" section browse for either the
database/database.4.0.mysqlordatabase/database.4.1.mysqlfile depending on what version of MySQL you have.These .mysql files are part of the Drupal download in the database subdirectory. You may need to have a copy of the file locally on your PC to upload it into phpmyadmin.
--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
--
Anton
Hurray! Thanks to your info
Hurray! Thanks to your info and explanation, Styro, I did the following:
I went back to my phpmy admin interface.
I selected the [SQL] tab. I browsed in my "Drupal" folder, in "database" sub-folder, I found the following file: "database.4.1.mysql".
I selected it and click "ok" or "go" (I can not remember).
I instantly got the message:
"Your SQL-query has been executed successfully :
The content of your file has been inserted. (94 Instructions) "
So this is one more step done!
Next step, I believe,
Next step, I believe, now:
2. LOAD THE DRUPAL DATABASE SCHEMA
"Once you have a database, you must load the required tables into it.
Depending on the version of MySQL you are using, you must use the
file 'database.4.0.mysql' (for MySQL 4.0 or lower) or
'database.4.1.mysql' (for MySQL 4.1 or higher). Both files are
located in Drupal's database directory."
How do I "use" it ? I see in the drupal folder> database> two files:database.4.0.mysql and database.4.1.mysql.
There is also an other file called: "updates", which, once opened in Wordpad, shows some coding.
Also, I just noticed that in my Phpmyadmin, I got 57 "elements" loaded now!
* Browse access
* Browse accesslog
* Browse aggregator_category
* Browse aggregator_category_feed
* Browse aggregator_category_item
* Browse aggregator_feed
* Browse aggregator_item
* Browse authmap
* Browse blocks
* Browse book
* Browse boxes
* Browse cache
* Browse client
* Browse client_system
* Browse comments
* Browse contact
* Browse files
* Browse file_revisions
* Browse filters
* Browse filter_formats
* Browse flood
* Browse forum
* Browse history
* Browse locales_meta
* Browse locales_source
* Browse locales_target
* Browse menu
* Browse node
* Browse node_access
* Browse node_comment_statistics
* Browse node_counter
* Browse node_revisions
* Browse permission
* Browse poll
* Browse poll_choices
* Browse poll_votes
* Browse profile_fields
* Browse profile_values
* Browse role
* Browse search_dataset
* Browse search_index
* Browse search_total
* Browse sequences
* Browse sessions
* Browse system
* Browse term_data
* Browse term_hierarchy
* Browse term_node
* Browse term_relation
* Browse term_synonym
* Browse url_alias
* Browse users
* Browse users_roles
* Browse variable
* Browse vocabulary
* Browse vocabulary_node_types
* Browse watchdog
Slightly confused I think
You have done the loading schema step. Those elements are the tables in your database - and that is how it should look.
You've finished the database specific step - MySQL should now be properly configured.
Go back to the original instructions and follow along from where you left off: ie configuring the database connection string in your settings.php file.
--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
--
Anton
Is this this step: 3.
Is this this step: 3. CONNECTING DRUPAL ?
I thought I did it already... :(
A few days ago, I opened: Sites>default>settings.php with word pad. And only modified this line:
*/
$db_url = 'mysql://robocrowevo:xxxxxxxx@localhost/robocrowevo';
$db_prefix = '';
/**
(where x is my password)
The rest, I am not sure what I need to do. Explanations, examples and probably real lines of coding are all mixed together...
Thats it
You can connect to your site with your browser and go from there.
All the other steps are semi optional - the site will run without them, and you can go back to them later.
You might need to change permissions on your 'files' directory, but you can worry about that later. That won't stop Drupal working - it just means you won't be able to upload anything yet.
--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
--
Anton
Still not working...
Hi Styro,
After 4 days during which I had no time to work on this installation, I still have problems to have it to work.
My site is: www.robocrow.com
Inside, you can see two folders:
[DIR] Parent Directory 06-Sep-2006 08:37 -
[DIR] drupal-4.7.3/ 04-Sep-2006 21:44 -
[DIR] memo/
If i click on Drupal folder, I see the long following message:
"Unable to connect to database server
This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database server is down.
The MySQL error was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
Currently, the username is robocrowevo and the database server is localhost.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider."
I am sure i use the local username and password that i have written in my setting.php, located in my drupal folder on line.
About the hostname...i am not sure where i have to enter that. I know that at some point in my setting.php online, I enter this:
$db_url = 'mysql://robocrowevo:xxxxxxxx@localhost/robocrowevo';
$db_prefix = '';
(where x is my password)
I know my database server is running.
But when i read my index.php, I see this:
require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
$return = menu_execute_active_handler();
switch ($return) {
case MENU_NOT_FOUND:
drupal_not_found();
break;
case MENU_ACCESS_DENIED:
drupal_access_denied();
break;
case MENU_SITE_OFFLINE:
drupal_site_offline();
break;
default:
// Print any value (including an empty string) except NULL or undefined:
if (isset($return)) {
print theme('page', $return);
}
break;
}
drupal_page_footer();
So definitly, something is completely wrong.
Also, I found that: "Get
Also, I found that:
"Get Drupal ready for windows
1. Download Drupal
2. Extract Drupal to your desktop (or wherever you like on your computer). You need to have a program like 7-zip or Winzip installed first. You will have to extract the files twice.
3. Edit conf.php. It's in the drupal-4.5.2/includes directory after you extract the files. You have to edit two lines in this file.
4.
* To edit the file, you may need to load your text editor (Windows comes with Notepad and Wordpad, either of which will do fine) first then find the file by clicking the File menu, then Open.
5. Change: $db_url = "mysql://user:password@localhost/drupal";
* You must replace "user" and "password" with your username and password for your phpMyAdmin login and "drupal" with your database's name.
6. Change: $base_url = "http://www.example.com";
* You must replace "example.com" with your domain name.
7. Put drupal on your server. You need an FTP program like FileZilla.
* Open your FTP program and navigate to the directory where your index.htm file would normally go. This is usually called public_html/ or www/ This is where you put the drupal files. The drupal files that go there are the contents of drupal-4.5.2, that you extracted. You don't put the folder itself on the server, just the contents. That means you are uploading six folders (database, includes, etc.) and ten files (.htaaccess, cron.php, etc.).
8. Create a new directory on your server.
* In your FTP program, right click on the server side, select "create directory" and name the new directory "files." You want "files" in the main directory. After you create it, you should see it in between "database" and "includes."
9. Now you open up your new directory, "files," and create a new directory inside called, "tmp."
10. Change the file attributes of both "files" and "tmp" by right clicking on them one at a time, selecting "file attributes" and entering "755" in the "numeric value" field (if you see errors on your drupal site later saying "files" and "tmp" are not writeable you have to change the file attributes to "777," which is less secure)."
Realizing I did not upload the files as it should have been in the www, i tried to erase the folder drupal serverside, i could not, so i simply renamed it, and manage to erase some of its content. Then I followed exactly the procedure descriebed above.
It still does not connect, but at least i am not sure everything is there as it should be.
In:
In:
$db_url = 'mysql://robocrowevo:xxxxxxxx@localhost/robocrowevo';
$db_prefix = '';
I replaced the word 'localhost' by 'sql' as advised: my database is on a different server.
I still do not connect.
Wrong version.
This is for setting up a Drupal 4.5 - unless you are working from Wayback... we are now on drupal 4.7.3 Make sure you are using an up to date version of drupal.
And good idea, trying to start over. If you ae trying to work with an outdated version of drupal I recommend clearing things out and starting fresh. Especially if you aren't very far along.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
OK
A) I went to your URL an the problem is that drupal isn't connecting to the database properly. This has everything to do with this line in your settings.php
$db_url = 'mysql://robocrowevo:xxxxxxxx@localhost/robocrowevo';Go back and double check the username, password. AND check that your hosting uses localhost. I was on a shared server once that (once I dug through their FAQ) I found used mysql23 as the hostname, because they kept their databases on a seperate box. Yours WILL NOT be that (unless their is a really big coincidence in the world) but double check with your hosting company about it.
B) NEVER need to touch index.php It does what it needs to.
Post back with any updates. Good Luck.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
Hi Sam,
Hi Sam&Tresler,
Thanks for reading.
I am using the latest version of Drupal-4.7.3
I am sure they do not use localhost. Indeed, my provider,OVH, uses two boxes. One for the site, one for the database. I have been advised by a forum helper in their community to replace 'localhost' by 'sql'.
About the user id, and pw, they are correct, i pasted them from the email i received from OVH. And they are the one I use to connect my database with phpmyadmin.
When I navigate to your site
When I navigate to your site I still get this:
Currently, the username is robocrowevo and the database server is localhost.if you had set this line:
$db_url = 'mysql://robocrowevo:xxxxxxxx@localhost/robocrowevo';to this:
$db_url = 'mysql://robocrowevo:xxxxxxxx@sql/robocrowevo';even if it is the wrong database server I would be seeing this:
Currently, the username is robocrowevo and the database server is sql.if its the correct database server, you will be propmted to create your first account.
Now, we are taking your hosting companies word that 'sql' is the proper entry, so what happens when you hook that up in your settings.php?
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
Should I try to recreate my
Should I try to recreate my database. To erase it (I am not sure how with phpmyadmin) and to recreate it by loading the drupal file into it like i did the first time?
Not yet...
Sorry if I'm asking you to redo certain steps, just want to make we are on the same page. If the database has the 57 tables you mentioned, you should be fine.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
The OVH guy in the hosting
The OVH guy in the hosting community forum just told me that sometimes, there is a latency when you update their server V2 where I have installed Drupal. My database 'Robocrowevo' is on their server V3. Therefore, I confirm there are two boxes
One question: How big is the drupal database with its 57 first elements ?
Well
The database is just the initial tables without any susbstantial amount of data yet.... I don't rightly know but it is tiny. Why do you ask?
So because you're database is on a different box, you need to discover what the database server name is instead of localhost. Then sub that in instead of localhost.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
Hi Tresler,
Hi Tresler,
I asked because when I go to the server V where by database is stored, it says there is one, but it also says its empty. I asked the OVH guy, he told me that if its tiny (and you confirmed it is), then it will show "size:empty"
I have been advised by OVH to put 'sql' instead of 'localhost'. And still nothing. I believe this is not Drupal's fault but my host fault now. Maybe there are indeed a big latency on this v2 serveur where Drupal is loaded...I even deleted the settings.php serverside, before reloading it, but it does not seem to change what is written on the index page.
Lets wait 12 hours, and I'll report back here of course.
Thats ludicrous
If you need to wait up to 12 hours for any database change to take effect then you are going to have some severe issues down the line. Databases changes through phpmyadmin pretty much should be immediate.
FTP is immediate - once the file is on the server, in the correct place, it is there.
I just double checked on one of my sites. As soon as the settings.php file is in the sites/default directory it should show 'sql' instead of 'localhost' when you browse to your URL. Perhaps make sure the settings.php is in the proper directory and that you don't have duplicate copy of drupal somehow on your server.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
I tried the same but with
I tried the same but with the index.php file. I removed it server side, and obtained a different non-drupal error. I put it back and got the drupal error again.
I have uploaded my settings.php in the same folder 'www' where I have uploaded all the drupal folders. So I beleive these files are at the correct place, server side. I use Filezilla, and doublechecked with dreamweaver.Everything is where it should be and when calling the file online, the settings.php is correctly set up.
So I dont know what is going on with OVH... This is becoming weird, anyway.
settings.php doesn't go there
when you uploaded the drupal package there should have been a directory in it that is called 'sites'
Inside 'sites' there should be a directory called 'default' put the settings.php file in 'default (I'm almost certain you will need to overwrite one that is currently there, which I'm sure still contains your localhost values. Thats why 'localhost' won't go away for you).
Drupal only knows to look for settings.php in folders in the sites directory. Once you upload your settings.php (with the sql instead of localhost) into the proper directory, I think you should be good to go.
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/
Tresler, Can i call you GOD
Tresler,
Can i call you GOD ? (please, just for tonight.)
Its working!
http://www.robocrow.com/
Congratulations!
Glad to see this. Now you can actually begin. LOL
Sam Tresler
http://www.treslerdesigns.com
-------------------------------------------
Sam Tresler
http://www.cndp-llc.com/