Error at install

and does the create statement go through?
Also, when you add -x, you should be able to see the exact MySQL command that goes through, then we can try to run it ourselves from the shell.

@qdwhaty1, checking right now. Thanks,

Ahh sorry I missed to see that command at yours post.
No does not work

CREATE USER kaltura;

ERROR 1396 (HY000): Operation CREATE USER failed for ‘kaltura’@’%’

As for placing -x I gve you output, all i have is

/usr/sbin/dpkg-reconfigure: kaltura-db is broken or not fully installed

But this one works
CREATE USER kaltura@localhost;

Interesting… what MySQL ver is this?
We can get around it by editing:
/var/lib/dpkg/info/kaltura-db.postinst, line 128
echo “CREATE USER kaltura@$MYSQL_HOST IDENTIFIED BY ‘$DB1_PASS’ ;” | mysql -h$MYSQL_HOST -u$MYSQL_SUPER_USER -p$MYSQL_SUPER_USER_PASSWD -P$MYSQL_PORT

Then remove the current kaltura user you manually created with:
mysql> drop user kaltura;
And aptitude install -f again

I am just wondering why your version will not accept CREATE USER kaltura though…

Can you run:
mysql> select host,user from mysql.user;
as well?

Ok, thank you so much for help

Yes i can run this : select host,user from mysql.user;

host | user |
±----------±-----------------+
| 127.0.0.1 | root |
| ::1 | root |
| localhost | debian-sys-maint |
| localhost | kaltura |
| localhost | phpmyadmin |
| localhost | root |
±----------±-----------------+
6 rows in set (0.00 sec)

  • after changing that row, deleting user and aptitude install -f again
    I got same error*

    Archving logs to /opt/kaltura/log/log_05_05_15_19_43.tar.gz…
    dpkg: error processing package kaltura-db (–configure):
    subprocess installed post-installation script returned error exit status 11
    Errors were encountered while processing:
    kaltura-db

and to answer about mysql

dpkg -s mysql-server
Package: mysql-server
Status: install ok installed
Priority: optional
Section: database
Installed-Size: 121
Maintainer: Ubuntu Developers ubuntu-devel-discuss@lists.ubuntu.com
Architecture: all
Source: mysql-5.5
Version: 5.5.43-0ubuntu0.14.04.1
Depends: mysql-server-5.5
Description: MySQL database server (metapackage depending on the latest version)
This is an empty package that depends on the current “best” version of
mysql-server (currently mysql-server-5.5), as determined by the MySQL
maintainers. Install this package if in doubt about which MySQL
version you need. That will install the version recommended by the
package maintainers.
.
MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.
Homepage: http://dev.mysql.com/
Original-Maintainer: Debian MySQL Maintainers pkg-mysql-maint@lists.alioth.debian.org

Can you check exactly what mysql command run and failed? if you still have bash -x in the postinst script it should be outputted…

@qdwhaty1, you are most correct. There is a bug in 10.10.0.
The problem is in this file:
/opt/kaltura/app/deployment/base/sql/01.kaltura_ce_tables.sql
line 905 should be removed.
However, I spotted an additional issue which I am checking so for now, reverted latest stable to 10.8.0. Please run:
# /opt/kaltura/bin/kaltura-drop-db.sh
# yum remove “kaltura
# yum clean all
# rm -rf /opt/kaltura

and reinstall.
You will of course be able to upgrade later.

Thank you for reporting.

@qdwhaty1, I patched the code and released kaltura-base-10.10.0-3.noarch.rpm
If you have not done anything yet, please just run:
# /opt/kaltura/bin/kaltura-drop-db.sh
# yum clean all
# yum update "kaltura"
and rerun the config script

@Ger, when using mysql-server 5.5.43-0ubuntu0.14 I was able to reproduce your issue.
In my case, the fix to the postinst script did work and I pushed:
kaltura-db_10.10.0+b2_all.deb
to the repo.
If you do aptitude update && aptitude install kaltura-db, it should work.
Please let me know.

Hi, thank you again for helping me.

I removed all as described in guide and started all over again.

Sadly did not installed it.
Here is last rows from output

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/3,984 B of archives. After unpacking 8,192 B will be used.
Preconfiguring packages …
Selecting previously unselected package kaltura-db.
(Reading database … 57313 files and directories currently installed.)
Preparing to unpack …/kaltura-db_10.10.0+b3_all.deb …
Unpacking kaltura-db (10.10.0+b3) …
Setting up kaltura-db (10.10.0+b3) …
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…
Connectivity test passed:)
Cleaning cache…
Populating DB with data… please wait…
Output for /opt/kaltura/app/deployment/base/scripts/installPlugins.php being logged into /opt/kaltura/log/installPlugins.log
Output for /opt/kaltura/app/deployment/base/scripts/insertDefaults.php being logged into /opt/kaltura/log/insertDefaults.log
Output for /opt/kaltura/app/deployment/base/scripts/insertPermissions.php being logged into /opt/kaltura/log/insertPermissions.log
Output for /opt/kaltura/app/deployment/base/scripts/insertContent.php being logged into /opt/kaltura/log/insertContent.log

	Archving logs to /opt/kaltura/log/log_06_05_15_14_59.tar.gz...

