cobub/razor

Cobub Razor - Open Source Mobile Analytics Solution

Cobub News

April 2019, Java Enterprise C4J was released. C4J is a low-cost, privatized, full-channel, high-performance user analytics tool.

Visit demo: https://c4j.cn/demo

Application for trial: https://c4j.cn/ucenter/#/apply4trail

Cobub Razor - Open Source Mobile Analytics

　　

Firstly, welcome to access the DEMO website to have a try:

          

Cobub Razor is a powerful, open source mobile analytics system. It enables user to monitor the statistics of their mobile Apps and app users' behaviors through providing detailed, multi-dimensions reports on mobile application users. At this moment, it supports iOS, Android and Windows Phone OS platform.

Cobub Razor has two components. Web Cobub Razor is a PHP/MySQL system that you download and install on your Web Server. Another component is Cobub Razor SDK (iOS/Android/WinPhone supported), which is embedded in your mobile application during the development phase.

Cobub Razor is a tool that enables Apps developers and enterprises which have Apps. It can monitor users' behaviors, users' device features, users' clicks, custom event, Apps errors, auto update of Apps and so on. Cobub Razor also helps on notify the users to upgrade version, compare different Apps and compare different distribution channels.

A Chinese introduction video: Cobub Razor Introduction Video - Chinese Version

Cobub Razor Features

Compare to other analytics systems, Cobub Razor has following advantages:

* Private system and data storage
* Real time and detailed Apps usage
* Low cost
* Possible for other data source integration
* Custom reports available
* Fully support mobile devices to visit the reports

Cobub Razor Installation

How to install Cobub Razor: http://docs.cobub.com/pages/viewpage.action?pageId=884864

DO NOT forget to configure the schedule tasks: http://docs.cobub.com/pages/viewpage.action?pageId=884913

More details, please visit http://docs.cobub.com

Cobub Razor Issues

Any problems, requests, please submit issues to https://github.com/cobub/razor/issues

Mailing Lists

Subscribe: [email protected] Post Message: [email protected]

QQ Group

QQ group:194022996

License

The Cobub Razor software is released under the licenses from the Free Software Foundation. We are using different license for different components in the package of Cobub Razor software:

• For the web side of Cobub Razor (include the reporting part and data interface), the license of GPL v3 is applied.
• For the SDK/client side of Cobub Razor (include the version of iOS, Android and other versions), the license of LGPL v3 is applied.

razor's Issues

存储过程updatedatawarestore执行错误

（dp.product_name<>p.name or
dp.product_type<
执行到这就不执行了

发现2个Bug

1.建应用的时候如果描述填写不规范，那么会刷新整个页面，所有选项均重置,无法保留之前已选择的选项
2.删除某个应用后再创建一次同名应用后提示应用名称已存在，应该是数据库中没有删除对应的字段，同样会有刷新页面后重置所有选项的问题/。

请支持渠道用户单独登录，查询数据的功能

初略看了你们的demo，请问具有渠道用户单独登录，查询数据的功能码？也就是应用发布者需要让推广渠道A的人能够登录统计平台查看渠道A的数据，只能看到该渠道的数据，这就需要应用发布者能够增加、删除渠道用户；需要能够赋予该渠道用户以查看某个渠道数据的权限；需要渠道用户这个角色。我知道友盟有这个功能。这个功能很重要，期望razor能够早日实现这个功能！！

手动执行php index.php archive archive archivehourly出错

安装的时候存储过程没有生成

安装的时候存储过程没有生成

调用"php index.php archive archiveHourly"显示 Table 'appstat.razor_dim_location' doesn't exist

由于我配置的时候数据仓库时数据库名恰巧用得是"razorware_"的前缀. 查看代码时发现,操作数据仓库相关的代码可能是hard code了 razor_ 前缀,所以导致不能查到对的表格.

如果用"razor_"前缀应该没问题.

线程阻塞的问题

第一：异常自动捕获之后没有做相应的处理造成用户主线程被阻塞
第二：数据提交过程在主线程中进行，造成线程阻塞

