Error in insertContent.php [Solved]

Community Forums Backend Server Support
1

Hello always have the same error in one server but not in my virtual machine
the error is when installing a first time kaltura, on the

Output for /opt/kaltura/app/deployment/base/scripts/insertContent.php

step, I have the following error:

execution time for [http://my.local.server.com/api_v3/index.php?service=multirequest]: [0.27150106430054]
Executing failed for request #2 with error [User role not found]
PHP Warning: Missing argument 3 for KalturaException::__construct(), called in /opt/kaltura/app/tests/standAloneClient/exec.php on line 351 and defined in /opt/kaltura/app/tests/lib/KalturaClientBase.php on line 1180
PHP Notice: Undefined variable: arguments in /opt/kaltura/app/tests/lib/KalturaClientBase.php on line 1183
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘User role not found’ in /opt/kaltura/app/tests/standAloneClient/exec.php:351
Stack trace:
.#0 {main}
thrown in /opt/kaltura/app/tests/standAloneClient/exec.php on line 351

maybe some php libreries are missing?

server is RHEL 6.7

php packages installed are:
php.x86_64 5.3.3-46.el6_6 @updates
php-cli.x86_64 5.3.3-46.el6_6 @updates
php-common.x86_64 5.3.3-46.el6_6 @updates
php-gd.x86_64 5.3.3-46.el6_6 @updates
php-ldap.x86_64 5.3.3-46.el6_6 @updates
php-mbstring.x86_64 5.3.3-46.el6_6 @updates
php-mcrypt.x86_64 5.3.3-4 @Kaltura
php-mysql.x86_64 5.3.3-46.el6_6 @updates
php-pdo.x86_64 5.3.3-46.el6_6 @updates
php-pear.noarch 1:1.9.4-4.el6 @base
php-pecl-apc.x86_64 3.1.9-2.el6 @base
php-pecl-memcached.x86_64 2.1.0-1 @Kaltura
php-pecl-ssh2.x86_64 0.12-2 @Kaltura
php-xml.x86_64 5.3.3-46.el6_6 @updates

any clues?

thank you

2

I’m suspecting that is a port problem,
maybe 8080 is not open and its needed for curl.

— edit
well it wasn’t that,
I have various internal server error ocurred :frowning:

3

Hi Bryan,

Firstly, did you indeed verify a curl to $SERVICE_URL/api_v3 works? it is a must for deployment to succeed.
Secondly, assuming that works, I suggest you drop your DB and redeploy, if it fails, look at the deployment logs and lets see exactly what’s failing.

4

Jess,

thank you very much again for your time and help,
if someone has the same problem
it was the mysql settings causing the problem,
I reset it to a basic config and now its working

I had this if you whant to check what was wrong:

.#Default/Kickstart Configuration

[mysqld]
max_allowed_packet = 16M
open_files_limit = 20000
lower_case_table_names = 1
innodb_file_per_table

datadir=/var/lib/mysql
tmpdir=/var/lib/mysqltmp
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-name-resolve
table_cache=2048
thread_cache_size=16
back_log=100
max_connect_errors=10000
open-files-limit=20000
interactive_timeout=3600
wait_timeout=600
tmp_table_size=64M
max_heap_table_size=64M
query_cache_size=32M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=8M
join_buffer_size=1M
key_buffer_size=64M
myisam_sort_buffer_size=64M
innodb_log_file_size = 32M
innodb_buffer_pool_size=16M
server-id=718215
auto_increment_increment=10
auto_increment_offset=1

[mysql.server]
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open-files-limit=65535

EDIT:

I found the problem, these two was the problem:
auto_increment_increment=10
auto_increment_offset=1

5

Hi Bryan,

Glad it works now. What MySQL package were you using that come with:
auto_increment_increment=10
auto_increment_offset=1
set this way by default?

Thanks,

6

no, I added that
so the partner increases by 10 instead of 1,
that was my bad there sorry, :frowning:

7

Hi Bryan,

Sorry but we rely on system partners having specific IDs, i.e:
mysql> select id,partner_name from partner where id<100;
±—±---------------------+
| id | partner_name |
±—±---------------------+
| -6 | Play-Server |
| -5 | Media |
| -4 | Monitor |
| -3 | Hosted Pages |
| -2 | Admin Console |
| -1 | Batch |
| 0 | Global |
| 99 | Template KMC account |
±—±---------------------+

So, that cannot be done.

8

Right!!!

I can add the increase by 10 AFTER the installation is done,
this way wont cause problems

9

To be honest, I cannot guarantee that… there MAY be other code pieces that rely on this so I would advise against it.