Internal server error occured

7 replies [Last post]

Sat, 12/01/2012 - 01:03

mathieu_b_1

Joined: 12/01/2012

Points: 10

Hello,

First of all, I must say that i'm a developer, but the installation of Kaltura CE (php) wasn't made by me.

It happened some times that we had problems while trying to upload files to kaltura. When I checked the inspector tools on chrome, the error :

Fatal error: Uncaught exception 'KalturaException' with message 'Internal server error occured' in /home/baladode/public_html/application/third_party/mediaAPI_v3/KalturaClientBase.php:457
Stack trace:
#0 /home/baladode/public_html/application/third_party/mediaAPI_v3/KalturaClient.php(1553): KalturaClientBase->throwExceptionIfError(Array)
#1 /home/baladode/public_html/application/libraries/KalturaUtilities.php(257): KalturaMediaService->addFromUrl(Object(KalturaMediaEntry), 'http://upload.b...')
#2 /home/baladode/public_html/application/controllers/uploadContent.php(118): KalturaUtilities->addEntry('eVuGSeVZq8.png', 'fef', 'img', '12', 9052)
#3 [internal function]: UploadContent->addContent()
#4 /home/baladode/public_html/system/core/CodeIgniter.php(339): call_user_func_array(Array, Array)
#5 /home/baladode/public_html/index.php(201): require_once('/home/baladode/...')
#6 {main}
thrown in /home/baladode/public_html/application/third_party/mediaAPI_v3/KalturaClientBase.php on line 457

The times it happened, it apparently fixes itself without doing anything...

But today, it happened again and I tried to go in the Publisher tools console, but the content tab also gives me "Internal server error occured".

Like I said, i'm really not familiar with Kaltura, and i'm not use to do "server things", so I'm a little bit lost right now.

I'm asking you for some help. If someone could give me an hint, or eventually go to our server to fix this and make sure everything works alright. We can discuss about that work if you are in and you are familiar with Kaltura.

Sat, 12/01/2012 - 01:45

mathieu_b_1

Joined: 12/01/2012

Points: 10

To add to the issue, I tried to restart sphinx and populate using the populate_log

Since then, the kaltura_sphinx_populate.log keep logging

[2012-11-30 20:32:48]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-11-30 20:32:53]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-11-30 20:32:58]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)

The server is in production, so I don't want to mess up anything or lose any media...

Thanks

Sun, 12/02/2012 - 07:16

oferc

Joined: 07/19/2009

Points: 333

Stupid question: is your mysql server running?

Sun, 12/02/2012 - 17:55

mathieu_b_1

Joined: 12/01/2012

Points: 10

Yes it is! I had my server investigated by the hosting company, and they told me mysql was running normally.

Sun, 12/02/2012 - 21:23

oferc

Joined: 07/19/2009

Points: 333

1. Can you take the connection string properties from the kConfLocal
and create a small php program that uses the same param and validate the connection?

2. Are there any other errors in the logs?

3. In kaltura instructions (pre install), there are dome setting for MySql, Have they been set?

Sun, 12/02/2012 - 23:03

mathieu_b_1

Joined: 12/01/2012

Points: 10

Hello oferc,

First take for the time you're taking to help me.

1. I'm not really sure what to do here. I'm really not experienced with this Kaltura thing and also not experienced at all with server side programmation. As we are in production right now, I fear to lose datas by doing bad manipulation.

2. The logs are as follow :

KGenericBatchMgr.log - size is getting bigger every seconds...as it's logging things continuously, here's an example :