Database info dosn't work

The site for create database dosn't work.
h**p://mysubdomain.geniali.ch/index.php?/install/install/databaseinfo

• no labels
• the next button not work
• the next button have no text

I can't initialize the website. :-(

update from 0.2 to 0.3

Hi, how we can update to 0.3 from 0.2 without loosing data ? Thanks.

Bad point excess error when press home button in iOS6 device (0.2Version SDK)

When press Home button to make the app in background mode, a bad point excess error happened.

The app stopped in function "- (void)saveActivityUsingTime:(NSString*) pageName". It seems that a bad point excess error happened when "NSData *pageStartDate = [[NSUserDefaults standardUserDefaults] objectForKey: pageName];"

The detail of the error:
call 0x1e96a00 symbol stub for: getpid

PS:
When I add "[UMAgent startTracPage:@"XXX"];", this error dose not appear any more.
Dose the tracPage have to be set?

引入SDK包后，发现UmsAgent无法调用setBaseURL，显示The method setBaseURL(String) is undefined for the type UmsAgent

No CSS

When i open the root url, for Setup (h**p://mysubdomain.geniali.ch), not have css design.

With h**p://mysubdomain.geniali.ch/index.php, i've perfect layout.

You can contact me for the right url. :-)

统一登录问题

如果将您们的“移动访问分析系统”集成到现在的系统中，请问怎么实现统一登录。即现有系统的用户直接能访问“移动访问分析系统”，不需要再登录“移动访问分析系统”了？或“移动访问分析系统”怎么用一个默认的用户名自动登录？能给一个例子吗？

ROOT用户登陆后无法查看 "用户管理" 和 "角色管理" 以及 "添加类型"

导致不可查看该页面的修改可能是在数据库中做了某些字段的update, 请问如何恢复

iOS uses "Build" number not "Version" number

We should use the version number instead of the build number.

eg, my app is Version 2.0.3, build 456. Version 2.0.3 is probably more useful

Here is the change:
https://github.com/jameszaghini/razor/commit/b7d610c8c5ad80fab88143c9af3974b160a3b13f

分布渠道页面统计的今日新增与昨日新增包含了升级用户

你好，

据我们观察，如果一个用户之前是用渠道A安装的，然后他通过渠道B升级，这样的用户会被计算入渠道B的新增用户。

其他位置的新增用户数据没有受上面问题的影响，目前没有找到问题。

xcode4.4.1 sdk 编译后，libUMSAgent.a 无法使用

操作步骤：
1、使用xcode 4.4.1 打开 iphone_sdk 中 UMS.xcworkspace
2、编译 UMSAgent,产生 libUMSAgent.a
3、将 libUMSAgent.a 加入 UMSAgentExample，无法编译通过，提示 ARC Semantic Issue

如下代码，提示 no known class method for selector 'startTracPage'
[UMSAgent startTracPage:@"GWTEST"];
[UMSAgent endTracPage:@"GWTEST"];

估计应该是使用ARC，编译后的问题，本人对这方面补了解，请问如何解决。

Can't delete a product category.

The product category that has been deleted will display in the dropdown list too.

手工执行存储过程，报1364错误

手工依次执行：
call rundim();
call runfact('2012-12-20 15:00:00','2012-12-20 15:59:59');
call runsum('2012-12-20');

在runsum处，报：

SQL 错误 [1364] [HY000]: Field 'segment_sk' doesn't have a default value

Field 'segment_sk' doesn't have a default value

我已经将mysql的sql_mode改为：NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

安装过程出现错误

Table 'minichaoshi.razor_users' doesn't exist

INSERT INTO razor_users (username, password, email, last_ip, new_email_key, created, activated) VALUES ('test', '$P$BM5Cu/QFLcI1YctMOrE2yeO2FDw/TZ0', '[email protected]', '222.95.57.111', 'ae2be2ea61117c78bc0eedc9db328efc', '2012-08-30 21:04:50', 0)

Filename: ..\wwwroot\system\database\DB_driver.php

