Re: [Phpgroupware-users] root

[Ralf Becker]

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