2012-12-02 17:55:42 [921332764] [BATCH] [KGenericScheduler->spawn] INFO: Executing KScheduleHelper [0]
2012-12-02 17:55:42 [921332764] [BATCH] [KProcessWrapper->__construct] DEBUG: Now executing [/usr/local/bin/php batches/KScheduleHelperExe.php TzoyMDoiS1NjaGVkdWxhclRhc2tDb25maWciOjM4OntzOjI6ImlkIjtzOjM6IjE0MCI7czo0OiJuYW1lIjtzOjE1OiJLU2NoZWR1bGVIZWxwZXIiO3M6NDoidHlwZSI7czoxNToiS1NjaGVkdWxlSGVscGVyIjtzOjIwOiJtYXhpbXVtRXhlY3V0aW9uVGltZSI7czozOiIzMDAiO3M6MTI6ImZyaWVuZGx5TmFtZSI7czoxNToiU2NoZWR1bGUgSGVscGVyIjtzOjE0OiJtYXhKb2JzRWFjaFJ1biI7TjtzOjEwOiJzY3JpcHRQYXRoIjtzOjMwOiJiYXRjaGVzL0tTY2hlZHVsZUhlbHBlckV4ZS5waHAiO3M6MTA6InNjcmlwdEFyZ3MiO3M6MDoiIjtzOjEyOiJtYXhJbnN0YW5jZXMiO3M6MToiMSI7czoyMToic2xlZXBCZXR3ZWVuU3RvcFN0YXJ0IjtzOjI6IjE1IjtzOjE3OiJzdGFydEZvclF1ZXVlU2l6ZSI7czoxOiIwIjtzOjY6ImVuYWJsZSI7czoxOiIxIjtzOjk6ImF1dG9TdGFydCI7czoxOiIxIjtzOjg6ImFmZmluaXR5IjtOO3M6MTU6ImZpbGVFeGlzdFJldGllcyI7TjtzOjE3OiJmaWxlRXhpc3RJbnRlcnZhbCI7TjtzOjEzOiJiYXNlTG9jYWxQYXRoIjtOO3M6MTQ6ImJhc2VTaGFyZWRQYXRoIjtOO3M6MTc6ImJhc2VUZW1wTG9jYWxQYXRoIjtOO3M6MTg6ImJhc2VUZW1wU2hhcmVkUGF0aCI7TjtzOjE5OiJtaW5DcmVhdGVkQXRNaW51dGVzIjtOO3M6NjoicGFyYW1zIjtPOjExOiJaZW5kX0NvbmZpZyI6ODp7czoyMjoiACoAX2FsbG93TW9kaWZpY2F0aW9ucyI7YjowO3M6OToiACoAX2luZGV4IjtpOjA7czo5OiIAKgBfY291bnQiO2k6MztzOjg6IgAqAF9kYXRhIjthOjM6e3M6MjI6ImNvbW1hbmRSZXN1bHRzRmlsZVBhdGgiO3M6MTE6ImNvbnRyb2wuYXJjIjtzOjE0OiJzdGF0dXNGaWxlUGF0aCI7czoxMDoic3RhdHVzLmxvZyI7czoxOToiY29uZmlnSXRlbXNGaWxlUGF0aCI7czoxMDoiY29uZmlnLmxvZyI7fXM6MjE6IgAqAF9za2lwTmV4dEl0ZXJhdGlvbiI7TjtzOjE3OiIAKgBfbG9hZGVkU2VjdGlvbiI7TjtzOjExOiIAKgBfZXh0ZW5kcyI7YTowOnt9czoyMDoiACoAX2xvYWRGaWxlRXJyb3JTdHIiO047fXM6NjoiZmlsdGVyIjtOO3M6MzE6IgBLU2NoZWR1bGFyVGFza0NvbmZpZwB0YXNrSW5kZXgiO2k6MDtzOjMzOiIAS1NjaGVkdWxhclRhc2tDb25maWcAc2NoZWR1bGVySWQiO3M6MToiMSI7czozNToiAEtTY2hlZHVsYXJUYXNrQ29uZmlnAHNjaGVkdWxlck5hbWUiO3M6MTc6IkRlZmF1bHQgU2NoZWR1bGVyIjtzOjMxOiIAS1NjaGVkdWxhclRhc2tDb25maWcAcGFydG5lcklkIjtzOjI6Ii0xIjtzOjMyOiIAS1NjaGVkdWxhclRhc2tDb25maWcAc2VydmljZVVybCI7czozMzoiaHR0cDovL21lZGlhLmJhbGFkb2RlY291dmVydGUuY29tIjtzOjI4OiIAS1NjaGVkdWxhclRhc2tDb25maWcAc2VjcmV0IjtzOjMyOiIwN2Q3ZjEwOTI3MWEwNWY1MDZkZjJhMTlhNTJkYmU0ZiI7czozMzoiAEtTY2hlZHVsYXJUYXNrQ29uZmlnAGN1cmxUaW1lb3V0IjtzOjM6IjE4MCI7czoyOToiAEtTY2hlZHVsYXJUYXNrQ29uZmlnAGR3aFBhdGgiO3M6MjQ6Ii9vcHQva2FsdHVyYS9sb2cvZHdoLmxvZyI7czozMDoiAEtTY2hlZHVsYXJUYXNrQ29uZmlnAGhvc3ROYW1lIjtzOjI4OiJjbC10MDYyLTQ4MmNsLnByaXZhdGVkbnMuY29tIjtzOjMwOiIAS1NjaGVkdWxhclRhc2tDb25maWcAdGltZXpvbmUiO3M6MTY6IkFtZXJpY2EvTmV3X1lvcmsiO3M6MzM6IgBLU2NoZWR1bGFyVGFza0NvbmZpZwBjb21tYW5kc0RpciI7czo4OiJjb250cm9scyI7czozMToiAEtTY2hlZHVsYXJUYXNrQ29uZmlnAHVzZVN5c2xvZyI7czoxOiIwIjtzOjM3OiIAS1NjaGVkdWxhclRhc2tDb25maWcAcXVldWVGaWx0ZXJzRGlyIjtzOjc6ImZpbHRlcnMiO3M6MzA6IgBLU2NoZWR1bGFyVGFza0NvbmZpZwBpbml0T25seSI7YjowO3M6MzM6IgBLU2NoZWR1bGFyVGFza0NvbmZpZwBtYXhJZGxlVGltZSI7Tjt9 '[1749680274]' >> /opt/kaltura/log/batch//kschedulehelper-0-2012-12-02.log 2>&1], [Array]

kaltura_sphinx_poulate - always logging the same error :

[2012-12-02 17:55:29]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-12-02 17:55:34]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-12-02 17:55:39]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-12-02 17:55:44]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-12-02 17:55:49]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)
[2012-12-02 17:55:54]SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)