Line Number: 330

Routines in datawarestore.sql not added

Hi,

During the install process, the routines in datawarestore.sql are not added. I then tried to manually run them through phpmyadmin, but I got multiple errors.

To resolve this, I made the following changes to datawarestore.sql and run it in phpmyadmin

1. Removed all "--$$" comments
2. Changed "end;" to "end;;"
3. Set the delimiter to ";;" in phpmyadmin

https://gist.github.com/4146016

There were no errors from php regarding the issue during install. I haven't got any data in the databases yet, but the scheduled tasks are running without error. I'll let you know if I have any further problems.

cobub razor v0.2
Server 2008, IIS 7.5
PHP 5.3.16
MySQL 5.5.28

call rundim(): #1205 Lock wait timeout exceeded; try restarting transaction

archive hourly task always failed, and try to call rundim() throws "#1205 Lock wait timeout exceeded; try restarting transaction" exception.

Database: razor_fact_clientdata has 852,309 records, while razor_fact_usinglog has 1,301,013 records.

Do you have any idea how to optimize DB?

cronjob failed with error :can't locate sendemail model

-> Unable to locate the model you have specified: sendemail

version 0.3
with dreamhost shared server

Please move SDK to separate repository

Cobub Razor is awesome! But please separate SDK from Web repository. Actually, we are really interested in your Web platform, but we may want to use our own client to send report data :)

app运行时断掉

deviceInfo.MCCMNC = (null)，
Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[__NSCFDictionary setObject:forKey:]: attempt to insert nil value (key: mccmnc)'

There has't upgrade program from 0.3 to 0.4

I had razor on production, but if I want to upgrade this program, I must to write many sqls to do the job. Can you provide incremental sql updates?

安装服务器时，打开安装文件的路径，出现cobub安装界面，点击安装没有反应

接受cobub razor所附带的软件许可协议后，点击安装，没有任何反应

crach in iOS SDK

Hi,
in iOS SDK when I click to home button if my app is active, it crash with this in console:

Commit using Time of page (null)
Current Time 2 = 2012-10-28 21:27:55

添加渠道的时候出现这样的问题

A Database Error Occurred

Error Number: 1364

Field 'description' doesn't have a default value

INSERT INTO razor_channel_product (product_id, date, user_id, productkey, channel_id) VALUES ('2', '2013-01-07 04:53:32', '1', 'f15936ab091d7937e5691cb65748f1b9', '4')

Filename: web\system\database\DB_driver.php

Line Number: 330

cobub razor 系统界面上的数据都是0 ---客户端iphone 5.0 simulator

我的cobub 系统界面上基本统计数据全为0 。
我在客户端代码中使用的方式是REALTIME，和自动更新应该没有关系，是不是需要调用什么函数。
我在客户端代码中只调用了[UMSAgent postEvent:@"clickEquals" label:@"=" ];，
[UMSAgent startWithAppKey:@"***" ReportPolicy:REALTIME];
[UMSAgent setIsLogEnabled:YES];和调用了 [UMSAgent checkUpdate];
文档中有介绍调用UMSAgent endTracPage：@“GWTEST”和调用UMSAgent startTracPage：@“GWTEST”，其中的GWTEST是指什么？，而且这两个函数顺序是不是写反了...

Field 'updateurl' doesn't have a default value

A error occurred after add a new app.

A Database Error Occurred

Error Number: 1364

Field 'updateurl' doesn't have a default value

INSERT INTO razor_channel_product (product_id, description, date, user_id, productkey, channel_id) VALUES (2, '', '2012-12-13 03:52:15', '1', '551e7e078b9866d0774f52defe******', '7')

Filename: D:\razor\system\database\DB_driver.php

Line Number: 330

archive.php代码修改

你好，统计过程中发现在web/application/controllers/archive.php文件中，存储过程调用$dwdb->query("call rumsum($date)"); 正确应该为$dwdb->query("call runsum('$date')"); rumsum 应改为runsum ；另有一问题是：$dwdb->query("call runfact($fromTime,$toTime)"); 时间需要加引号，我在调试过程中如果不加引号会报错。

