I couldn't set max-allowed-packet this way:
user@ubuntu-1404-server-amd64-dist:/var/lib/tomcat7/common/lib$ sudo service mysql restart --max-allowed-packet=50M
stop: invalid option: --max-allowed-packet=50M
Try `stop --help' for more information.
start: invalid option: --max-allowed-packet=50M
Try `start --help' for more information.
However, this is /etc/mysql/my.cnf having max_allowed_packet = 100M:
my.cnfAlso, it doesn't look there's a problem with the credentials:
user@ubuntu-1404-server-amd64-dist:/var/lib/tomcat7/common/lib$ sudo service mysql restart
mysql stop/waiting
mysql start/running, process 52226
user@ubuntu-1404-server-amd64-dist:/var/lib/tomcat7/common/lib$ mysql -u orbeon -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)
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 orbeon;
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> describe orbeon_form_data;
+--------------------+--------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------------------+-----------------------------+
| created | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| last_modified_time | timestamp | NO | | 0000-00-00 00:00:00 | |
| last_modified_by | varchar(255) | YES | | NULL | |
| username | varchar(255) | YES | | NULL | |
| groupname | varchar(255) | YES | | NULL | |
| app | varchar(255) | YES | | NULL | |
| form | varchar(255) | YES | | NULL | |
| form_version | int(11) | NO | | NULL | |
| document_id | varchar(255) | YES | | NULL | |
| draft | char(1) | NO | | NULL | |
| deleted | char(1) | NO | | NULL | |
| xml | mediumtext | YES | | NULL | |
+--------------------+--------------+------+-----+---------------------+-----------------------------+
12 rows in set (0.00 sec)
mysql> insert into orbeon_form_data(form) values('This is a test');
Query OK, 1 row affected, 3 warnings (0.13 sec)
mysql> select * from orbeon_form_data;
+---------------------+---------------------+------------------+----------+-----------+------+----------------+--------------+-------------+-------+---------+------+
| created | last_modified_time | last_modified_by | username | groupname | app | form | form_version | document_id | draft | deleted | xml |
+---------------------+---------------------+------------------+----------+-----------+------+----------------+--------------+-------------+-------+---------+------+
| 2015-09-24 07:30:16 | 0000-00-00 00:00:00 | NULL | NULL | NULL | NULL | This is a test | 0 | NULL | | | NULL |
+---------------------+---------------------+------------------+----------+-----------+------+----------------+--------------+-------------+-------+---------+------+
1 row in set (0.02 sec)
mysql> delete from orbeon_form_data where form='This is a test';
Query OK, 1 row affected (0.02 sec)
mysql> exit
Bye
user@ubuntu-1404-server-amd64-dist:/var/lib/tomcat7/common/lib$
Maybe, my context.xml is not properly constructed/located?
user@ubuntu-1404-server-amd64-dist:/var/lib/tomcat7/webapps/orbeon/META-INF$ cat context.xml
<Context>
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="**********"
url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&characterEncoding=UTF8"/>
</Context>
Locked
