Tera-WURFL Administration
Version Stable 2.1.2


<< Back to main page

Database Table Statistics
MERGE
TeraWurflMerge		 Rows: 19672
Actual Devices: 8796
Table Size: 10.30 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: 19672
Table Size: 553.52 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 behaviour 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: 228
Table Size: 206.93 KB
UserAgentMatcher: TeraWurfl_Android
Rows: 3492
Table Size: 1.28 MB
UserAgentMatcher: TeraWurfl_Apple
Rows: 187
Table Size: 16.30 KB
UserAgentMatcher: TeraWurfl_BenQ
Rows: 83
Table Size: 40.94 KB
UserAgentMatcher: TeraWurfl_BlackBerry
Rows: 363
Table Size: 171.91 KB
UserAgentMatcher: TeraWurfl_Bot
Rows: 27
Table Size: 0 B
UserAgentMatcher: TeraWurfl_CatchAll
Rows: 4050
Table Size: 2.02 MB
UserAgentMatcher: TeraWurfl_Chrome
Rows: 39
Table Size: 2.22 KB
UserAgentMatcher: TeraWurfl_DoCoMo
Rows: 463
Table Size: 229.51 KB
UserAgentMatcher: TeraWurfl_Firefox
Rows: 31
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Grundig
Rows: 6
Table Size: 3.56 KB
UserAgentMatcher: TeraWurfl_HTC
Rows: 775
Table Size: 272.31 KB
UserAgentMatcher: TeraWurfl_Kddi
Rows: 416
Table Size: 254.47 KB
UserAgentMatcher: TeraWurfl_Konqueror
Rows: 4
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Kyocera
Rows: 90
Table Size: 40.96 KB
UserAgentMatcher: TeraWurfl_LG
Rows: 1069
Table Size: 938.00 KB
UserAgentMatcher: TeraWurfl_MSIE
Rows: 17
Table Size: 1.71 KB
UserAgentMatcher: TeraWurfl_Mitsubishi
Rows: 39
Table Size: 8.21 KB
UserAgentMatcher: TeraWurfl_Motorola
Rows: 1243
Table Size: 631.01 KB
UserAgentMatcher: TeraWurfl_Nec
Rows: 90
Table Size: 45.67 KB
UserAgentMatcher: TeraWurfl_Nintendo
Rows: 8
Table Size: 5.15 KB
UserAgentMatcher: TeraWurfl_Nokia
Rows: 1930
Table Size: 847.69 KB
UserAgentMatcher: TeraWurfl_Opera
Rows: 26
Table Size: 10.82 KB
UserAgentMatcher: TeraWurfl_OperaMini
Rows: 62
Table Size: 12.60 KB
UserAgentMatcher: TeraWurfl_Panasonic
Rows: 87
Table Size: 66.16 KB
UserAgentMatcher: TeraWurfl_Pantech
Rows: 122
Table Size: 123.82 KB
UserAgentMatcher: TeraWurfl_Philips
Rows: 141
Table Size: 91.52 KB
UserAgentMatcher: TeraWurfl_Portalmmm
Rows: 251
Table Size: 89.52 KB
UserAgentMatcher: TeraWurfl_Qtek
Rows: 14
Table Size: 5.91 KB
UserAgentMatcher: TeraWurfl_SPV
Rows: 81
Table Size: 23.27 KB
UserAgentMatcher: TeraWurfl_Safari
Rows: 52
Table Size: 11.87 KB
UserAgentMatcher: TeraWurfl_Sagem
Rows: 260
Table Size: 144.42 KB
UserAgentMatcher: TeraWurfl_Samsung
Rows: 1889
Table Size: 1.56 MB
UserAgentMatcher: TeraWurfl_Sanyo
Rows: 91
Table Size: 74.21 KB
UserAgentMatcher: TeraWurfl_Sharp
Rows: 0
Table Size: 0 B
UserAgentMatcher: TeraWurfl_Siemens
Rows: 378
Table Size: 146.69 KB
UserAgentMatcher: TeraWurfl_SonyEricsson
Rows: 1063
Table Size: 673.14 KB
UserAgentMatcher: TeraWurfl_Toshiba
Rows: 6
Table Size: 7.95 KB
UserAgentMatcher: TeraWurfl_Vodafone
Rows: 141
Table Size: 109.97 KB
UserAgentMatcher: TeraWurfl_WindowsCE
Rows: 358
Table Size: 253.96 KB



Tera-WURFL Settings
Installation Directory: /home/mantra/public_html/Tera-WURFL

-- Database options --
DB_HOST localhost , database server hostname or IP
DB_USER shraddha_root , database username (needs SELECT,INSERT,DELETE,DROP,CREATE)
DB_PASS ********, database password
DB_SCHEMA shraddha_tera_wurfl_db , database schema (database name)
DB_CONNECTOR MySQL4 , database type (MySQL5, MSSQL, Oracle, etc...);
DEVICES TeraWurfl , database table name for the WURFL with the patch updates
CACHE TeraWurflCache , database table name for the cache
INDEX TeraWurflIndex, database table name for the Index of the WURFL IDs and UserAgentMatchers
MERGE TeraWurflMerge, database table name for the combined UserAgentMatcher tables