dpkg: error processing package kaltura-db (–configure):
subprocess installed post-installation script returned error exit status 11
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 (10.10.0+b3) …
Checking MySQL version…

If it helps, database and user are installed.
From what I see user kaltura does not have any permissions?

Can you check the /opt/kaltura/log/insertContent.log?

Yes, here it is

Queuing action [userRole.add]
Queuing action [user.add]
Executing multirequest
service url: [http://69.164.212.73:80]
curl: http://69.164.212.73:80/api_v3/index.php?service=multirequest&format=3&ignoreNull=1&clientTag=php5%3A15-05-06&apiVersion=3.2.0&1%3Aservice=userrole&1%3Aaction=add&1%3AuserRole%3AobjectType=KalturaUserRole&1%3AuserRole%3Aname=System+Administrator&1%3AuserRole%3AsystemName=System+Administrator&1%3AuserRole%3Adescription=System+Administrator&1%3AuserRole%3Astatus=1&1%3AuserRole%3ApermissionNames=*&1%3AuserRole%3Atags=admin_console&1%3Aks=Y2JkZTdjN2RhOGI4MjI4NDM0NTU5OGQxYzhhYmYwYmQ1MGU0NGVlYnwtMjstMjsxNDMxMDEwNzg2OzI7Mjc1NTY7Ow%3D%3D&2%3Aservice=user&2%3Aaction=add&2%3Auser%3AobjectType=KalturaUser&2%3Auser%3Aid=darko%40mmg.com&2%3Auser%3AscreenName=darko%40mmg.com&2%3Auser%3AfullName=Kaltura+Administrator&2%3Auser%3Aemail=darko%40mmg.com&2%3Auser%3Astatus=1&2%3Auser%3Apassword=Darkog71%23&2%3Auser%3AisAdmin=1&2%3Auser%3AroleIds={1%3Aresult%3Aid}&2%3Auser%3AallowedPartnerIds=*&2%3Aks=Y2JkZTdjN2RhOGI4MjI4NDM0NTU5OGQxYzhhYmYwYmQ1MGU0NGVlYnwtMjstMjsxNDMxMDEwNzg2OzI7Mjc1NTY7Ow%3D%3D&kalsig=43ab9f3756a60c21f7348e2951673546
result (serialized):

404 Not Found

Not Found

The requested URL /api_v3/index.php was not found on this server.


Apache/2.4.7 (Ubuntu) Server at 69.164.212.73 Port 80

PHP Fatal error: Uncaught exception ‘KalturaClientException’ with message 'failed to unserialize server result

404 Not Found

Not Found

The requested URL /api_v3/index.php was not found on this server.


Apache/2.4.7 (Ubuntu) Server at 69.164.212.73 Port 80 ' in /opt/kaltura/app/tests/lib/KalturaClientBase.php:401 Stack trace: #0 /opt/kaltura/app/tests/lib/KalturaClientBase.php(808): KalturaClientBase->doQueue() #1 /opt/kaltura/app/tests/standAloneClient/exec.php(345): KalturaClientBase->doMultiRequest() #2 {main} thrown in /opt/kaltura/app/tests/lib/KalturaClientBase.php on line 401

It seems it cannot make the API calls to populate the DB.
what is the output for
# apachectl -t -DDUMP_VHOSTS

Here it is, hope it helps.
I am instructed to stop experimenting, so I will not be able to help you more
Thank you for help so far.

/var/www/html# apachectl -t -DDUMP_VHOSTS
AH00557: apache2: apr_sockaddr_info_get() failed for kaltura
AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1. Set the ‘ServerName’ directive globally to suppress this message
VirtualHost configuration:
*:80 is a NameVirtualHost
default server 127.0.0.1 (/etc/apache2/sites-enabled/000-default.conf:1)
port 80 namevhost 127.0.0.1 (/etc/apache2/sites-enabled/000-default.conf:1)
port 80 namevhost kaltura (/etc/apache2/sites-enabled/zzzkaltura.conf:1)

kaltura all-in-one 10.10 centos 7
errors “nginx” in kaltura-nginx-config.sh
to changes line 79 “/opt/kaltura/nginx/conf/nginx.conf” on /etc/nginx/nginx.conf

Fixed it yesterday, thanks.

Hey,

Is the host ‘kaltura’ resolvable? it needs to be. also, can you try to disable the 000-default.conf?
# a2dissite 000-default.conf

Ger gives the correct answers, saved me lots of time, thanks