官方网站会不出出一份安装和调试、试用手册呢？

Analytics for iOS SDK - Invalid Content

Hi,

I have posted the client data to server and i got the response too " {"flag":1,"msg":"ok"} ".

But If i run the server url with appended url

i.e., for example " http://demo.servername.com/razor/web/index.php?/ums/postClientData ", then it displaying

" {"flag":-2,"msg":"Invalid key."} "

and i haven't seen any changes on server " http://demo.servername.com/razor/web/index.php ".

So, what is the process to get the analytics in iOS, any customisation needed in SDK, please help.

Thanks.

可不可以把应用更新的下载写成一个服务

可不可以把应用更新的下载写成一个服务，在通知栏提示下载应用的进度。以前的模式用户更新完才能使用应用。

Windows 计划设置定时任务没效果

等了一天还是没用。
手工运行也没效果。
php “D:\xampp\htdocs\razor\index.php” archive archiveWeekly

数据库中少一张表

您好：
我是个人用户，在使用COBUB测试、代码定位过程中，发现在datawarestore.sql脚本657行有一个

insert into umsinstall_fact_basic_all(product_sk,date_sk,usingtime)
select f.product_sk,f.date_sk,sum(duration) from umsinstall_fact_usinglog_daily f, umsinstall_dim_date d where f.date_sk = d.date_sk and d.datevalue = today group by f.product_sk,f.date_sk on duplicate key update usingtime=values(usingtime);
set e = now();
insert into umsinstall_log(op_type,op_name,op_date,affected_rows,duration)
values('runsum','umsinstall_sum_basic_all',e,row_count(),TIMESTAMPDIFF(SECOND,s,e));

的操作，但在数据库中是没有umsinstall_fact_basic_all这张表，在数据库安装SQL脚本中也无此数据表的创建信息，特此反馈下，谢谢。

Page view visit path always show "no data"

Hi,

I just see that the page view chart always show "no data" but every views are visible in the page view details. Maybe there is an error in the dim procedure for activity, there is no records in my prefix_dim_activity table.

Database error when creating new apps

Hi, I got the following error when creating a new app

A Database Error Occurred

Error Number: 1364

Field 'updateurl' doesn't have a default value

INSERT INTO `razor_channel_product` (`product_id`, `description`, `date`, `user_id`, `productkey`, `channel_id`) VALUES (1, '.', '2012-11-23 15:08:25', '1', '735474e4aa8928b6e53de1962632cf8a', '5')

Filename: E:\mysite.com\system\database\DB_driver.php

Line Number: 330

I get the same error code for 'entrypoint', 'location', and 'version' columns on that table.

I changed the default value to an empty string for these columns and it now allows me to proceed without the error.

cobub razor v0.2
Server 2008, IIS 7.5
PHP 5.3.16
MySQL 5.5.28

data inverted

Hi,

in "Overview" block in Console, active users and sessions count are inverted
in "App" block in Console, active users and sessions count are inverted

All is OK in other reports.

今日活跃用户数 比 累计用户数多

你好，我们最近在尝试使用razor 0.4版本进行用户数的统计，有一个问题想请教：

渠道统计页面数据如下：
渠道 Google Market
今日新增 223
昨日新增 5
今日活跃 241
昨日活跃 5
累计用户 230
周活跃率 50%
月活跃率 0.0%

在上述数据中，活跃用户数多于累计用户，是程序统计时的错误还是说这个是正常的，是哪里理解不对了？

NetworkOnMainThreadException in CommonUtil.java, getItude method

https://github.com/cobub/razor/blob/master/sdk/android_sdk/SDK/src/com/wbtech/ums/common/CommonUtil.java#L434

This code is attempting to run on the main thread and is therefore throwing an exception.

            E  android.os.NetworkOnMainThreadException
