Forum for users of JoomlaWatch / ExtraWatch for Joomla, Wordpress, Drupal, Magento, Prestashop

JoomlaWatch / ExtraWatch has following features: live real-time visitor statistics, location of your visitors on a map, blocking of users based on bad word list, front-end counters, click heat map, definition of goals and rules, graphs, directory size monitoring, monitoring of increase of database data in time, nightly email reports, interactive HTML5 chart of traffic flow within your website, SEO report with keyword statistics and keyword position trends

Welcome, Guest
Please Login or Register.    Lost Password?

Where are the logs kept?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Where are the logs kept?
#435
Where are the logs kept? 8 Years, 7 Months ago Karma: 0
I have looked all over this site with no answer :\

where in the world are logs kept? are there logs kept? or is this only live?

I am not always on my computer so it would be nice to look back on logs if anything went down, any suggestions?
thedroop (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#436
Re:Where are the logs kept? 8 Years, 7 Months ago Karma: 31
They are kept in the database. Increasing the number of columns to keep in database would affect the live performance because of the table joins.

But, you can try to increase the values of these parameters:

define('JOOMLAWATCH_MAXID_BOTS',10);
define('JOOMLAWATCH_MAXID_VISITORS',15);


Cheers,

Matto
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#437
Re:Where are the logs kept? 8 Years, 7 Months ago Karma: 0
Dang, thanks for the swift reply

I am a newb

does that mean I would find them in me MYSQL database page? or can I access this via by ftp?

If you could guide me in the correct direction, it would be much appreciated
thedroop (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#438
Re:Where are the logs kept? 8 Years, 7 Months ago Karma: 0
I logged into my MYSQL panel

and I see these

# Browse jos_joomlawatch_helper
# Browse jos_joomlawatch_info
# Browse jos_joomlawatch_ip2c
# Browse jos_joomlawatch_uri

I looked everywhere in there but I do not really see a database to access? I am kinda new at this

Thank you so much for the help btw
thedroop (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#439
Re:Where are the logs kept? 8 Years, 7 Months ago Karma: 0
allright I think I found it?

I look in jos_joomlawatch_ip2c

But it shows odd stuff like-

start end a2 a3 country
50331648 69956103 US USA UNITED STATES

- Is that the right place? there are 3 other joomlawatch things

but I don't really see any logs of ips like I do on the live page
thedroop (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#440
Re:Where are the logs kept? 8 Years, 7 Months ago Karma: 31
It's simply in jos_joomlawatch, man!

there is a record for every visit.

And, to avoid duplicity, in jos_joomlawatch_uri there are records which pages has the particular user visited.

so, if you have to join these tables like this:

SELECT * FROM jos_joomlawatch LEFT JOIN jos_joomlawatch_uri ON jos_joomlawatch.id = jos_joomlawatch_uri.fk ORDER BY jos_joomlawatch_uri.timestamp desc
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#542
Re:Where are the logs kept? 8 Years, 6 Months ago Karma: 0
Do the large databases slow down the site?
hunchermuncher (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1

Latest News

Get the latest freelance project announcements
Follow CodeGravity.com

Download ExtraWatch™

ExtraWatch™ FREE is Joomla, Wordpress, Prestashop, Magento plugin with following features: Live Stats, Nightly Email Reports, Goals, Graphs, Anti-spam, History and more