kaltura_api_v3 :

2012-12-02 18:01:02 [72.55.156.219] [180515062] [API] [KalturaFrontController->errorHandler] NOTICE: /opt/kaltura/app/infra/general/myCache.class.php line 38 - Memcache::connect(): Server media.baladodecouverte.com (tcp 11211, udp 0) failed with: Connection refused (111)
2012-12-02 18:01:02 [72.55.156.219] [180515062] [API] [KalturaFrontController->errorHandler] WARN: /opt/kaltura/app/infra/general/myCache.class.php line 38 - Memcache::connect(): Can't connect to media.baladodecouverte.com:11211, Connection refused (111)
2012-12-02 18:01:02 [72.55.156.219] [180515062] [API] [kLog::log] NOTICE: ERROR: Error while trying to connect to memcache. Make sure it is properly running on media.baladodecouverte.com:11211

I'm really confuse right now, like I said, I'm a bit anxious about losing any datas, and Kaltura is really foreign to me.

Mon, 12/03/2012 - 06:23

oferc

Joined: 07/19/2009

Points: 333

Did someone change DB security permissions?
Try to go o kConfLocal whee all the connection string are, and change from 127.0.0.1 to localhost (in the sphinx connection string), maybe this will help

Mon, 12/03/2012 - 14:20

mathieu_b_1

Joined: 12/01/2012

Points: 10

I just tried that, but didn't work. As for the DB security permisssions, not that I know, no changes were made.