System.err  W  java.lang.Exception: 获取经纬度出现错误:null
System.err  W   at com.wbtech.common.CommonUtil.getItude(CommonUtil.java:475)
System.err  W   at com.wbtech.ums.UmsAgent.postClientData(UmsAgent.java:751)
System.err  W   at au.net.ace.myapp.activity.MainActivity.onCreate(MainActivity.java:109)
System.err  W   at android.app.Activity.performCreate(Activity.java:4465)
System.err  W   at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1052)
System.err  W   at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1932)
System.err  W   at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1993)
System.err  W   at android.app.ActivityThread.access$600(ActivityThread.java:127)
System.err  W   at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1159)
System.err  W   at android.os.Handler.dispatchMessage(Handler.java:99)
System.err  W   at android.os.Looper.loop(Looper.java:137)
System.err  W   at android.app.ActivityThread.main(ActivityThread.java:4507)
System.err  W   at java.lang.reflect.Method.invokeNative(Native Method)
System.err  W   at java.lang.reflect.Method.invoke(Method.java:511)
System.err  W   at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:790)
System.err  W   at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
System.err  W   at dalvik.system.NativeStart.main(Native Method)

Perhaps it would be better to just use LocationManager to get the users location?

cobub razor v0.2
Android 4.0.3

0.2 version some error logs out, please help check.

ERROR - 2012-10-25 11:42:01 --> Severity: Warning --> mysql_num_rows() expects parameter 1 to be resource, boolean given /path/to/www/razor/web/system/database/drivers/mysql/mysql_result.php 37

some errors

when i install, there is displaying some error info follow:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: lastsqlStr

Filename: controllers/main.php

Line Number: 447

MySQL Archive Issue / sendEmail.php typo

Hello folks,

So, our setup is an amazon micro instance, and also, amazon small rds (mysql instance), as so, we cannot give all permissions to the razor user, therefore, I'm using the master mysql user here (not root, as I said, amazon doesn't give you root in their rds/mysql offers)

I've been trying to configure the crons for ages, it seems some of the files is using the db name to be user name, my setup is:

master user: razoradm
first db: razormain
second db, for warehouse: razordata

When I go to : http://website/index.php?/archive/archiveHourly , I get:

Error Number: 1142

SELECT command denied to user 'razordata'@'%' for table 'razor_clientdata'

call rundim()

Filename: /var/www/sitek.com/controllers/archive.php

Line Number: 44

Well, I did not set the user razordata anywhere, but razoradm as mysql user which should have enough permissions.
I went to the file application/config/database.php and the user is razoradm, which is right.

Do you have any solution?

Now, second issue, if you guys go to index.php?/archive/archiveHourly you'll get an error, fail to load module sendemail.php

You need to go to application/models/alert and change sendEmail.php to sendemail.php :)

product_version中没有数据

product_version表中没有数据，导致数据工厂数据库导入到数据仓库失败，怎么回事

iOS UMSAgent Scheme missing UMSAgent-Prefix.pch file

When trying to build libUMSAgent.a, I get the following error:

clang: error: no such file or directory: '/Users/james/Developer/cobub-razor-fork/sdk/iOS_sdk/UMSAgent/UMSAgent/UMSAgent-Prefix.pch'

Workaround is to remove "UMSAgent/UMSAgent-Prefix.pch" from "Prefix Header" in Build Settings for the UMSAgent project. I assume that there is nothing important in that file at this time.

Could you please add the file to the project?

How to create Razor Archives in Local system

Hi ,

How to create Razor Archives in Local system . can any one help

Regards
Amarnadh

弱弱的问一句，可以弄个django版本的razor吗？

python效率比php更高。

执行存储过程updatedatawarestore.sql错误

ERROR 1064 (42000) at line 2: 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 '--$$

CREATE PROCEDURE rundim()
NO SQL
begin
declare s datetime' at line 1

/index.php?/archive/archiveHourly errors

A Database Error Occurred

Error Number: 1146

Table 'cobub.dim_date' doesn't exist

call runsum('2012-08-03')

Filename: /data0/www/bi/web/controllers/archive.php

Line Number: 50