phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-users] root


From: Ralf Becker
Subject: Re: [Phpgroupware-users] root
Date: Sun, 10 Aug 2003 17:12:15 +0200
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030626

The Emilsons wrote:
Sorry, thought I mentioned that I accident cleared all tables , and we

If you cleared all tables, just reinstall via setup. Theres nothing to loose then.

have no ssh, I can  get it, but my provider will only offer temporary,
is there an sql table someone can send me?

Viking NetWerkz
Unix Web Hosting and Design Services
Viking NetWerkz Your Next Site!
http://www.vikingnetwerkz.com


-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Ralf Becker
Sent: August 10, 2003 4:45 AM
To: address@hidden
Subject: Re: [Phpgroupware-users] root

It must be something else then. Deleting all rows, but the first two, gives you a clean "new" vfs-table.

The only thing I can offer you now, is to log into your box and check it. If you want to proceed this way, create a user-account to which I'm able to login via ssh and mail me the details (*privat* mail not the list) or meet me on irc://irc.freenode.net/phpgroupware

Ralf

The Emilsons wrote:

Aye, and I still get the error, where can I find the sql for the
phpgw_vfs table or how best to insert with a drop table?

Thnx, for your input and guidance on this Ralf



Viking NetWerkz
Unix Web Hosting and Design Services
Viking NetWerkz Your Next Site!
http://www.vikingnetwerkz.com


-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Ralf Becker
Sent: August 9, 2003 12:39 PM
To: address@hidden
Subject: Re: [Phpgroupware-users] root

It seems your vfs-install is out of sync with the filesystem, I would suggest the following: 1) remove from the phpgw_vfs table all entries but the first 2, eg: delete from phpgw_vfs where file_id > 2
2) remove all files/dir in /home/viking/files beside the home-dir

That should fix your prob.

Ralf

The Emilsons wrote:


Yes I see that now, I fixed that, you are correct, an oversite.
So I fixed that, then I checked permissions, and still the same

result,


then I changed permissions to 777. and I received this new error one
which says file exists but its not and and then I was halted wit this:

Warning: mkdir(/home/viking/files/infolog): File exists in
/home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
1783
vfs_sql.mkdir('/infolog','Array'), cant
mkdir('/home/viking/files/infolog')


Warning: mkdir(/home/viking/files/infolog/1): File exists in
/home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
1783
vfs_sql.mkdir('/infolog/1','Array'), cant
mkdir('/home/viking/files/infolog/1')

Database error: Invalid SQL: UPDATE phpgw_vfs SET WHERE file_id='3'

AND


((mime_type != 'journal' AND mime_type != 'journal-deleted') OR
mime_type IS NULL)
MySQL Error: 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 'WHERE file_id='3' AND ((mime_type != 'journal' AND
mime_type !=)

File: /home/viking/public_html/office/infolog/inc/class.vfs.inc.php
Line: 1969
Session halted.



Regards, and thank you for your continuing efforts


Viking NetWerkz
Unix Web Hosting and Design Services
Viking NetWerkz Your Next Site!
http://www.vikingnetwerkz.com


-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Ralf Becker
Sent: August 9, 2003 5:32 AM
To: address@hidden
Subject: Re: [Phpgroupware-users] root

Hi,

The Emilsons wrote:



My www directory is home/viking/public_html/
My server directory is home/viking/


Why do you omit the / in fron or /home/viking is that not an absolut
path?




I have tried creating manually these folders in server as you stated,
700 permiss on apache, and  the phpwebhosting still cannot created a
directory

And in info log I get these errors above althoul I can log I am

unable

to attach a file
Warning: mkdir(home/viking/files/infolog): No such file or directory

in



/home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
1783
vfs_sql.mkdir('/infolog','Array'), cant
mkdir('home/viking/files/infolog')


That message means there is no /home/viking/files dir.

Are you shure you created it / can you check its there and read-/writeable by the webserver?

Ralf




Warning: mkdir(home/viking/files/infolog/1): No such file or

directory

in /home/viking/public_html/office/infolog/inc/class.vfs.inc.php on

line



1783
vfs_sql.mkdir('/infolog/1','Array'), cant
mkdir('home/viking/files/infolog/1')


Warning: copy(home/viking/files/infolog/1/New Text Document.txt):

failed



to open stream: No such file or directory in
/home/viking/public_html/office/infolog/inc/class.vfs.inc.php on line
1376


Does this help, or have I broken the piped again :)
Viking NetWerkz
Unix Web Hosting and Design Services
Viking NetWerkz Your Next Site!
http://www.vikingnetwerkz.com


-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Ralf Becker
Sent: August 8, 2003 11:14 AM
To: address@hidden
Subject: Re: [Phpgroupware-users] root

Do I understand you right:
1) Docroot: /home/viking/public_html/office
2) URL:     http://office.mysite.com

Files dir could be: /home/viking/files
It should be owned by the webserver and have 700 permissions only accessible by the webserver. Your webserver-user depends on your

distro


(SuSE: wwwrun, RH: apache, ...)

You need to create the home-dir manualy /home/viking/files/home,

InfoLog



will create it's subdir automaticaly.

Ralf

The Emilsons wrote:




Can someone tell me the difference between server root and include

root?




Trying to use both infolog and phpwebhosting?
I have attempted to create files/folders for both these apps and

have

failed miserably.

I have followed all emails to this topic, and I understand to make
outside of document for files, but for the life of me I cannot get

this




app to work, I am ready to give up.

I am running the latest vers. I have done home/viking/public_html/office
I have done
/office

I have checked permissions for 777
I even manually created folders

The only thing I do differently than what Ive read so far from you

all


is that 1:I am on a virtual host
2: the phpgroupware is in a subdomain   http://office.mysite.com/

please I am not sure what other info you need to help me resolve

this,


if this isn't enough info, please advise as such





--
----------------------------------------------------------------------
Ralf Becker
digital ROCK, Becker & Macht GbR            Telefon +49 (631) 31657-51
Leibnizstra├če 17                            Telefax +49 (631) 31657-52
D-67663 Kaiserslautern                 EMail address@hidden





reply via email to

[Prev in Thread] Current Thread [Next in Thread]