Kaltura-base configuration halts due to timezone

SrikarVR · June 14, 2017, 6:24pm

Dear Kaltura experts -

I am new to Kaltura and have been trying to install v12.17. During the course of installation I came across number of issues due to which I wanted to clean-up and do fresh installation. However, I am stuck at a step where the installation does not proceed further during kaltura-base configuration. Screen hangs asking for Timezone and for whatever value entered it does not progress further.

If I close the screen and try to uninstall/reinstall on the setup created so far, I come across below message.

E: dpkg was interrupted, you must manually run ‘sudo dpkg --configure -a’ to correct the problem.
E: Couldn’t rebuild package cache
E: dpkg was interrupted, you must manually run ‘sudo dpkg --configure -a’ to correct the problem.

W: Could not lock the cache file; this usually means that dpkg or another apt tool is already installing packages. Opening in read-only mode; any changes you make to the states of packages will NOT be preserved!

If I run the “sudo dpkg --configure -a” by removing lock files it halts again at timezone not accepting any value. Please I request your guidance and help for resolving my issue. I have already spent lot of time without any progress .

I did follow steps given in thread - Kaltura-base configuration enter timezone hangs and removed the dangling symlinks in /etc/alternatives/php, but this also did not help.

Environment - Ubuntu 14.04

Regards
Srikar

jess · June 14, 2017, 7:22pm

Hi @SrikarVR,

The kaltura-base package verifies the TZ input is valid with:

php -r "if (timezone_open('$TIME_ZONE') === false){exit(1);}

You can see that in /var/lib/dpkg/info/kaltura-base.postinst, line 273.

The PHP CLI binary is a dependency provided by either one of these packages:
php5-cli | php-cli | kaltura-php7-cli

which are declared in the kaltura-base deb spec.

What happens when you run that PHP command from the shell?

SrikarVR · June 14, 2017, 8:21pm

Hi Jess - Thanks for quick response!

Kindly find my observation below. Using “php5” instead of “php” has help to move the process forward.

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# php -r "if (timezone_open(’$TIME_ZONE’) === false){exit(1); echo ‘worked’;}"
The program ‘php’ is currently not installed. You can install it by typing:
apt-get install php5-cli

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# php5 -r “if (timezone_open(’$TIME_ZONE’) === false){exit(1); echo ‘worked’;}”

By changing “php” to “php5” in line 272 of kaltura-base.postinst moved the process moved forward and I have come across the following message. With this change, I have got a doubt - Should I now update all pre/postinst scripts with “php5” instead of “php” Or is this a bug we have come across?

root@684386-slrs01va9f1sv01:/var/lib/dpkg/info# dpkg --configure -a
Setting up kaltura-base (12.17.0-2) …

apache2 is running
Stopping web server apache2 *
Stopping daemon monitor monit [ OK ]
dpkg: error processing package kaltura-base (–configure):
subprocess installed post-installation script returned error exit status 127
Errors were encountered while processing:
kaltura-base

Regards - Srikar

jess · June 15, 2017, 9:27am

Hello @SrikarVR,

Changing kaltura-base.postinst is not a good solution, ‘php’ is called from many scripts.
Like I said, kaltura-base requires one of these packages to be installed:

php5-cli | php-cli | kaltura-php7-cli

Any one of these calls the update-alternatives util in its postinst script so that the /usr/bin/php symlink is created.
For Ubuntu 14.04, php5-cli should have been installed and then /var/lib/dpkg/info/php5-cli.postinst should have executed:

    update-alternatives \
        --install /usr/bin/php php /usr/bin/php5 50 \
       --slave /usr/share/man/man1/php.1.gz php.1.gz /usr/share/man/man1/php5.1.gz

so that:

ll /usr/bin/php
lrwxrwxrwx 1 root root  /usr/bin/php -> /etc/alternatives/php*
ll /etc/alternatives/php
/etc/alternatives/php -> /usr/bin/php5

From your output, it looks as though the php5-cli package is not installed so I wonder what does satisfy that dep. What’s the output for:

dpkg -S `which php5`

?

SrikarVR · June 16, 2017, 6:23am

Hi Jess - Thanks for your response. As suggested, I have run update-alternatives and following is the output.

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# update-alternatives --install /usr/bin/php php /usr/bin/php5 50 --slave /usr/share/man/man1/php.1.gz php.1.gz /usr/share/man/man1/php5.1.gz
update-alternatives: warning: alternative /opt/kaltura/bin/php7 (part of link group php) doesn’t exist; removing from list of alternatives
update-alternatives: using /usr/bin/php5 to provide /usr/bin/php (php) in auto mode

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# dpkg -S which php5
php5-cli: /usr/bin/php5

Post this I could proceed again with re-installation and I get the following message in the trail mail below. I can access Kaltura start page but I get error access admin page and KMC give error while login. Refer to the screenshots. I have not changed any of the ports and installed with default ports provided by installer, so presume there should not be any conflict with ports.

3 issues:

Admin console is not accessible
KMC does not allow login
kaltura-nginx is not getting processed

The following partially installed packages will be configured:
kaltura-nginx
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up kaltura-nginx (1.12-3) …
System start/stop links for /etc/init.d/kaltura-nginx already exist.
Restarting nginx: /opt/kaltura/nginx/sbin/nginx: error while loading shared libraries: libavcodec.so.57: cannot open shared object file: No such file or directory
invoke-rc.d: initscript kaltura-nginx, action “restart” failed.
dpkg: error processing package kaltura-nginx (–configure):
subprocess installed post-installation script returned error exit status 127
Processing triggers for libc-bin (2.19-0ubuntu6.11) …
Errors were encountered while processing:
kaltura-nginx
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up kaltura-nginx (1.12-3) …
System start/stop links for /etc/init.d/kaltura-nginx already exist.
Restarting nginx: /opt/kaltura/nginx/sbin/nginx: error while loading shared libraries: libavcodec.so.57: cannot open shared object file: No such file or directory
invoke-rc.d: initscript kaltura-nginx, action “restart” failed.
dpkg: error processing package kaltura-nginx (–configure):
subprocess installed post-installation script returned error exit status 127
Processing triggers for libc-bin (2.19-0ubuntu6.11) …
Errors were encountered while processing:
kaltura-nginx

Regards - Srikar

jess · June 16, 2017, 7:58am

Hello @SrikarVR,

First evident issue is the missing libavcodec.so.57. This is provided by kaltura-ffmepg which obviously didn’t get installed.
Try to install it manually with:
# aptitude install kaltura-ffmpeg
and see why it’s failing. My guess is you’re missing some extra repositories, perhaps the multiverse one which the install script does try to enable. Once you run this manually and get the error, we’ll know for sure and we can move towards a resolution.

SrikarVR · June 16, 2017, 10:01am

Hi Jess - I ran the command “aptitude install kaltura-ffmpeg” and see below error coming up. It circles back to partially installed package kaltura-nginx.

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# aptitude install kaltura-ffmpeg
The following partially installed packages will be configured:
kaltura-nginx
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up kaltura-nginx (1.12-3) …
System start/stop links for /etc/init.d/kaltura-nginx already exist.
Restarting nginx: /opt/kaltura/nginx/sbin/nginx: error while loading shared libraries: libavcodec.so.57: cannot open shared object file: No such file or directory
invoke-rc.d: initscript kaltura-nginx, action “restart” failed.
dpkg: error processing package kaltura-nginx (–configure):
subprocess installed post-installation script returned error exit status 127
Processing triggers for libc-bin (2.19-0ubuntu6.11) …
Errors were encountered while processing:
kaltura-nginx
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up kaltura-nginx (1.12-3) …
System start/stop links for /etc/init.d/kaltura-nginx already exist.
Restarting nginx: /opt/kaltura/nginx/sbin/nginx: error while loading shared libraries: libavcodec.so.57: cannot open shared object file: No such file or directory
invoke-rc.d: initscript kaltura-nginx, action “restart” failed.
dpkg: error processing package kaltura-nginx (–configure):
subprocess installed post-installation script returned error exit status 127
Processing triggers for libc-bin (2.19-0ubuntu6.11) …
Errors were encountered while processing:
kaltura-nginx

Regards - Srikar

jess · June 16, 2017, 10:32am

Hi @SrikarVR,

