Errors during new cluster configuration - sphinx and login errors

Hey all, especially @jess :slight_smile:

I am getting a few odd errors during installation of my replacement cluster that I have not experienced before.

The new cluster will be running Oracle Enterprise Linux 7, which should be binary equivalent to RHEL 7.

background: We’re installing a new cluster (v15.14). We are starting with the first node. NFS is set up, the database server is set up. We’re working on the first node.

When running on the first node, things go well until we see:

ERROR: Couldn’t connect to Sphinx with mysql -homapi-kltfe10.intranet.hdr -P9312.
Please check your setup and then run /opt/kaltura/bin/ again.

I do see that searchd is running and there are no errors in kaltura_populate.log When I run “mysql -homapi-kltfe10.intranet.hdr -P9312” at the command line, I get

ERROR 2000 (HY000): Unknown MySQL error

This may be related to my second issue.

The second issue I have is if I try to log in to the admin console with the username and password in my script answer file, this is logged and I’m not sure why. The DB’s seems to be OK and I’ve dropped them a number of times. So maybe this is related to my sphinx issues.

2021-02-12 15:47:49 [0.000520] [] [503361778] [12] [API] [KalturaStatement->execute] DEBUG: Sql took - 0.00046300888061523 seconds
2021-02-12 15:47:49 [0.000087] [] [503361778] [13] [API] [kPermissionManager::initPartnerUserObjects] CRIT: exception 'Exception' with message 'Unknown partner id [-2]' in /opt/kaltura/app/infra/log/KalturaLog.php:79
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/kPermissionManager.php(632): KalturaLog::crit('Unknown partner...')
#5 {main}
2021-02-12 15:47:49 [0.000104] [] [503361778] [14] [API] [kCoreException->__construct] ERR: exception 'kCoreException' with message 'Unknown partner Id [-2]' in /opt/kaltura/app/alpha/apps/kaltura/lib/kPermissionManager.php:633
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/kPermissionManager.php(490): kPermissionManager::initPartnerUserObjects()

Thanks for all your help

1 Like

I think this may have something to do with the mysql client and or mysql client libs on my front end. They’re version 8 where my working clusters are 5.7.

Could this difference cause this behavior? I’m going to have my admins downgrade and see if that changes the behavior.

1 Like

The problem was the mysql client on the front end server. Moving to 5.5 or 5.7 fixed the problem.

1 Like