Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Permissions on import Tables

Oct 26, 2000, 9:27 AM
mdj1
Enthusiast (628 posts)
Oct 26, 2000, 9:27 AM
Post #1 of 7
Views: 3273
Shortcut
Quote Reply
Permissions on import Tables
Hi All,

I know you stated that the setup had now arranged the permissions correctly now, but ijm getting the following on trying to import table info and re-sync.

Code:
Setup: SQL Server Settings

SQL Server Settings
Results:

Users .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Users.def'. Reason: Permission denied
Links .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Links.def'. Reason: Permission denied
Category .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Category.def'. Reason: Permission denied
CatLinks .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/CatLinks.def'. Reason: Permission denied
CatRelations .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/CatRelations.def'. Reason: Permission denied
Sessions .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Sessions.def'. Reason: Permission denied
Editors .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Editors.def'. Reason: Permission denied
Verify .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/Verify.def'. Reason: Permission denied
EmailTemplates .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/EmailTemplates.def'. Reason: Permission denied
EmailMailings .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/EmailMailings.def'. Reason: Permission denied
MailingIndex .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/MailingIndex.def'. Reason: Permission denied
MailingList .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/MailingList.def'. Reason: Permission denied
MailingListIndex .. failed: Can not open file '/home/think35/cgi-bin/admin/defs/MailingListIndex.def'. Reason: Permission denied
Click_Track .. failed: Failed to execute query: 'DESCRIBE Click_Track' Reason: Table 'links.Click_Track' doesn't exist
Just to let you know



Regards

MDJ1
http://www.isee-multimedia.co.uk
Oct 26, 2000, 10:28 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Oct 26, 2000, 10:28 AM
Post #2 of 7
Views: 3217
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
Make sure that the defs directory is set to 777 (drwxrwxrx) and that the def files are set to 666 (rw-rw-rw-).

Regards,

Eliot Lee
Oct 26, 2000, 10:36 AM
mdj1
Enthusiast (628 posts)
Oct 26, 2000, 10:36 AM
Post #3 of 7
Views: 3226
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
The Defs directory is 777, but the files have been set to 755 by the script is this to high for them to run?



Regards

MDJ1
http://www.isee-multimedia.co.uk
Oct 26, 2000, 10:41 AM
Alex
Administrator (9387 posts)
Oct 26, 2000, 10:41 AM
Post #4 of 7
Views: 3203
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
Are the files owned by you or the script? Since the setup is done from the web, I would assume it's the web server who owns them. Also, the resync is done from the web too, so I'm a little confused. Can you show a ls -al of that directory..

Cheers,

Alex

--
Gossamer Threads Inc.
Oct 26, 2000, 10:56 AM
mdj1
Enthusiast (628 posts)
Oct 26, 2000, 10:56 AM
Post #5 of 7
Views: 3223
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
Here it is

Code:
drwxrwxrwx 2 think35 think35 4096 Oct 26 17:00 .
drwxr-xr-x 12 think35 think35 4096 Oct 26 16:58 ..
-rwxr-xr-x 1 think35 think35 889 Oct 25 04:19 CatLinks.def
-rwxr-xr-x 1 think35 think35 826 Oct 25 04:19 CatRelations.def
-rwxr-xr-x 1 think35 think35 3594 Oct 25 04:19 Category.def
-rw-r--r-- 1 nobody nobody 1148 Oct 26 17:00 Category_Score_List.def
-rw-r--r-- 1 nobody nobody 926 Oct 26 17:00 Category_Word_List.def
-rwxr-xr-x 1 think35 think35 1118 Oct 25 04:19 ClickTrack.def
-rwxr-xr-x 1 think35 think35 888 Oct 25 04:19 Editors.def
-rwxr-xr-x 1 think35 think35 1081 Oct 25 04:19 EmailMailings.def
-rwxr-xr-x 1 think35 think35 1541 Oct 25 04:19 EmailTemplates.def
-rwxr-xr-x 1 think35 think35 4753 Oct 25 04:19 Links.def
-rw-r--r-- 1 nobody nobody 1148 Oct 26 17:00 Links_Score_List.def
-rw-r--r-- 1 nobody nobody 926 Oct 26 17:00 Links_Word_List.def
-rwxr-xr-x 1 think35 think35 1600 Oct 25 04:19 MailingIndex.def
-rwxr-xr-x 1 think35 think35 594 Oct 25 04:19 MailingList.def
-rwxr-xr-x 1 think35 think35 1029 Oct 25 04:19 MailingListIndex.def
-rwxr-xr-x 1 think35 think35 1056 Oct 25 04:19 SearchLog.def
-rwxr-xr-x 1 think35 think35 1141 Oct 25 04:19 Sessions.def
-rwxr-xr-x 1 think35 think35 2630 Oct 25 04:19 Users.def
-rwxr-xr-x 1 think35 think35 910 Oct 25 04:19 Verify.def
-rw-r--r-- 1 think35 think35 9033 Oct 25 04:19 WS_FTP.LOG
-rw-r--r-- 1 nobody nobody 218 Oct 26 17:27 database.def
Hope this helps


Regards

MDJ1
http://www.isee-multimedia.co.uk
Oct 26, 2000, 10:58 AM
Alex
Administrator (9387 posts)
Oct 26, 2000, 10:58 AM
Post #6 of 7
Views: 3228
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
Very strange. Did you copy over your def files manually? I'm not sure why else you'd have a mix of files owned by web server and your user (and a WS_FTP.log file, hmmmm... ).

To fix, erase all the def files, and go to Setup->SQL Server->Create New Tables.

Cheers,

Alex

--
Gossamer Threads Inc.
Oct 26, 2000, 11:18 AM
mdj1
Enthusiast (628 posts)
Oct 26, 2000, 11:18 AM
Post #7 of 7
Views: 3212
Shortcut
Quote Reply
Re: Permissions on import Tables In reply to
Hi Alex,

The original Alpha5 install i made manually,, when i updated it must have kept the same permissions.

I have now done what you said and all seems to be OK

Thanks for your help.



Regards

MDJ1
http://www.isee-multimedia.co.uk