From this, it appears as though kaltura-ffmpeg is already installed and yet libavcodec.so.57 is not found…
What’s the output for these commands?
# dpkg -S libavcodec.so.57
# dpkg -L kaltura-ffmpeg|grep so
# ldd /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
# ldd /opt/kaltura/nginx/sbin/nginx

SrikarVR · June 16, 2017, 10:50am

Hi Jess - Kindly find the output of commands suggested:

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# dpkg -S libavcodec.so.57
kaltura-ffmpeg: /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57.64.100
kaltura-ffmpeg: /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# dpkg -L kaltura-ffmpeg|grep so
/opt/kaltura/ffmpeg-3.2/lib/libavformat.so.57.56.100
/opt/kaltura/ffmpeg-3.2/lib/libpostproc.so.54.1.100
/opt/kaltura/ffmpeg-3.2/lib/libavdevice.so.57.1.100
/opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57.64.100
/opt/kaltura/ffmpeg-3.2/lib/libavutil.so.55.34.100
/opt/kaltura/ffmpeg-3.2/lib/libavfilter.so.6.65.100
/opt/kaltura/ffmpeg-3.2/lib/libswscale.so.4.2.100
/opt/kaltura/ffmpeg-3.2/lib/libswresample.so.2.3.100
/opt/kaltura/ffmpeg-3.2/lib/libpostproc.so.54
/opt/kaltura/ffmpeg-3.2/lib/libavformat.so.57
/opt/kaltura/ffmpeg-3.2/lib/libswresample.so
/opt/kaltura/ffmpeg-3.2/lib/libavutil.so.55
/opt/kaltura/ffmpeg-3.2/lib/libavfilter.so.6
/opt/kaltura/ffmpeg-3.2/lib/libswscale.so.4
/opt/kaltura/ffmpeg-3.2/lib/libavcodec.so
/opt/kaltura/ffmpeg-3.2/lib/libavformat.so
/opt/kaltura/ffmpeg-3.2/lib/libswresample.so.2
/opt/kaltura/ffmpeg-3.2/lib/libavdevice.so
/opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
/opt/kaltura/ffmpeg-3.2/lib/libavdevice.so.57
/opt/kaltura/ffmpeg-3.2/lib/libpostproc.so
/opt/kaltura/ffmpeg-3.2/lib/libswscale.so
/opt/kaltura/ffmpeg-3.2/lib/libavfilter.so
/opt/kaltura/ffmpeg-3.2/lib/libavutil.so
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# ldd /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
linux-vdso.so.1 => (0x00007fff5975e000)
libswresample.so.2 => not found
libavutil.so.55 => not found
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f6611755000)
libxvidcore.so.4 => /usr/lib/x86_64-linux-gnu/libxvidcore.so.4 (0x00007f6611417000)
libx265.so.87 => /usr/lib/x86_64-linux-gnu/libx265.so.87 (0x00007f6610535000)
libx264.so.148 => /usr/lib/x86_64-linux-gnu/libx264.so.148 (0x00007f6610175000)
libvpx.so.1 => /usr/lib/x86_64-linux-gnu/libvpx.so.1 (0x00007f660fd96000)
libvorbisenc.so.2 => /usr/lib/x86_64-linux-gnu/libvorbisenc.so.2 (0x00007f660f8c7000)
libvorbis.so.0 => /usr/lib/x86_64-linux-gnu/libvorbis.so.0 (0x00007f660f69a000)
libtheoraenc.so.1 => /usr/lib/x86_64-linux-gnu/libtheoraenc.so.1 (0x00007f660f45a000)
libtheoradec.so.1 => /usr/lib/x86_64-linux-gnu/libtheoradec.so.1 (0x00007f660f241000)
libspeex.so.1 => /usr/lib/x86_64-linux-gnu/libspeex.so.1 (0x00007f660f028000)
libschroedinger-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libschroedinger-1.0.so.0 (0x00007f660ed64000)
libopenjpeg.so.2 => /usr/lib/x86_64-linux-gnu/libopenjpeg.so.2 (0x00007f660eb42000)
libopencore-amrwb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrwb.so.0 (0x00007f660e92e000)
libopencore-amrnb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrnb.so.0 (0x00007f660e704000)
libmp3lame.so.0 => /usr/lib/x86_64-linux-gnu/libmp3lame.so.0 (0x00007f660e477000)
libgsm.so.1 => /usr/lib/x86_64-linux-gnu/libgsm.so.1 (0x00007f660e269000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f660df63000)
libz.so.1 => /usr/local/lib/libz.so.1 (0x00007f660dd48000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f660db2a000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f660d762000)
/lib64/ld-linux-x86-64.so.2 (0x00007f6613246000)
libnuma.so.1 => /usr/lib/x86_64-linux-gnu/libnuma.so.1 (0x00007f660d557000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f660d253000)
libogg.so.0 => /usr/lib/x86_64-linux-gnu/libogg.so.0 (0x00007f660d04a000)
liborc-0.4.so.0 => /usr/lib/x86_64-linux-gnu/liborc-0.4.so.0 (0x00007f660cdc8000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f660cbb2000)
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# ldd /opt/kaltura/nginx/sbin/nginx
linux-vdso.so.1 => (0x00007ffeeaa7b000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fed02cbe000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fed02aa0000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007fed02867000)
libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007fed0248b000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fed02283000)
libavcodec.so.57 => not found
libavutil.so.55 => not found
libavfilter.so.6 => not found
libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007fed01f1c000)
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007fed01cde000)
libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007fed01a7f000)
libz.so.1 => /usr/local/lib/libz.so.1 (0x00007fed01864000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fed0149c000)
/lib64/ld-linux-x86-64.so.2 (0x00007fed02ec2000)
liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007fed0127a000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fed00f74000)
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura#

Regards - Srikar

jess · June 16, 2017, 11:03am

Hi @SrikarVR,

Something is off here… all the missing SOs, i.e:

libswresample.so.2 => not found
libavutil.so.55 => not found
libavcodec.so.57 => not found
libavutil.so.55 => not found
libavfilter.so.6 => not found

Are part of the kaltura-ffmpeg package. In order for the dynamic linker to find them, the following file is created:
/etc/ld.so.conf.d/kaltura-ffmpeg.conf
Then, /sbin/ldconfig is called.

Can you confirm that you have this file? and also try to run ldconfig manually and then re-run:

# ldd /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57

All libs should be found, here is an example of a valid output from my own machine:

