[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-internals
Subject:    Re: [PHP] Counter problem, MSQLLOG script help, NEW dblog script
From:       Matthew Tebbens <matthew () tebbens ! idsi ! net>
Date:       1997-10-30 17:58:53
[Download RAW message or body]


This is great !

Thanks!
Matthew


On Thu, 30 Oct 1997, Frank Schulte wrote:

> Hi Matthew,
> 
> I attach my new dblog script i have taken time too today. I needed it
> myself so enjoy it yourself. It runs with msql 1.x, msql 2.x and mysql all
> versions 3.x.
> 
> Save the script and
> 
> 	chmod u+x,g+x ./dblog
> 
> You can set up the DB_ variables in the script so you don't have to put all
> in the comandline.
> 
> You can do:
> 
> ./dblog username create		# creates access db tables for user "username"
> ./dblog username drop		# drops access db tables for user "username"
> 
> I hope this solves your problem.
> 
> Girls and guys out there, if any bug found, please give me an email to
> fschulte@hightek.com.
> 
> Best regards
> Frank Schulte
> 
> PS: PHP3 developers, if you like this put it in the distribution of PHP2
> and PHP3.
> 
> >I found the problem, now I just need to fix it.
> >The following is part of the msqllog script and outdated since mSQL2.
> >How would I change this to work with mSQL2 ?
> >
> >CREATE TABLE last$UUID (
> >	filename	CHAR(64) NOT NULL PRIMARY KEY,
> >	timestamp	INT,
> >	total		INT,
> >	today		INT,
> >	stimestamp	INT,
> >	host		CHAR(64),
> >	email		CHAR(64),
> >	lref		CHAR(64),
> >	browser		CHAR(64)
> >)\g
> >
> >
> >Thanks,
> >Matthew
> >
> >
> >
> >On Wed, 29 Oct 1997, Matthew Tebbens wrote:
> >
> >>
> >> I see something wrong !
> >> I don't have a 'last1000' database.
> >>
> >> I'm suppose to have one for each user right ?
> >> The msqllog script didn't create it....hmmmm
> >>
> >> Matthew
> >>
> >>
> >>
> >> On Wed, 29 Oct 1997, Frank Schulte wrote:
> >>
> >> > Hi Matthew,
> >> >
> >> > use
> >> > 	cat /etc/passwd | grep matthew | cut -d: -f3
> >> >
> >> > 	If you have permission to read /etc/passwd
> >> > or
> >> > 	id matthew
> >> > .
> >> >
> >> > This gives you the numerical user id (uid) of user matthew
> >> >
> >> > cd ${MSQLHOME}/bin
> >> > ./relshow phpfi | grep uid
> >> >
> >> > gives you
> >> >
> >> > | log1000          |
> >> > | last1000         |
> >> >
> >> > if your is uid=1000 (hopefully).
> >> >
> >> > Look at the r/w permissions. Can the user id under which apache is running
> >> > read your files ? Give your files read permission for the apache user
> >>if it
> >> > is not root.
> >> >
> >> > Hope this helps !!
> >> >
> >> > Best regards
> >> > Frank Schulte
> >> >
> >> > >On Tue, 28 Oct 1997, Frank Schulte wrote:
> >> > >
> >> > >> Hi Matthew,
> >> > >>
> >> > >> look at the owner of the files you want to log hits from.
> >> > >
> >> > >ok, me. (matthew)
> >> > >
> >> > >>
> >> > >> The primer mistake is false owner of the files !!!
> >> > >
> >> > >False owner ?
> >> > >
> >> > >>
> >> > >> Lookup if you have a log table for the file owner actuely.
> >> > >
> >> > >The uid/gid is matthew.matthew, but its logged by PHPFI under logs
> >> > >called 'log1000.' But thats what msqllog does automatically when you run
> >> > >it for the first time to create a table for a user.
> >> > >Instead of log1000 is it suppose to be matthew ??
> >> > >
> >> > >Thanks,
> >> > >Matthew
> >> > >
> >> > >>
> >> > >> Best regards
> >> > >> Frank Schulte
> >> > >>
> >> > >> >I'm running Apache-1.2.4 PHP/FI-2.0b12(apache module) & mSQL
> >> > >> >
> >> > >> >The counter half works, it will log data to mSQL ok but the
> >>counter just
> >> > >> >does not update, I've tried everything. And yes I did add a table
> >>to the
> >> > >> >phpfi database for each user.... I can see it logging to the
> >>tables but
> >> > >> >for some reason PHP/FI is not getting the hit counts...
> >> > >> >
> >> > >> >Is this a known problem, is there a fix or solution ??
> >> > >> >
> >> > >> >Thanks,
> >> > >> >Matthew
> 
> 


______________________________PHP/FI Mailing List______________________________
To unsubscribe send an empty message to php-list-unsubscribe@php.iquest.net
To unsub you@host.com, use: php-list-unsubscribe-you=host.com@php.iquest.net
For help: php-list-help@php.iquest.net  Archive: http://www.tryc.on.ca/php.html

[prev in list] [next in list] [prev in thread] [next in thread]