Tera-WURFL 2.1.5 Administration
Loaded WURFL: db.scientiamobile.com - 2011-09-13 00:00:01


<< Back to main page

Database Table Statistics
MERGE
TeraWurflMerge		 Rows: 15114
Actual Devices: 7059
Table Size: 8.64 MB
Purpose:
The MERGE table holds all the data from the WURFL file, whether it be local, remote or remote CVS, whenever a new WURFL is loaded, it is loaded into this table first, then it is filtered through all the UserAgentMatchers and split into many different tables specific to each matching technique. This MERGE table is retained for a last chance lookup if the UserAgentMatchers and INDEX table are unable to provide a conclusive match.
INDEX
TeraWurflIndex		 Rows: 15114
Table Size: 411.78 KB
Purpose:
The INDEX table acts as a lookup table for WURFL IDs and their respective UserAgentMatchers.
CACHE
TeraWurflCache		 Rows: 0
Table Size: 0 B
Purpose:
The CACHE table stores unique user agents and the complete capabilities and device root that were determined when the device was first identified. Unlike version 1.x, the CACHE table stores every device that is detected permanently. When the device database is updated, the cached devices are also redetected and recached. This behavior is configurable.
User Agent Matchers
Purpose:
The User Agent Matchers store similar user agents. Tera-WURFL sorts all the devices into the most appropriate UserAgentMatcher table to make lookups faster and perform different matching hueristics on certain groups of devices.
UserAgentMatcher: TeraWurfl_AOL
Rows: 0
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Alcatel
Rows: 158
Table Size: 139.33 KB
UserAgentMatcher: TeraWurfl_Android
Rows: 1039
Table Size: 384.93 KB
UserAgentMatcher: TeraWurfl_Apple
Rows: 152
Table Size: 13.66 KB
UserAgentMatcher: TeraWurfl_BenQ
Rows: 83
Table Size: 41.70 KB
UserAgentMatcher: TeraWurfl_BlackBerry
Rows: 383
Table Size: 148.72 KB
UserAgentMatcher: TeraWurfl_Bot
Rows: 22
Table Size: 0 B
UserAgentMatcher: TeraWurfl_CatchAll
Rows: 3084
Table Size: 1.60 MB
UserAgentMatcher: TeraWurfl_CatchAll_TEMP
Rows: 0
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Chrome
Rows: 4
Table Size: 0 B
UserAgentMatcher: TeraWurfl_DoCoMo
Rows: 438
Table Size: 218.86 KB
UserAgentMatcher: TeraWurfl_Ericsson
Rows: 39
Table Size: 14.32 KB
UserAgentMatcher: TeraWurfl_Firefox
Rows: 6
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Grundig
Rows: 6
Table Size: 3.80 KB
UserAgentMatcher: TeraWurfl_Grunding
Rows: 6
Table Size: 3.73 KB
UserAgentMatcher: TeraWurfl_HTC
Rows: 326
Table Size: 196.82 KB
UserAgentMatcher: TeraWurfl_Kddi
Rows: 407
Table Size: 253.83 KB
UserAgentMatcher: TeraWurfl_Konqueror
Rows: 4
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Kyocera
Rows: 87
Table Size: 37.87 KB
UserAgentMatcher: TeraWurfl_LG
Rows: 1014
Table Size: 907.54 KB
UserAgentMatcher: TeraWurfl_MSIE
Rows: 8
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Mitsubishi
Rows: 39
Table Size: 8.23 KB
UserAgentMatcher: TeraWurfl_Motorola
Rows: 1182
Table Size: 611.73 KB
UserAgentMatcher: TeraWurfl_Nec
Rows: 90
Table Size: 46.61 KB
UserAgentMatcher: TeraWurfl_Nintendo
Rows: 5
Table Size: 1.98 KB
UserAgentMatcher: TeraWurfl_Nokia
Rows: 1788
Table Size: 731.66 KB
UserAgentMatcher: TeraWurfl_Opera
Rows: 20
Table Size: 8.37 KB
UserAgentMatcher: TeraWurfl_OperaMini
Rows: 51
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Panasonic
Rows: 86
Table Size: 66.71 KB
UserAgentMatcher: TeraWurfl_Pantech
Rows: 113
Table Size: 118.43 KB
UserAgentMatcher: TeraWurfl_Philips
Rows: 130
Table Size: 73.81 KB
UserAgentMatcher: TeraWurfl_Portalmmm
Rows: 251
Table Size: 96.02 KB
UserAgentMatcher: TeraWurfl_Qtek
Rows: 14
Table Size: 6.17 KB
UserAgentMatcher: TeraWurfl_SPV
Rows: 81
Table Size: 24.96 KB
UserAgentMatcher: TeraWurfl_Safari
Rows: 25
Table Size: 11.86 KB
UserAgentMatcher: TeraWurfl_Sagem
Rows: 259
Table Size: 148.09 KB
UserAgentMatcher: TeraWurfl_Samsung
Rows: 1886
Table Size: 1.59 MB
UserAgentMatcher: TeraWurfl_Sanyo
Rows: 91
Table Size: 75.49 KB
UserAgentMatcher: TeraWurfl_Sendo
Rows: 27
Table Size: 10.16 KB
UserAgentMatcher: TeraWurfl_Sharp
Rows: 107
Table Size: 63.47 KB
UserAgentMatcher: TeraWurfl_Siemens
Rows: 378
Table Size: 150.27 KB
UserAgentMatcher: TeraWurfl_SonyEricsson
Rows: 837
Table Size: 629.22 KB
UserAgentMatcher: TeraWurfl_Toshiba
Rows: 6
Table Size: 8.29 KB
UserAgentMatcher: TeraWurfl_Vodafone
Rows: 106
Table Size: 95.91 KB
UserAgentMatcher: TeraWurfl_WindowsCE
Rows: 348
Table Size: 252.58 KB