$ ldd /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
        linux-vdso.so.1 =>  (0x00007ffc897b7000)
        libswresample.so.2 => /opt/kaltura/ffmpeg-3.2/lib/libswresample.so.2 (0x00007f6c9e9fb000)
        libavutil.so.55 => /opt/kaltura/ffmpeg-3.2/lib/libavutil.so.55 (0x00007f6c9e762000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f6c9e55e000)
        libva.so.1 => /usr/lib/x86_64-linux-gnu/libva.so.1 (0x00007f6c9e342000)
        libxvidcore.so.4 => /usr/lib/x86_64-linux-gnu/libxvidcore.so.4 (0x00007f6c9e02e000)
        libx265.so.79 => /usr/lib/x86_64-linux-gnu/libx265.so.79 (0x00007f6c9d40f000)
        libx264.so.148 => /usr/lib/x86_64-linux-gnu/libx264.so.148 (0x00007f6c9d06b000)
        libvpx.so.3 => /usr/lib/x86_64-linux-gnu/libvpx.so.3 (0x00007f6c9cc47000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f6c9c93e000)
        libvorbisenc.so.2 => /usr/lib/x86_64-linux-gnu/libvorbisenc.so.2 (0x00007f6c9c695000)
        libvorbis.so.0 => /usr/lib/x86_64-linux-gnu/libvorbis.so.0 (0x00007f6c9c469000)
        libtheoraenc.so.1 => /usr/lib/x86_64-linux-gnu/libtheoraenc.so.1 (0x00007f6c9c22a000)
        libtheoradec.so.1 => /usr/lib/x86_64-linux-gnu/libtheoradec.so.1 (0x00007f6c9c010000)
        libspeex.so.1 => /usr/lib/x86_64-linux-gnu/libspeex.so.1 (0x00007f6c9bdf7000)
        libschroedinger-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libschroedinger-1.0.so.0 (0x00007f6c9bb22000)
        libopenjpeg.so.5 => /usr/lib/x86_64-linux-gnu/libopenjpeg.so.5 (0x00007f6c9b8ff000)
        libopencore-amrwb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrwb.so.0 (0x00007f6c9b6eb000)
        libopencore-amrnb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrnb.so.0 (0x00007f6c9b4c0000)
        libmp3lame.so.0 => /usr/lib/x86_64-linux-gnu/libmp3lame.so.0 (0x00007f6c9b24b000)
        libgsm.so.1 => /usr/lib/x86_64-linux-gnu/libgsm.so.1 (0x00007f6c9b03d000)
        liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f6c9ae1b000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f6c9ac01000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f6c9a9e4000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f6c9a61b000)
        libvdpau.so.1 => /usr/lib/x86_64-linux-gnu/libvdpau.so.1 (0x00007f6c9a417000)
        libva-drm.so.1 => /usr/lib/x86_64-linux-gnu/libva-drm.so.1 (0x00007f6c9a214000)
        libva-x11.so.1 => /usr/lib/x86_64-linux-gnu/libva-x11.so.1 (0x00007f6c9a00e000)
        libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f6c99cd4000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f6ca0561000)
        libnuma.so.1 => /usr/lib/x86_64-linux-gnu/libnuma.so.1 (0x00007f6c99ac9000)
        libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f6c99747000)
        libogg.so.0 => /usr/lib/x86_64-linux-gnu/libogg.so.0 (0x00007f6c9953e000)
        liborc-0.4.so.0 => /usr/lib/x86_64-linux-gnu/liborc-0.4.so.0 (0x00007f6c992be000)
        libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f6c990ac000)
        libdrm.so.2 => /usr/lib/x86_64-linux-gnu/libdrm.so.2 (0x00007f6c98e9d000)
        libXfixes.so.3 => /usr/lib/x86_64-linux-gnu/libXfixes.so.3 (0x00007f6c98c97000)
        libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f6c98a75000)
        libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f6c9885f000)
        libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f6c9865b000)
        libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f6c98455000)

SrikarVR · June 16, 2017, 12:08pm

Hi Jess - Yes, the file exists and I ran the commands. Following is the output. Now it seems to have found the libraries.

root@684386-slrs01va9f1sv01:/etc/ld.so.conf.d# ll
total 44
drwxr-xr-x 2 root root 4096 Jun 14 03:52 ./
drwxr-xr-x 129 root root 12288 Jun 16 09:36 …/
-rw-rw-r-- 1 root root 38 Mar 24 2014 fakeroot-x86_64-linux-gnu.conf
-rw-r–r-- 1 root root 240 Jun 14 08:13 kaltura-ffmpeg-aux.conf
-rw-r–r-- 1 root root 224 Jun 14 08:13 kaltura-ffmpeg.conf
-rw-r–r-- 1 root root 44 Aug 9 2009 libc.conf
-rw-r–r-- 1 root root 90 Aug 17 2013 vmware-tools-guestlib.conf
-rw-r–r-- 1 root root 42 Aug 17 2013 vmware-tools-plugin_deployPkg.conf
-rw-r–r-- 1 root root 68 Apr 12 2014 x86_64-linux-gnu.conf
lrwxrwxrwx 1 root root 42 Jun 1 03:36 x86_64-linux-gnu_GL.conf -> /etc/alternatives/x86_64-linux-gnu_gl_conf
root@684386-slrs01va9f1sv01:/etc/ld.so.conf.d# chmod +x *
root@684386-slrs01va9f1sv01:/etc/ld.so.conf.d# ll
total 44
drwxr-xr-x 2 root root 4096 Jun 14 03:52 ./
drwxr-xr-x 129 root root 12288 Jun 16 09:36 …/
-rwxrwxr-- 1 root root 38 Mar 24 2014 fakeroot-x86_64-linux-gnu.conf*
-rwxr-xr-- 1 root root 240 Jun 14 08:13 kaltura-ffmpeg-aux.conf*
-rwxr-xr-- 1 root root 224 Jun 14 08:13 kaltura-ffmpeg.conf*
-rwxr-xr-- 1 root root 44 Aug 9 2009 libc.conf*
-rwxr-xr-- 1 root root 90 Aug 17 2013 vmware-tools-guestlib.conf*
-rwxr-xr-- 1 root root 42 Aug 17 2013 vmware-tools-plugin_deployPkg.conf*
-rwxr-xr-- 1 root root 68 Apr 12 2014 x86_64-linux-gnu.conf*
lrwxrwxrwx 1 root root 42 Jun 1 03:36 x86_64-linux-gnu_GL.conf -> /etc/alternatives/x86_64-linux-gnu_gl_conf*

