By richard247 on

drupal-4.6.5

Searching high and low for a chmod guide without success ...

1. What permissions should be set for a) folders b) files

2. settings.php
Q: Is our line 81 correct ?
$db_url = 'mysql:// our user name : our password @localhost/database';

3. database.mysql.inc
Q: Should lines 31 and 32 be adjusted ?
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
mysql_select_db(substr($url['path'], 1), $connection) or die('unable to select database');

4. In what file do we tell the system what is the database name we have allocated.

Your intervention will be very welcome and *thank you* from Richard Robinson

⋅ Categories: Drupal 4.6.x

Comments

jjeff’s picture

jjeff commented

Hi Richard,

I think that all this is explained in the INSTALL.txt file in your main Drupal directory.

You can read it online here:
http://cvs.drupal.org/viewcvs/*checkout*/drupal/drupal/INSTALL.txt?rev=1.17.2.3

--= Jeff Robbins | www.lullabot.com =--

sym’s picture

sym commented

there is nothing about chmod there...

pwolanin’s picture

pwolanin commented

I'm new to this as well, but I found the following pages helpful in starting to work with the permissions:


http://drupal.org/node/39887


http://drupal.org/node/26635

---
Work: BioRAFT

mikeshanklin’s picture

mikeshanklin commented

I can't get filezilla to change the permission... it keeps coming back with...

CHMOD 755 default': command not understood

I contacted godaddy and they said it was a drupal issue. Any help ending this error message would be appreciated!

Configuration file Not protected
The directory sites/default is not protected from modifications and poses a security risk. You must change the directory's permissions to be non-writable. The file sites/default/settings.php is not protected from modifications and poses a security risk. You must change the file's permissions to be non-writable.
Cron maintenance tasks Never run
Cron has not run. For more information, see the online handbook entry for configuring cron jobs. You can run cron manually.

richard247’s picture

richard247 commented

Thank you sym.

There is no default chmod guide/permissions overview and ae2005's remark "... permissions need to be changed BACK after an install" is another issue I have to look into.

Will report back.

sanduhrs’s picture

sanduhrs
he/him
Primary language German
Location 🇪🇺 Heidelberg, Germany, Europe
commented

1. What permissions should be set for a) folders b) files

That depends on your systems settings.
Uploading the files via FTP should do it well, given your sysadmin is well educated ;)

2. settings.php
Q: Is our line 81 correct ?
$db_url = 'mysql:// our user name : our password @localhost/database';

No, unless your database is called "database", it is not correct.
It should read something like:
$db_url = 'mysql:// our user name : our password @localhost/YOURDATABASE';

3. database.mysql.inc
Q: Should lines 31 and 32 be adjusted ?
$connection = mysql_connect($url['host'], $url['user'], $url['pass'], TRUE) or die(mysql_error());
mysql_select_db(substr($url['path'], 1), $connection) or die('unable to select database');

No, nothing has to be changed here.

4. In what file do we tell the system what is the database name we have allocated.

You did that already in settings.php (see point 2.)

richard247’s picture

richard247 commented

Thank you sanduhrs.

Actual content/realnames is shown below.

a) line 81
b) yield

a) $db_url = 'mysql://richard:48zcx2kP@localhost/dupal1';
b) Fatal error: Table 'dupal1.users' doesn't exist query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'ea760c12560bec43a5d13cd52cb7bb5b' AND u.status < 3 LIMIT 0, 1 in /var/www/vhosts/domainname/httpdocs/le/includes/database.mysql.inc on line 66

1. We run appropriate MySQL and PHP (rackspace/plesk)
2. Permissions are set to 777 throughout.

I will visit database.mysql.inc and report progress.

heine’s picture

heine commented

Did you create database tables by executing the queries in database/database.mysql?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

sanduhrs’s picture

sanduhrs
he/him
Primary language German
Location 🇪🇺 Heidelberg, Germany, Europe
commented

a) looking good, expect for $db_url = 'mysql://richard:48zcx2kP@localhost/dupal1';
Perhaps you meant $db_url = 'mysql://richard:48zcx2kP@localhost/drupal1'; ?
If not, did you import the sql file ?

1. Should run whithout any Problems with Plesk.
2. Please consider a more secure setup than chmod 777
with Plesk normal setup it should work with chmod 644 on files and chmod 755 on folders. Perhaps there are even bether settings.
The only folder nedding chmod 777 is the /files folder.
vg

richard247’s picture

richard247 commented

Thank you sanduhrs

"did you import the sql file ?"
All files are FTP uploaded; 'dupal1' was my syntax error

"consider a more secure setup than chmod 777"
Thank you, have effected /file folder/folders/files to /777/755/644

"Should run whithout any Problems with Plesk"
The error yield remains the same.

My temporary solution is to uninstall the DBs and files and re-install everything and I will report back.

Richard says thank you for your input.

heine’s picture

heine commented

The file database/database.mysql contains queries that need to be executed in order to create a proper database layout. One of those tables is 'users'; the error message you get indicates that you do have a database connection but that the table is missing.

Since you're using Plesk you most likely also have access to phpmyadmin. From Create Drupal database using Plesk:

Load the Drupal database scheme
From the database users overview page [Plesk] click DB WebAdmin. Tthe icon is a blue stack with a monkey wrench. Note that this opens phpmyadmin in a pop-up that may be blocked by your browser.

First make sure the relevant database is selected. If necessary, click Databases in the phpmyadmin start screen and then the database name.

Go to the SQL screen via a small button labelled SQL in the left pane of the phpmyadmin screen. Alternatively, select the tab import files. Upload the file database/database.mysql with the database scheme.

If your version of phpmyadmin (or your provider) doesn't let you upload files with sql commands, open database/database.mysql locally with a text editor (eg Notepad, vi) and copy-paste its contents into the SQL query textarea. Click go.

Good luck.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

richard247’s picture

richard247 commented

Thank you Heine

Result at the URL: "Welcome to your new Drupal-powered website. This message will guide ..." etc.

The solution lay in this remark, above "open database/database.mysql locally and copy-paste its contents into the SQL query textarea"

Whilst it has produced functionality, I remain uncertain why it functions using the remote plesk device.

Ho hum,

As more unfolds I will report back and meanwhile I will keep this ticket open.

richard247’s picture

richard247 commented

...

kae’s picture

kae commented

we need a book in the handbook page that says what permissions need to be changed BACK after an install.

richard247’s picture

richard247 commented

In closing this thread, many thanks go to ..

sanduhrs for very quick pointers to $db_url = 'mysql:// our user name : our password @localhost/ etc...

And many thanks go to Heine for directing us to plesk management.

Compliments from Richard Robinson
Lincolnshire
England

kae’s picture

kae commented

hey wait, before you close this. what about permissions that need to be changed back? i believe there are three or more.
(at least there have been when i install civicspace.) they looked like the same folders as in drupal.

which folders need to have their permissions changed back after an install?
instead of leaving files open to break-ins, can i change files to 644 if i don't permit uploads or theme edits?

galgoz’s picture

galgoz commented

I to need to know this. I am having an issue where when I upload content using drupal or drupal creates a file or folder the owner of the file is httpd and I can not chmod anything then. My host provider says that I need to chmod all files and folders that are used to create this content to 777 so that they are created with the correct ownership. This seems wrong to me. I don't know which files and folders are needed to be changed so I am going to change everything except the config.php files to 777 and would like to know which ones really need to be if any.