[louiza@pc51 kameleoon]$ ssh root@alqualonde.kameleoon.net
alqualonde ~ # mysql -pkameleoon_dev -ukameleoon
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2952
Server version: 5.6.24-log Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use net_kameleoon_kameleoon;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from customer;
+----------+
| count(*) |
+----------+
|      870 |
+----------+
1 row in set (0.00 sec)

mysql> select * from customer where name="louiza";
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
| id   | version | person_id | authentication_key | skin_id | date_created        | disabled | date_disabled | financial_data_id | analyst_setup | googleoauth_access_token | googleoauth_refresh_token | progress_id | usage_logs_enabled | edition_site_id | googleoauth_expiration_time | dismiss_no_registered_sites | last_login          | name   | cdn_configuration | allow_multiple_logins | premium_setup | over_limit_traffic_allowed | personalization_setup | tutorial_mode |
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
| 4079 |     189 |      4092 | hsrsv938rb         |       1 | 2014-12-15 13:40:07 |          | NULL          |              4133 |              | NULL                     | NULL                      |        NULL |                    |           11425 |                        NULL |                             | 2015-07-10 09:30:36 | louiza | DEFAULT           |                       |               |                            |                      |               |
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
1 row in set (0.00 sec)

mysql> select Ctrl-C -- exit!where name="louiza";
Aborted
alqualonde ~ # mysql -pkameleoon_dev -ukameleoon
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2953
Server version: 5.6.24-log Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use net_kameleoon_kameleoon;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select premium_setup from customer where name="louiza";
+---------------+
| premium_setup |
+---------------+
|               |
+---------------+
1 row in set (0.00 sec)

mysql> update customer set premium_setup=1 and personalization_setup=1 where name="louiza";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select premium_setup from customer where name="louiza";
+---------------+
| premium_setup |
+---------------+
|              |
+---------------+
1 row in set (0.00 sec)

mysql> select * from customer where name="louiza";
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
| id   | version | person_id | authentication_key | skin_id | date_created        | disabled | date_disabled | financial_data_id | analyst_setup | googleoauth_access_token | googleoauth_refresh_token | progress_id | usage_logs_enabled | edition_site_id | googleoauth_expiration_time | dismiss_no_registered_sites | last_login          | name   | cdn_configuration | allow_multiple_logins | premium_setup | over_limit_traffic_allowed | personalization_setup | tutorial_mode |
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
| 4079 |     189 |      4092 | hsrsv938rb         |       1 | 2014-12-15 13:40:07 |          | NULL          |              4133 |              | NULL                     | NULL                      |        NULL |                    |           11425 |                        NULL |                             | 2015-07-10 09:30:36 | louiza | DEFAULT           |                       |              |                            |                      |               |
+------+---------+-----------+--------------------+---------+---------------------+----------+---------------+-------------------+---------------+--------------------------+---------------------------+-------------+--------------------+-----------------+-----------------------------+-----------------------------+---------------------+--------+-------------------+-----------------------+---------------+----------------------------+-----------------------+---------------+
1 row in set (0.00 sec)

mysql> update financial_data set recurly_registration=1 WHERE id=4133
    -> ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select recurly_registration from financial_data WHERE id=4133
    -> ;
+----------------------+
| recurly_registration |
+----------------------+
|                     |
+----------------------+
1 row in set (0.00 sec)

mysql> exit
Bye
alqualonde ~ # tail -f /var/log/net.kameleoon-dev/kameleoon/runtime.log
java.lang.NullPointerException
        at com.kameleoon.backoffice.PreferencesController$_general_closure63.doCall(PreferencesController.groovy:856)
        at com.kameleoon.core.CommonController$_closure1.doCall(CommonController.groovy:466)
        at com.kameleoon.backoffice.PreferencesController.general(PreferencesController.groovy:856)
        at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
        at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
        at org.tonyzampogna.xss.sanitizer.filter.XssFilter.doFilterInternal(XssFilter.java:23)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
^[[A^[[A^C
alqualonde ~ # cat /var/log/net.kameleoon-dev/kameleoon/runtime.log