root@684386-slrs01va9f1sv01:/etc/ld.so.conf.d# cd /sbin
root@684386-slrs01va9f1sv01:/sbin# ldconfig
root@684386-slrs01va9f1sv01:/sbin# cd /opt/_installable/kaltura/
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# ldd /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57
linux-vdso.so.1 => (0x00007ffea0117000)
libswresample.so.2 => /opt/kaltura/ffmpeg-3.2/lib/libswresample.so.2 (0x00007f3626d8a000)
libavutil.so.55 => /opt/kaltura/ffmpeg-3.2/lib/libavutil.so.55 (0x00007f3626af9000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f36268f5000)
libxvidcore.so.4 => /usr/lib/x86_64-linux-gnu/libxvidcore.so.4 (0x00007f36265b7000)
libx265.so.87 => /usr/lib/x86_64-linux-gnu/libx265.so.87 (0x00007f36256d5000)
libx264.so.148 => /usr/lib/x86_64-linux-gnu/libx264.so.148 (0x00007f3625315000)
libvpx.so.1 => /usr/lib/x86_64-linux-gnu/libvpx.so.1 (0x00007f3624f36000)
libvorbisenc.so.2 => /usr/lib/x86_64-linux-gnu/libvorbisenc.so.2 (0x00007f3624a67000)
libvorbis.so.0 => /usr/lib/x86_64-linux-gnu/libvorbis.so.0 (0x00007f362483a000)
libtheoraenc.so.1 => /usr/lib/x86_64-linux-gnu/libtheoraenc.so.1 (0x00007f36245fa000)
libtheoradec.so.1 => /usr/lib/x86_64-linux-gnu/libtheoradec.so.1 (0x00007f36243e1000)
libspeex.so.1 => /usr/lib/x86_64-linux-gnu/libspeex.so.1 (0x00007f36241c8000)
libschroedinger-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libschroedinger-1.0.so.0 (0x00007f3623f04000)
libopenjpeg.so.2 => /usr/lib/x86_64-linux-gnu/libopenjpeg.so.2 (0x00007f3623ce2000)
libopencore-amrwb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrwb.so.0 (0x00007f3623ace000)
libopencore-amrnb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrnb.so.0 (0x00007f36238a4000)
libmp3lame.so.0 => /usr/lib/x86_64-linux-gnu/libmp3lame.so.0 (0x00007f3623617000)
libgsm.so.1 => /usr/lib/x86_64-linux-gnu/libgsm.so.1 (0x00007f3623409000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f3623103000)
libz.so.1 => /usr/local/lib/libz.so.1 (0x00007f3622ee8000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f3622cca000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f3622902000)
libvdpau.so.1 => /usr/lib/x86_64-linux-gnu/libvdpau.so.1 (0x00007f36226fe000)
libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f36223c9000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f36221c1000)
/lib64/ld-linux-x86-64.so.2 (0x00007f3628899000)
libnuma.so.1 => /usr/lib/x86_64-linux-gnu/libnuma.so.1 (0x00007f3621fb6000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f3621cb2000)
libogg.so.0 => /usr/lib/x86_64-linux-gnu/libogg.so.0 (0x00007f3621aa9000)
liborc-0.4.so.0 => /usr/lib/x86_64-linux-gnu/liborc-0.4.so.0 (0x00007f3621827000)
libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f3621615000)
libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f36213f6000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f36211e0000)
libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f3620fdc000)
libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f3620dd6000)
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# ldd /opt/kaltura/nginx/sbin/nginx
linux-vdso.so.1 => (0x00007ffe21516000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f5dbbeca000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f5dbbcac000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f5dbba73000)
libcrypto.so.1.0.0 => /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 (0x00007f5dbb697000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f5dbb48f000)
libavcodec.so.57 => /opt/kaltura/ffmpeg-3.2/lib/libavcodec.so.57 (0x00007f5db9ba2000)
libavutil.so.55 => /opt/kaltura/ffmpeg-3.2/lib/libavutil.so.55 (0x00007f5db9911000)
libavfilter.so.6 => /opt/kaltura/ffmpeg-3.2/lib/libavfilter.so.6 (0x00007f5db93ba000)
libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007f5db9053000)
libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f5db8e15000)
libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f5db8bb6000)
libz.so.1 => /usr/local/lib/libz.so.1 (0x00007f5db899b000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f5db85d3000)
/lib64/ld-linux-x86-64.so.2 (0x00007f5dbc0ce000)
libswresample.so.2 => /opt/kaltura/ffmpeg-3.2/lib/libswresample.so.2 (0x00007f5db83b1000)
libxvidcore.so.4 => /usr/lib/x86_64-linux-gnu/libxvidcore.so.4 (0x00007f5db8073000)
libx265.so.87 => /usr/lib/x86_64-linux-gnu/libx265.so.87 (0x00007f5db7191000)
libx264.so.148 => /usr/lib/x86_64-linux-gnu/libx264.so.148 (0x00007f5db6dd1000)
libvpx.so.1 => /usr/lib/x86_64-linux-gnu/libvpx.so.1 (0x00007f5db69f2000)
libvorbisenc.so.2 => /usr/lib/x86_64-linux-gnu/libvorbisenc.so.2 (0x00007f5db6523000)
libvorbis.so.0 => /usr/lib/x86_64-linux-gnu/libvorbis.so.0 (0x00007f5db62f6000)
libtheoraenc.so.1 => /usr/lib/x86_64-linux-gnu/libtheoraenc.so.1 (0x00007f5db60b6000)
libtheoradec.so.1 => /usr/lib/x86_64-linux-gnu/libtheoradec.so.1 (0x00007f5db5e9d000)
libspeex.so.1 => /usr/lib/x86_64-linux-gnu/libspeex.so.1 (0x00007f5db5c84000)
libschroedinger-1.0.so.0 => /usr/lib/x86_64-linux-gnu/libschroedinger-1.0.so.0 (0x00007f5db59c0000)
libopenjpeg.so.2 => /usr/lib/x86_64-linux-gnu/libopenjpeg.so.2 (0x00007f5db579e000)
libopencore-amrwb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrwb.so.0 (0x00007f5db558a000)
libopencore-amrnb.so.0 => /usr/lib/x86_64-linux-gnu/libopencore-amrnb.so.0 (0x00007f5db5360000)
libmp3lame.so.0 => /usr/lib/x86_64-linux-gnu/libmp3lame.so.0 (0x00007f5db50d3000)
libgsm.so.1 => /usr/lib/x86_64-linux-gnu/libgsm.so.1 (0x00007f5db4ec5000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f5db4bbf000)
libvdpau.so.1 => /usr/lib/x86_64-linux-gnu/libvdpau.so.1 (0x00007f5db49bb000)
libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f5db4686000)
libswscale.so.4 => /opt/kaltura/ffmpeg-3.2/lib/libswscale.so.4 (0x00007f5db42fe000)
libpostproc.so.54 => /opt/kaltura/ffmpeg-3.2/lib/libpostproc.so.54 (0x00007f5db40df000)
libavformat.so.57 => /opt/kaltura/ffmpeg-3.2/lib/libavformat.so.57 (0x00007f5db3c4d000)
libass.so.4 => /usr/lib/x86_64-linux-gnu/libass.so.4 (0x00007f5db3a29000)
liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f5db3807000)
libnuma.so.1 => /usr/lib/x86_64-linux-gnu/libnuma.so.1 (0x00007f5db35fc000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f5db32f8000)
libogg.so.0 => /usr/lib/x86_64-linux-gnu/libogg.so.0 (0x00007f5db30ef000)
liborc-0.4.so.0 => /usr/lib/x86_64-linux-gnu/liborc-0.4.so.0 (0x00007f5db2e6d000)
libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f5db2c5b000)
libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f5db2a3c000)
libbz2.so.1.0 => /lib/x86_64-linux-gnu/libbz2.so.1.0 (0x00007f5db282c000)
libfribidi.so.0 => /usr/lib/x86_64-linux-gnu/libfribidi.so.0 (0x00007f5db2615000)
libfontconfig.so.1 => /usr/lib/x86_64-linux-gnu/libfontconfig.so.1 (0x00007f5db23d9000)
libfreetype.so.6 => /usr/lib/x86_64-linux-gnu/libfreetype.so.6 (0x00007f5db2136000)
libenca.so.0 => /usr/lib/x86_64-linux-gnu/libenca.so.0 (0x00007f5db1f03000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f5db1ced000)
libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f5db1ae9000)
libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f5db18e3000)
libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007f5db16b9000)
libpng12.so.0 => /lib/x86_64-linux-gnu/libpng12.so.0 (0x00007f5db1493000)
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura#

Regards - Srikar

SrikarVR · June 16, 2017, 1:38pm

Just ran “aptitude install kaltura-ffmpeg” and below is the output.

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# aptitude install kaltura-ffmpeg
The following partially installed packages will be configured:
kaltura-nginx
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up kaltura-nginx (1.12-3) …
System start/stop links for /etc/init.d/kaltura-nginx already exist.
Restarting nginx: nginx.
Processing triggers for libc-bin (2.19-0ubuntu6.11) …

jess · June 16, 2017, 2:42pm

OK, so things seem fine now. I suggest you rerun the installation script just in case there are more packages that should have been installed but were not because of your previous issues. Inspect the output closely for any errors.

Once done, try to access Admin Console, if something does not work, from a root shell on the server, run:
# source /etc/profile.d/kaltura-base.sh
# kaltlog
and look at the errors thrown to STDOUT, in parallel, open your browser’s dev tools and look for errors and failing requests under the “Console” and “Network” tabs and paste the info here.

SrikarVR · June 16, 2017, 5:04pm

Hi Jess - Kindly find the log below. Towards end of log I see Database errors where kaltura user is unable to connect to the Database.

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# ./install_kaltura_all_in_1.sh
–2017-06-16 16:12:01-- http://installrepo.kaltura.org/repo/apt/debian/kaltura-deb.gpg.key
Resolving installrepo.kaltura.org (installrepo.kaltura.org)… 52.84.7.135, 52.84.7.91, 52.84.7.214, …
Connecting to installrepo.kaltura.org (installrepo.kaltura.org)|52.84.7.135|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1727 (1.7K) [text/plain]
Saving to: ‘STDOUT’

100%[==============================================================================================================================>] 1,727 --.-K/s in 0s

2017-06-16 16:12:02 (157 MB/s) - written to stdout [1727/1727]