Tera-WURFL Settings
Installation Directory: /var/www/tera-wurfl.com/web/Tera-Wurfl

-- Database options --
DB_HOST localhost:/var/run/mysqld/mysqld.sock , database server hostname or IP
DB_USER terawurfluser , database username (needs SELECT,INSERT,DELETE,DROP,CREATE)
DB_PASS ********, database password
DB_SCHEMA tera_wurfl_demo , database schema (database name)
DB_CONNECTOR MySQL5 , database type (MySQL4, MySQL5, MSSQL2005, etc...);
TABLE_PREFIX TeraWurfl , prefix to be used for all table names

-- General options --
WURFL_DL_URL http://downloads.sourceforge.net/project/wurfl/WURFL/latest/wurfl-latest.zip , full URL to the current WURFL
WURFL_CVS_URL http://wurfl.cvs.sourceforge.net/%2Acheckout%2A/wurfl/xml/wurfl.xml , full URL to development (CVS) WURFL
DATADIR data/ , where all data is stored (wurfl.xml, temp files, logs)
CACHE_ENABLE true, enables or disables the cache
PATCH_ENABLE true , enables or disables the patch
PATCH_FILE custom_web_patch.xml;web_browsers_patch.xml, optional patch file for WURFL. To use more than one, separate them with semicolons
WURFL_FILE wurfl.xml , path and filename of wurfl.xml
WURFL_LOG_FILE wurfl.log , defines full path and filename for logging
LOG_LEVEL LOG_ERR , desired logging level. Use the same constants as for PHP logging
OVERRIDE_MEMORY_LIMIT true , override PHP's default memory limit
MEMORY_LIMIT 256M , the amount of memory to allocate to PHP if OVERRIDE_MEMORY_LIMIT is enabled
SIMPLE_DESKTOP_ENGINE_ENABLE false , enable the SimpleDesktop Detection Engine to increase performance
CAPABILITY_FILTER: 

false
the capability filter that is used to determine which capabilities are available

 

Log File (last 30 lines)
Sun, 21 Apr 2024 22:44:32 -0400 [production.scientiamobile.local 23470][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 13.24 seconds
Sun, 21 Apr 2024 22:44:32 -0400 [production.scientiamobile.local 23470][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 21 Apr 2024 22:44:22 -0400 [production.scientiamobile.local 23470][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 21 Apr 2024 22:44:22 -0400 [production.scientiamobile.local 23470][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 21 Apr 2024 22:44:16 -0400 [production.scientiamobile.local 23533][TeraWurflDatabase_MySQL5::getDeviceFallBackTree] ERROR: Tera-WURFL Error: database fallback procedure returned no records, verify that TeraWurfl_FallBackDevices exists.
Fri, 19 Apr 2024 08:16:30 -0400 [production.scientiamobile.local 14525][TeraWurflDatabase_MySQL5::getDeviceFallBackTree] ERROR: Tera-WURFL Error: database fallback procedure returned no records, verify that TeraWurfl_FallBackDevices exists.
Fri, 12 Apr 2024 18:40:05 -0400 [production.scientiamobile.local 4573][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 13.4 seconds
Fri, 12 Apr 2024 18:40:05 -0400 [production.scientiamobile.local 4573][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Fri, 12 Apr 2024 18:39:55 -0400 [production.scientiamobile.local 4573][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Fri, 12 Apr 2024 18:39:55 -0400 [production.scientiamobile.local 4573][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 11 Apr 2024 00:01:39 -0400 [production.scientiamobile.local 20775][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 01 Apr 2024 05:05:31 -0400 [production.scientiamobile.local 22440][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:57:33 -0400 [production.scientiamobile.local 17133][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 13.72 seconds
Sun, 31 Mar 2024 15:57:33 -0400 [production.scientiamobile.local 17133][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:57:24 -0400 [production.scientiamobile.local 17133][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 31 Mar 2024 15:57:24 -0400 [production.scientiamobile.local 17133][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 31 Mar 2024 15:55:41 -0400 [production.scientiamobile.local 14063][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 15.38 seconds
Sun, 31 Mar 2024 15:55:41 -0400 [production.scientiamobile.local 14063][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:55:30 -0400 [production.scientiamobile.local 14063][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 31 Mar 2024 15:55:30 -0400 [production.scientiamobile.local 14063][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 31 Mar 2024 15:54:04 -0400 [production.scientiamobile.local 23823][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 11.27 seconds
Sun, 31 Mar 2024 15:54:04 -0400 [production.scientiamobile.local 23823][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:53:57 -0400 [production.scientiamobile.local 23823][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 31 Mar 2024 15:53:56 -0400 [production.scientiamobile.local 23823][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 31 Mar 2024 15:52:43 -0400 [production.scientiamobile.local 16813][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 14.2 seconds
Sun, 31 Mar 2024 15:52:43 -0400 [production.scientiamobile.local 16813][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:52:33 -0400 [production.scientiamobile.local 16813][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Sun, 31 Mar 2024 15:52:33 -0400 [production.scientiamobile.local 16813][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Sun, 31 Mar 2024 15:51:45 -0400 [production.scientiamobile.local 8582][Tera-WURFL] WARNING: Finished loading WURFL db.scientiamobile.com - 2011-09-13 00:00:01 (Tue Sep 13 00:01:26 -0500 2011) in 17.08 seconds
Sun, 31 Mar 2024 15:51:45 -0400 [production.scientiamobile.local 8582][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Sun, 31 Mar 2024 15:51:32 -0400 [production.scientiamobile.local 8582][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml