search

cobub / razor

Cobub Razor - Open Source Mobile Analytics Solution
http://www.cobub.com
1.13k stars 431 forks source link

MySQL Archive Issue / sendEmail.php typo #54

Closed xmovu closed 11 years ago

xmovu commented 11 years ago

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 :)

labixin commented 11 years ago

Hello mrgeneral, i understood what you mean,Inter-library use database requires sufficient permissions.I suggest that your database and data warehouse using the same database,table prefix is best to use a different prefix favor distinguish.

cobub commented 11 years ago

for the second issue, please get the latest code, this bug has been fixed a month ago.