OK
/usr/bin/aptitude
Hit http://installrepo.kaltura.org lynx InRelease
Hit http://installrepo.kaltura.org lynx/main amd64 Packages
Hit http://stable.packages.cloudmonitoring.rackspace.com cloudmonitoring InRelease
Ign http://mirror.rackspace.com trusty InRelease
Get: 1 http://repo.pbis.beyondtrust.com pbiso InRelease [3,112 B]
Hit http://stable.packages.cloudmonitoring.rackspace.com cloudmonitoring/main amd64 Packages
Get: 2 http://mirror.rackspace.com trusty-updates InRelease [65.9 kB]
Hit http://nginx.org trusty InRelease
Get: 3 http://repo.pbis.beyondtrust.com pbiso/main amd64 Packages [1,812 B]
Hit http://stable.packages.cloudmonitoring.rackspace.com cloudmonitoring/main i386 Packages
Get: 4 http://repo.pbis.beyondtrust.com pbiso/main i386 Packages [1,820 B]
Hit http://nginx.org trusty/nginx amd64 Packages
Ign http://archive.ubuntu.com trusty InRelease
Hit http://ppa.launchpad.net trusty InRelease
Get: 5 http://security.ubuntu.com trusty-security InRelease [65.9 kB]
Hit http://mirror.rackspace.com trusty-backports InRelease
Hit http://nginx.org trusty/nginx i386 Packages
Hit http://mirror.rackspace.com trusty Release.gpg
Hit http://archive.ubuntu.com trusty Release.gpg
Hit http://ppa.launchpad.net trusty/main amd64 Packages
Get: 6 http://mirror.rackspace.com trusty-updates/main Sources [400 kB]
Hit http://archive.ubuntu.com trusty Release
Hit http://ppa.launchpad.net trusty/main i386 Packages
Hit http://ppa.launchpad.net trusty/main Translation-en
Hit http://archive.ubuntu.com trusty/multiverse amd64 Packages
Get: 7 http://mirror.rackspace.com trusty-updates/restricted Sources [6,331 B]
Get: 8 http://security.ubuntu.com trusty-security/main Sources [132 kB]
Get: 9 http://mirror.rackspace.com trusty-updates/universe Sources [184 kB]
Ign http://stable.packages.cloudmonitoring.rackspace.com cloudmonitoring/main Translation-en_US
Hit http://archive.ubuntu.com trusty/multiverse i386 Packages
Ign http://stable.packages.cloudmonitoring.rackspace.com cloudmonitoring/main Translation-en
Get: 10 http://mirror.rackspace.com trusty-updates/multiverse Sources [7,761 B]
Get: 11 http://security.ubuntu.com trusty-security/restricted Sources [4,955 B]
Ign http://nginx.org trusty/nginx Translation-en_US
Get: 12 http://mirror.rackspace.com trusty-updates/main amd64 Packages [988 kB]
Ign http://nginx.org trusty/nginx Translation-en
Hit http://archive.ubuntu.com trusty/multiverse Translation-en
Get: 13 http://security.ubuntu.com trusty-security/universe Sources [59.4 kB]
Ign http://installrepo.kaltura.org lynx/main Translation-en_US
Get: 14 http://security.ubuntu.com trusty-security/multiverse Sources [3,200 B]
Get: 15 http://mirror.rackspace.com trusty-updates/restricted amd64 Packages [17.1 kB]
Ign http://installrepo.kaltura.org lynx/main Translation-en
Get: 16 http://security.ubuntu.com trusty-security/main amd64 Packages [621 kB]
Get: 17 http://mirror.rackspace.com trusty-updates/universe amd64 Packages [417 kB]
Ign http://repo.pbis.beyondtrust.com pbiso/main Translation-en_US
Ign http://archive.ubuntu.com trusty/multiverse Translation-en_US
Ign http://packages.vmware.com precise InRelease
Ign http://repo.pbis.beyondtrust.com pbiso/main Translation-en
Get: 18 http://mirror.rackspace.com trusty-updates/multiverse amd64 Packages [14.3 kB]
Hit http://packages.vmware.com precise Release.gpg
Get: 19 http://mirror.rackspace.com trusty-updates/main i386 Packages [943 kB]
Hit http://packages.vmware.com precise Release
Get: 20 http://security.ubuntu.com trusty-security/restricted amd64 Packages [14.0 kB]
Hit http://packages.vmware.com precise/main amd64 Packages
Hit http://packages.vmware.com precise/main i386 Packages
Get: 21 http://security.ubuntu.com trusty-security/universe amd64 Packages [173 kB]
Get: 22 http://mirror.rackspace.com trusty-updates/restricted i386 Packages [16.9 kB]
Get: 23 http://security.ubuntu.com trusty-security/multiverse amd64 Packages [4,135 B]
Get: 24 http://mirror.rackspace.com trusty-updates/universe i386 Packages [418 kB]
Get: 25 http://security.ubuntu.com trusty-security/main i386 Packages [579 kB]
Get: 26 http://security.ubuntu.com trusty-security/restricted i386 Packages [13.7 kB]
Get: 27 http://mirror.rackspace.com trusty-updates/multiverse i386 Packages [14.7 kB]
Get: 28 http://mirror.rackspace.com trusty-updates/main Translation-en [488 kB]
Get: 29 http://security.ubuntu.com trusty-security/universe i386 Packages [173 kB]
Get: 30 http://security.ubuntu.com trusty-security/multiverse i386 Packages [4,290 B]
Get: 31 http://mirror.rackspace.com trusty-updates/multiverse Translation-en [7,430 B]
Get: 32 http://security.ubuntu.com trusty-security/main Translation-en [337 kB]
Get: 33 http://mirror.rackspace.com trusty-updates/restricted Translation-en [3,978 B]
Get: 34 http://mirror.rackspace.com trusty-updates/universe Translation-en [223 kB]
Get: 35 http://security.ubuntu.com trusty-security/multiverse Translation-en [2,201 B]
Hit http://mirror.rackspace.com trusty-backports/main Sources
Get: 36 http://security.ubuntu.com trusty-security/restricted Translation-en [3,491 B]
Hit http://mirror.rackspace.com trusty-backports/restricted Sources
Hit http://mirror.rackspace.com trusty-backports/universe Sources
Get: 37 http://security.ubuntu.com trusty-security/universe Translation-en [99.6 kB]
Hit http://mirror.rackspace.com trusty-backports/multiverse Sources
Hit http://mirror.rackspace.com trusty-backports/main amd64 Packages
Hit http://mirror.rackspace.com trusty-backports/restricted amd64 Packages
Hit http://mirror.rackspace.com trusty-backports/universe amd64 Packages
Hit http://mirror.rackspace.com trusty-backports/multiverse amd64 Packages
Hit http://mirror.rackspace.com trusty-backports/main i386 Packages
Hit http://mirror.rackspace.com trusty-backports/restricted i386 Packages
Hit http://mirror.rackspace.com trusty-backports/universe i386 Packages
Hit http://mirror.rackspace.com trusty-backports/multiverse i386 Packages
Hit http://mirror.rackspace.com trusty-backports/main Translation-en
Hit http://mirror.rackspace.com trusty-backports/multiverse Translation-en
Hit http://mirror.rackspace.com trusty-backports/restricted Translation-en
Hit http://mirror.rackspace.com trusty-backports/universe Translation-en
Hit http://mirror.rackspace.com trusty Release
Hit http://mirror.rackspace.com trusty/main Sources
Hit http://mirror.rackspace.com trusty/restricted Sources
Hit http://mirror.rackspace.com trusty/universe Sources
Hit http://mirror.rackspace.com trusty/multiverse Sources
Hit http://mirror.rackspace.com trusty/main amd64 Packages
Hit http://mirror.rackspace.com trusty/restricted amd64 Packages
Hit http://mirror.rackspace.com trusty/universe amd64 Packages
Hit http://mirror.rackspace.com trusty/multiverse amd64 Packages
Hit http://mirror.rackspace.com trusty/main i386 Packages
Hit http://mirror.rackspace.com trusty/restricted i386 Packages
Hit http://mirror.rackspace.com trusty/universe i386 Packages
Hit http://mirror.rackspace.com trusty/multiverse i386 Packages
Hit http://mirror.rackspace.com trusty/main Translation-en
Hit http://mirror.rackspace.com trusty/multiverse Translation-en
Hit http://mirror.rackspace.com trusty/restricted Translation-en
Hit http://mirror.rackspace.com trusty/universe Translation-en
Ign http://mirror.rackspace.com trusty/main Translation-en_US
Ign http://mirror.rackspace.com trusty/multiverse Translation-en_US
Ign http://mirror.rackspace.com trusty/restricted Translation-en_US
Ign http://mirror.rackspace.com trusty/universe Translation-en_US
Ign http://packages.vmware.com precise/main Translation-en_US
Ign http://packages.vmware.com precise/main Translation-en
Fetched 6,510 kB in 9s (711 kB/s)

No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

‘multiverse’ distribution component is already enabled for all sources.
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

Starting nginx: nginx.
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# source /etc/profile.d/kaltura-base.sh
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# kaltlog
==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Fri Jun 16 04:58:11.957430 2017] [:error] [pid 18061] [client 10.89.237.227:60756] PHP Fatal error: Uncaught exception ‘Infra_Exception’ with message ‘Kaltura client not found, maybe it wasn’t generated’ in /opt/kaltura/app/ui_infra/InfraBootstrapper.php:31\nStack trace:\n#0 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(662): InfraBootstrapper->_initClient()\n#1 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(615): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource(‘client’)\n#2 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(579): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap(NULL)\n#3 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application.php(347): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap(NULL)\n#4 /opt/kaltura/app/admin_console/web/index.php(37): Zend_Application->bootstrap()\n#5 {main}\n thrown in /opt/kaltura/app/ui_infra/InfraBootstrapper.php on line 31, referer: http://684386-slrs01va9f1sv01/start/index.php

2017-06-16 16:17:36 [0.000000] [1979273490] [1] [BATCH] [KSchedulerConfig->load] NOTICE: loading configuration /opt/kaltura/app/configurations/batch at 1497587532
PHP Fatal error: Uncaught exception ‘Zend_Config_Exception’ with message ‘Section ‘684386-slrs01va9f1sv01’ cannot be found in /opt/kaltura/app/cache//batch/config.ini’ in /opt/kaltura/app/vendor/ZendFramework/library/Zend/Config/Ini.php:150
Stack trace:
#0 /opt/kaltura/app/batch/scheduler/KSchedulerConfig.class.php(59): Zend_Config_Ini->__construct(’/opt/kaltura/ap…’, ‘684386-slrs01va…’, true)

==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Fri Jun 16 16:17:42.328555 2017] [:error] [pid 5765] [client 10.89.237.233:49273] PHP Fatal error: Uncaught exception ‘Infra_Exception’ with message ‘Kaltura client not found, maybe it wasn’t generated’ in /opt/kaltura/app/ui_infra/InfraBootstrapper.php:31\nStack trace:\n#0 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(662): InfraBootstrapper->_initClient()\n#1 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(615): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource(‘client’)\n#2 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(579): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap(NULL)\n#3 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application.php(347): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap(NULL)\n#4 /opt/kaltura/app/admin_console/web/index.php(37): Zend_Application->bootstrap()\n#5 {main}\n thrown in /opt/kaltura/app/ui_infra/InfraBootstrapper.php on line 31, referer: http://684386-slrs01va9f1sv01/start/index.php

–
2017-06-16 16:17:49 [0.000658] [10.89.237.233] [505908719] [12] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc"
2017-06-16 16:17:49 [0.000371] [10.89.237.233] [505908719] [13] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php"
2017-06-16 16:17:49 [0.000956] [10.89.237.233] [505908719] [14] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:17:49 [0.000143] [10.89.237.233] [505908719] [15] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:17:49 [0.000596] [10.89.237.233] [505908719] [16] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client

2017-06-16 16:18:10 [0.000296] [10.89.237.233] [1921694591] [6] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)

2017-06-16 16:18:10 [0.000185] [10.89.237.233] [1921694591] [10] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)

10.89.237.233 - - [16/Jun/2017:16:19:24 +0000] “GET /flash/kmc/login/v1.2.8/login.swf HTTP/1.1” 304 188 0/220 “http://684386-slrs01va9f1sv01/kmc” “Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0” “-” 10.89.237.233 “-” “684386-slrs01va9f1sv01” 5800 - - 449 “-” “-” “-” “-” “max-age=7776000” -
::1 - - [16/Jun/2017:16:19:28 +0000] “OPTIONS * HTTP/1.0” 200 125 0/232 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10466 - - 107 “-” “-” “-” “-” “-” -
::1 - - [16/Jun/2017:16:19:29 +0000] “OPTIONS * HTTP/1.0” 200 125 0/223 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10467 - - 107 “-” “-” “-” “-” “-” -
::1 - - [16/Jun/2017:16:19:30 +0000] “OPTIONS * HTTP/1.0” 200 125 0/203 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10468 - - 107 “-” “-” “-” “-” “-” -

–
2017-06-16 16:19:43 [0.000297] [10.89.237.233] [1874252966] [6] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)

2017-06-16 16:19:43 [0.000186] [10.89.237.233] [1874252966] [10] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)

==> /opt/kaltura/log/kaltura_apache_errors.log <==
[Fri Jun 16 16:19:57.087818 2017] [:error] [pid 10471] [client 10.89.237.233:49292] PHP Fatal error: Uncaught exception ‘Infra_Exception’ with message ‘Kaltura client not found, maybe it wasn’t generated’ in /opt/kaltura/app/ui_infra/InfraBootstrapper.php:31\nStack trace:\n#0 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(662): InfraBootstrapper->_initClient()\n#1 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(615): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource(‘client’)\n#2 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/BootstrapAbstract.php(579): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap(NULL)\n#3 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application.php(347): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap(NULL)\n#4 /opt/kaltura/app/admin_console/web/index.php(37): Zend_Application->bootstrap()\n#5 {main}\n thrown in /opt/kaltura/app/ui_infra/InfraBootstrapper.php on line 31, referer: http://684386-slrs01va9f1sv01/start/index.php

–
2017-06-16 16:20:18 [0.000763] [10.89.237.233] [1534811857] [12] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc"
2017-06-16 16:20:18 [0.000372] [10.89.237.233] [1534811857] [13] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php"
2017-06-16 16:20:18 [0.000731] [10.89.237.233] [1534811857] [14] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:20:18 [0.000129] [10.89.237.233] [1534811857] [15] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:20:18 [0.000529] [10.89.237.233] [1534811857] [16] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client

10.89.237.233 - - [16/Jun/2017:16:20:22 +0000] “GET /flash/kmc/login/v1.2.8/login.swf HTTP/1.1” 304 188 0/303 “http://684386-slrs01va9f1sv01/kmc” “Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0” “-” 10.89.237.233 “-” “684386-slrs01va9f1sv01” 5766 - - 449 “-” “-” “-” “-” “max-age=7776000” -
::1 - - [16/Jun/2017:16:20:27 +0000] “OPTIONS * HTTP/1.0” 200 125 0/161 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10469 - - 107 “-” “-” “-” “-” “-” -
::1 - - [16/Jun/2017:16:20:28 +0000] “OPTIONS * HTTP/1.0” 200 125 0/139 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10471 - - 107 “-” “-” “-” “-” “-” -
::1 - - [16/Jun/2017:16:20:29 +0000] “OPTIONS * HTTP/1.0” 200 125 0/99 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 10470 - - 107 “-” “-” “-” “-” “-” -

–
2017-06-16 16:20:41 [0.000000] [1594732561] [1] [BATCH] [KSchedulerConfig->load] NOTICE: loading configuration /opt/kaltura/app/configurations/batch at 1497587532
PHP Fatal error: Uncaught exception ‘Zend_Config_Exception’ with message ‘Section ‘684386-slrs01va9f1sv01’ cannot be found in /opt/kaltura/app/cache//batch/config.ini’ in /opt/kaltura/app/vendor/ZendFramework/library/Zend/Config/Ini.php:150
Stack trace:
#0 /opt/kaltura/app/batch/scheduler/KSchedulerConfig.class.php(59): Zend_Config_Ini->__construct(’/opt/kaltura/ap…’, ‘684386-slrs01va…’, true)

2017-06-16 16:23:47 [0.000000] [1465718495] [1] [BATCH] [KSchedulerConfig->load] NOTICE: loading configuration /opt/kaltura/app/configurations/batch at 1497587532
PHP Fatal error: Uncaught exception ‘Zend_Config_Exception’ with message ‘Section ‘684386-slrs01va9f1sv01’ cannot be found in /opt/kaltura/app/cache//batch/config.ini’ in /opt/kaltura/app/vendor/ZendFramework/library/Zend/Config/Ini.php:150
Stack trace:
#0 /opt/kaltura/app/batch/scheduler/KSchedulerConfig.class.php(59): Zend_Config_Ini->__construct(’/opt/kaltura/ap…’, ‘684386-slrs01va…’, true)

10.89.237.233 - - [16/Jun/2017:16:25:25 +0000] “GET /favicon.ico HTTP/1.1” 200 1752 0/1203 “http://684386-slrs01va9f1sv01/start/index.php” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36” “-” 10.89.237.233 “-” “684386-slrs01va9f1sv01” 5764 - - 377 “-” “-” “-” “-” “max-age=7776000, public” -
::1 - - [16/Jun/2017:16:25:30 +0000] “OPTIONS * HTTP/1.0” 200 125 0/109 “-” “Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.21 (internal dummy connection)” “-” ::1 “-” “-” 5800 - - 107 “-” “-” “-” “-” “-” -
10.89.237.233 - - [16/Jun/2017:16:25:32 +0000] “GET /admin_console HTTP/1.1” 301 619 0/256 “http://684386-slrs01va9f1sv01/start/index.php” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36” “-” 10.89.237.233 “-” “684386-slrs01va9f1sv01” 5765 - + 455 “-” “-” “-” “-” “-” -