-- 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 false, 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 true , 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)
Wed, 10 Dec 2025 11:43:50 +0000 [ugi-nl-ct-hc.r2itservices.com 1513561][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Wed, 10 Dec 2025 11:43:48 +0000 [ugi-nl-ct-hc.r2itservices.com 1513447][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 18 seconds
Wed, 10 Dec 2025 11:43:48 +0000 [ugi-nl-ct-hc.r2itservices.com 1513447][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Wed, 10 Dec 2025 11:43:32 +0000 [ugi-nl-ct-hc.r2itservices.com 1513447][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Wed, 10 Dec 2025 11:43:32 +0000 [ugi-nl-ct-hc.r2itservices.com 1513447][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Tue, 09 Dec 2025 09:52:06 +0000 [ugi-nl-ct-hc.r2itservices.com 621479][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 12.87 seconds
Tue, 09 Dec 2025 09:52:06 +0000 [ugi-nl-ct-hc.r2itservices.com 621479][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Tue, 09 Dec 2025 09:51:55 +0000 [ugi-nl-ct-hc.r2itservices.com 621479][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Tue, 09 Dec 2025 09:51:55 +0000 [ugi-nl-ct-hc.r2itservices.com 621479][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 08 Dec 2025 16:41:58 +0000 [ugi-nl-ct-hc.r2itservices.com 101411][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Thu, 04 Dec 2025 10:39:08 +0000 [ugi-nl-ct-hc.r2itservices.com 1719137][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 13.11 seconds
Thu, 04 Dec 2025 10:39:08 +0000 [ugi-nl-ct-hc.r2itservices.com 1719137][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Thu, 04 Dec 2025 10:38:56 +0000 [ugi-nl-ct-hc.r2itservices.com 1719137][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Thu, 04 Dec 2025 10:38:56 +0000 [ugi-nl-ct-hc.r2itservices.com 1719137][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 04 Dec 2025 10:38:51 +0000 [ugi-nl-ct-hc.r2itservices.com 1719121][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Fri, 28 Nov 2025 02:33:16 +0000 [ugi-nl-ct-hc.r2itservices.com 2256437][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 12.94 seconds
Fri, 28 Nov 2025 02:33:16 +0000 [ugi-nl-ct-hc.r2itservices.com 2256437][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Fri, 28 Nov 2025 02:33:04 +0000 [ugi-nl-ct-hc.r2itservices.com 2256437][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Fri, 28 Nov 2025 02:33:04 +0000 [ugi-nl-ct-hc.r2itservices.com 2256437][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Thu, 27 Nov 2025 15:51:32 +0000 [ugi-nl-ct-hc.r2itservices.com 1994955][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 24 Nov 2025 20:02:56 +0000 [ugi-nl-ct-hc.r2itservices.com 358586][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 12.5 seconds
Mon, 24 Nov 2025 20:02:56 +0000 [ugi-nl-ct-hc.r2itservices.com 358586][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 24 Nov 2025 20:02:45 +0000 [ugi-nl-ct-hc.r2itservices.com 358586][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Mon, 24 Nov 2025 20:02:45 +0000 [ugi-nl-ct-hc.r2itservices.com 358586][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 24 Nov 2025 15:37:06 +0000 [ugi-nl-ct-hc.r2itservices.com 256088][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 13.04 seconds
Mon, 24 Nov 2025 15:37:06 +0000 [ugi-nl-ct-hc.r2itservices.com 256088][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 24 Nov 2025 15:36:55 +0000 [ugi-nl-ct-hc.r2itservices.com 256088][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml
Mon, 24 Nov 2025 15:36:55 +0000 [ugi-nl-ct-hc.r2itservices.com 256088][Tera-WURFL] WARNING: Loading patch: custom_web_patch.xml
Mon, 24 Nov 2025 12:02:42 +0000 [ugi-nl-ct-hc.r2itservices.com 172096][Tera-WURFL] WARNING: Finished loading WURFL 2.3.4, db.scientiamobile.com - 2013-06-02 18:44:18 (Sun Jun 02 18:46:46 -0400 2013) in 12.31 seconds
Mon, 24 Nov 2025 12:02:42 +0000 [ugi-nl-ct-hc.r2itservices.com 172096][rebuildCacheTable] WARNING: Rebuilt cache table, existing table was empty - this is very unusual.
Mon, 24 Nov 2025 12:02:31 +0000 [ugi-nl-ct-hc.r2itservices.com 172096][Tera-WURFL] WARNING: Loading patch: web_browsers_patch.xml