==> /opt/kaltura/log/kaltura_apache_errors.log <==
2017-06-16 16:27:02 [0.000505] [10.89.237.233] [1529927978] [12] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc"
2017-06-16 16:27:02 [0.000392] [10.89.237.233] [1529927978] [13] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php"
2017-06-16 16:27:02 [0.001024] [10.89.237.233] [1529927978] [14] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:27:02 [0.000185] [10.89.237.233] [1529927978] [15] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2017-06-16 16:27:02 [0.000582] [10.89.237.233] [1529927978] [16] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client

2017-06-16 16:28:49 [0.000223] [10.89.237.233] [204753428] [6] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)
–
2017-06-16 16:28:49 [0.000150] [10.89.237.233] [204753428] [10] [API] [KalturaFrontController->getExceptionObject] ALERT: exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=localhost;port=3306;dbname=kaltura;] user[kaltura] password[admin] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘propel’)
^C
root@684386-slrs01va9f1sv01:/opt/_installable/kaltura#

Errors from Browser:
index.php#adminconsole:1 Error in event handler for (unknown): TypeError: Cannot read property ‘allCookies’ of undefined
at chrome-extension://ffdcfjdljhbehggjdkdioajnknjcpbjb/js/sbc_cookies_mon.js:1:2444
index.php#adminconsole:1 Error in event handler for (unknown): TypeError: Cannot read property ‘ChromeID’ of undefined
at chrome-extension://ffdcfjdljhbehggjdkdioajnknjcpbjb/js/sbc_cookies_mon.js:1:2554
linkchecker.nocache.js:3 Failed to execute ‘write’ on ‘Document’: It isn’t possible to write into a document from an asynchronously-loaded external script unless it is explicitly opened.
Z @ linkchecker.nocache.js:3
linkchecker @ linkchecker.nocache.js:6
(anonymous) @ linkchecker.nocache.js:8
showdapdlbar.js:1 [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user’s experience. For more help, check https://xhr.spec.whatwg.org/.
(anonymous) @ showdapdlbar.js:1
sbc_cookies_mon.js:1 Uncaught ReferenceError: LOG is not defined
at HTMLDocument. (sbc_cookies_mon.js:1)
(anonymous) @ sbc_cookies_mon.js:1
sbc_cookies_mon.js:1 Uncaught ReferenceError: LOG is not defined
at HTMLDocument. (sbc_cookies_mon.js:1)
(anonymous) @ sbc_cookies_mon.js:1

Regards - Srikar

jess · June 16, 2017, 5:23pm

Hi @SrikarVR,

You seem to either not have the kaltura DBs set up at all or you have a half baked DB from previous attempts.
I suggest you remove any left overs you may have of Kaltura MySQL users and DBs and purge the kaltura-db package with:

# /opt/kaltura/bin/kaltura-drop-db.sh
# aptitude purge kaltura-db
 
Just to be on the safe side, also reconfigure the kaltura-base package with:

# dpkg-reconfigure kaltura-base

and then reinstall kaltura-db with:

# aptitude install kaltura-db

It will prompt you for the MySQL root passwd and other inputs and then repopulate the DB. Please keep a close eye for errors at the stage.
If you get any, paste them here, otherwise, once done, rerun the install script, it’ll pick up where the last one left off and perform the missing tasks.

Alternatively, if you want to simply purge everything and start anew [might be faster] run:

/opt/kaltura/bin/kaltura-drop-db.sh ; aptitude purge "~Nkaltura" -y && aptitude purge "~Napache2" -y && rm -rf /opt/kaltura

and then rerun the install script.

SrikarVR · June 16, 2017, 6:39pm

Hi Jess - I dropped the Database, ran “dpkg-reconfigure kaltura-base” and reinstalled kaltura-db. Following is the output below. What is not clear to me is what is causing user “kaltura” login to fail with “localhost” while it works for user “root”. See below:

> root@684386-slrs01va9f1sv01:/opt/kaltura/bin# mysql -ukaltura -padmin -hlocalhost -P3306
> ERROR 1045 (28000): Access denied for user ‘kaltura’@‘localhost’ (using password: YES)

If I telnet on port 3306 with localhost connection is established, where telnet with IP / Hostname fails. /etc/hosts file entries are here. Are these correct? Do I have to get any of the ports open? Any specific firewall changes needed?

127.0.0.1 localhost
10.89.12.140 684386-slrs01va9f1sv01

root@684386-slrs01va9f1sv01:/opt/kaltura/bin# telnet localhost 3306
Trying 127.0.0.1…
Connected to localhost.
Escape character is ‘^]’.
[
5.5.55-0ubuntu0.14.04.11FYm:t]U▒YJGeHt2:k0Jemysql_native_password^]

root@684386-slrs01va9f1sv01:/opt/kaltura/bin# telnet 10.89.12.140 3306
Trying 10.89.12.140…
telnet: Unable to connect to remote host: Connection refused

root@684386-slrs01va9f1sv01:/opt/kaltura/bin# ./kaltura-drop-db.sh

‘[’ ‘!’ -r /opt/kaltura/bin/db_actions.rc ‘]’
. /opt/kaltura/bin/db_actions.rc
++ DBS=‘kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog’
++ DB_USERS=‘kaltura etl’
++ kaltura_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,ALTER,CREATE,DROP
++ kaltura_USER=kaltura
++ kaltura_SQL_FILES=’/opt/kaltura/app/deployment/base/sql/01.kaltura_ce_tables.sql /opt/kaltura/app/deployment/base/sql/04.stored_procedures.sql’
++ kaltura_sphinx_log_PRIVILEGES=SELECT,INSERT,UPDATE
++ kaltura_sphinx_log_USER=kaltura
++ kaltura_sphinx_log_SQL_FILES=/opt/kaltura/app/deployment/base/sql/01.kaltura_sphinx_ce_tables.sql
++ kalturadw_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_USER=etl
++ kalturadw_ds_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_ds_USER=etl
++ kalturadw_bisources_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_bisources_USER=etl
++ kalturalog_PRIVILEGES=‘INSERT,UPDATE,DELETE,SELECT,LOCK TABLES’
++ kalturalog_USER=etl
. /opt/kaltura/bin/colors.sh
++ DULL=0
++ BRIGHT=1
++ FG_BLACK=30
++ FG_RED=31
++ FG_GREEN=32
++ FG_YELLOW=33
++ FG_BLUE=34
++ FG_VIOLET=35
++ FG_CYAN=36
++ FG_WHITE=37
++ FG_NULL=00
++ BG_BLACK=40
++ BG_RED=41
++ BG_GREEN=42
++ BG_YELLOW=43
++ BG_BLUE=44
++ BG_VIOLET=45
++ BG_CYAN=46
++ BG_WHITE=47
++ BG_NULL=00
++ ETCOLOR_ERROR=’\033[1;31m’
++ ESC=’\033’
++ NORMAL=’\033[m’
++ RESET=’\033[0;37;00m’
++ BLACK=’\033[0;30m’
++ RED=’\033[0;31m’
++ GREEN=’\033[0;32m’
++ YELLOW=’\033[0;33m’
++ BLUE=’\033[0;34m’
++ VIOLET=’\033[0;35m’
++ CYAN=’\033[0;36m’
++ WHITE=’\033[0;37m’
++ BRIGHT_BLACK=’\033[1;30m’
++ BRIGHT_RED=’\033[1;31m’
++ BRIGHT_GREEN=’\033[1;32m’
++ BRIGHT_YELLOW=’\033[1;33m’
++ BRIGHT_BLUE=’\033[1;34m’
++ BRIGHT_VIOLET=’\033[1;35m’
++ BRIGHT_CYAN=’\033[1;36m’
++ BRIGHT_WHITE=’\033[1;37m’
++ REV_CYAN=’\033[0;47;46m’
++ REV_RED=’\033[0;33; 41m’
++ JESS=‘Jess likes this one :)’
RC_FILE=/etc/kaltura.d/system.ini
‘[’ ‘!’ -r /etc/kaltura.d/system.ini ‘]’
. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=myemailaddress
++ ADMIN_CONSOLE_ADMIN_MAIL=myemailaddress
++ DB1_HOST=localhost
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=admin
++ DWH_HOST=localhost
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=@DWH_PASS@
++ SERVICE_URL=http://684386-slrs01va9f1sv01
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=admin
++ KALTURA_VIRTUAL_HOST_NAME=684386-slrs01va9f1sv01
++ RED5_HOST=
echo -en '\033[0;36mThis will drop the following DBs:
kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog
and remove users:
kaltura etl
on localhost
\033[m
’
This will drop the following DBs:
kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog
and remove users:
kaltura etl
on localhost
‘[’ -n ‘’ ‘]’
echo -en '\033[1;31m
NOTE: this is not reversible.
It is recommended you also back up the current data using mysqldump before continuing.
You can use /opt/kaltura/bin/kaltura-export-db.sh to export the data.

Are you absolutely certain you want this? [n/Y]
\033[m

’

NOTE: this is not reversible.
It is recommended you also back up the current data using mysqldump before continuing.
You can use /opt/kaltura/bin/kaltura-export-db.sh to export the data.

Are you absolutely certain you want this? [n/Y]

read AN
Y
‘[’ Y ‘!=’ Y ‘]’
echo 'root DB passwd:'
root DB passwd:
read -s DBPASSWD
for i in ‘$DB_USERS’
echo ‘drop user kaltura’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DB_USERS’
echo ‘drop user etl’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kaltura…\033[m’
Removing kaltura…+ echo ‘drop database kaltura’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kaltura_sphinx_log…\033[m’
Removing kaltura_sphinx_log…+ echo ‘drop database kaltura_sphinx_log’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kalturadw…\033[m’
Removing kalturadw…+ echo ‘drop database kalturadw’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kalturadw_ds…\033[m’
Removing kalturadw_ds…+ echo ‘drop database kalturadw_ds’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kalturadw_bisources…\033[m’
Removing kalturadw_bisources…+ echo ‘drop database kalturadw_bisources’
mysql -uroot -hlocalhost -padmin -P3306
for i in ‘$DBS’
echo -en '\033[0;36mRemoving kalturalog…\033[m’
Removing kalturalog…+ echo ‘drop database kalturalog’
mysql -uroot -hlocalhost -padmin -P3306
echo -e ‘\n\033[0;32m Successfully dropped kaltura databases and users\033[m’

Successfully dropped kaltura databases and users
root@684386-slrs01va9f1sv01:/opt/kaltura/bin# aptitude purge kaltura-db
The following packages will be REMOVED:
kaltura-db{p}
0 packages upgraded, 0 newly installed, 1 to remove and 1 not upgraded.
Need to get 0 B of archives. After unpacking 8,192 B will be freed.
Do you want to continue? [Y/n/?] Y
(Reading database … 248286 files and directories currently installed.)
Removing kaltura-db (12.15.0-1+b4) …
Purging configuration files for kaltura-db (12.15.0-1+b4) …

root@684386-slrs01va9f1sv01:/opt/kaltura/bin# dpkg-reconfigure kaltura-base

apache2 is running
Stopping web server apache2 *
Stopping daemon monitor monit [ OK ]
Starting web server apache2 *
root@684386-slrs01va9f1sv01:/opt/kaltura/bin# aptitude install kaltura-db
The following NEW packages will be installed:
kaltura-db
0 packages upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B/4,444 B of archives. After unpacking 8,192 B will be used.
Preconfiguring packages …
Selecting previously unselected package kaltura-db.
(Reading database … 248286 files and directories currently installed.)
Preparing to unpack …/kaltura-db_12.15.0-1+b4_all.deb …
Unpacking kaltura-db (12.15.0-1+b4) …
Setting up kaltura-db (12.15.0-1+b4) …
Checking MySQL version…

CREATE USER kaltura;
CREATE USER etl@’%’;
CREATE DATABASE kaltura;
CREATE DATABASE kaltura_sphinx_log;
CREATE DATABASE kalturadw;
CREATE DATABASE kalturadw_ds;
CREATE DATABASE kalturadw_bisources;
CREATE DATABASE kalturalog;
Checking connectivity to needed daemons…
ERROR: Couldn’t connect with mysql -ukaltura -padmin -hlocalhost -P3306.
dpkg: error processing package kaltura-db (–configure):
subprocess installed post-installation script returned error exit status 6
Errors were encountered while processing:
kaltura-db
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up kaltura-db (12.15.0-1+b4) …
Checking MySQL version…

root@684386-slrs01va9f1sv01:/opt/kaltura/bin# mysql -uroot -padmin -hlocalhost -P3306
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1583
Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)

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> quit
Bye
root@684386-slrs01va9f1sv01:/opt/kaltura/bin# mysql -ukaltura -padmin -hlocalhost -P3306
ERROR 1045 (28000): Access denied for user ‘kaltura’@‘localhost’ (using password: YES)
root@684386-slrs01va9f1sv01:/opt/kaltura/bin# telnet localhost 3306
Trying 127.0.0.1…
Connected to localhost.
Escape character is ‘^]’.
[
5.5.55-0ubuntu0.14.04.11FYm:t]U▒YJGeHt2:k0Jemysql_native_password^]
telnet> quit
Connection closed.
root@684386-slrs01va9f1sv01:/opt/kaltura/bin# telnet 10.89.12.140 3306
Trying 10.89.12.140…
telnet: Unable to connect to remote host: Connection refused

Regards - Srikar

jess · June 16, 2017, 7:53pm

Hi @SrikarVR,

For an all in one machine, it’s not necessary for the DB to be accessible from the outside [for a cluster, it should be made accessible to all front and batch nodes, of course].
I suggest you start with:
# mysql -uroot -p
and run:
mysql> select host,user,password from mysql.user;
let’s see what users exist and from which hosts access is currently allowed and try to understand why:
mysql -ukaltura -p$DB1_PASS -hlocalhost -P3306
fails…

SrikarVR · June 16, 2017, 7:58pm

Hi Jess - Here is the output:

root@684386-slrs01va9f1sv01:/opt/_installable/kaltura# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1597
Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)

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>

Regards - Srikar

SrikarVR · June 17, 2017, 5:39am

I dropped DB with “/opt/kaltura/bin/kaltura-drop-db.sh” and ran “bash -x /opt/kaltura/bin/kaltura-db-config.sh” but I found the script failing @ line 214 with error in the trail below. Also found that “kaltura” user was not getting dropped, so I manually dropped use “kaltura” and reinstalled DB as below.

/opt/kaltura/bin/kaltura-drop-db.sh

mysql> drop user kaltura@localhost; (removed “kaltura” user manually)

aptitude purge kaltura-db

dpkg-reconfigure kaltura-base

aptitude install kaltura-db

With this DB installed successfully and I can connect to MySQL with “kaltura” user @localhost. I also checked that login to KMC also works but the page does not display anything under the tabs after login. Admin console link is yet to work.

…
…

++ TAR_PATH=/opt/kaltura/log/log_17_06_17_03_38.tar.gz
++ echo -en ’

\033[1;31mkaltura-db-config.sh FAILED with: 1 on line 214\033[m
Archving logs to /opt/kaltura/log/log_17_06_17_03_38.tar.gz…
’
kaltura-db-config.sh FAILED with: 1 on line 214

Archving logs to /opt/kaltura/log/log_17_06_17_03_38.tar.gz…
++ mkdir -p /tmp/tmpdir_kaltura

jess · June 17, 2017, 10:12am

Hi @SrikarVR,

You’ve logged into the KMC with the Admin Console partner [ID -2, created during the installation], this is why the KMC views are empty.
You should first login to the Admin Console and create a new partner from Publishers->Add New Publisher.
For this, of course, we first need to debug the Admin Console login issue.
From a root shell on the server, run:
# source /etc/profile.d/kaltura-base.sh
# kaltlog
and look at the errors thrown to STDOUT, in parallel, before making a login attempt, open your browser’s dev tools and look for errors and failing requests under the “Console” and “Network” tabs and paste the info here.

As for the error while running /opt/kaltura/bin/kaltura-db-config.sh, you shouldn’t be running that script, it is meant for RPM where interactive prompting during the package installation is not supported.
The deb package format DOES support it so all you need to run is:

# aptitude install kaltura-db

which will trigger /var/lib/dpkg/info/kaltura-db.postinst

It’s very important to make certain the installation of the kaltura-db deb package finishes successfully.