These are chat archives for collectiveaccess/support

30th
Oct 2018
Rafael Henrique
@rahenrique
Oct 30 2018 12:17
Someone here has used "sequence_by_type" inside Multipart id numbering conf ? Is it working? I tried to set the created objects to have a number sequence for each type, but it seems this setting change nothing... Is there some sort of guideline somewhere to achieve that?
Ola Hjelm
@olahjelm_twitter
Oct 30 2018 16:32

@collectiveaccess caUtils lacks MySQL support. While trying to use ca Utils for configuration-check I get this error:

PHP Fatal error: Uncaught DatabaseException: Your PHP installation lacks MySQL support. Please add it and retry... in /opt/lampp/htdocs/providence/app/lib/core/Db/mysqli.php:132
Stack trace:

#0 /opt/lampp/htdocs/providence/app/lib/core/Db.php(143): Db_mysqli->connect(Object(Db), Array)

#1 /opt/lampp/htdocs/providence/app/lib/core/Db.php(117): Db->connect(Array)

#2 /opt/lampp/htdocs/providence/app/lib/ca/ConfigurationCheck.php(82): Db->__construct()

#3 /opt/lampp/htdocs/providence/app/lib/ca/Utils/CLIUtils.php(2907): ConfigurationCheck::performExpensive()

#4 /opt/lampp/htdocs/providence/support/bin/caUtils(167): CLIUtils::do_configuration_check(Object(Zend_Console_Getopt))

#5 {main}

thrown in /opt/lampp/htdocs/providence/app/lib/core/Db/mysqli.php on line 132

I have set the "CA_DB_TYPE" to mysqli. I have no problem with the application in any other way, but cannot use CaUtils for anything.
Please help me solve this

sterlingjenson
@sterlingjenson
Oct 30 2018 17:19
@olahjelm_twitter -- I would check your php.ini file as I am wondering if the problem is that mysql is not enabled in the php.ini in the cli folder
Ola Hjelm
@olahjelm_twitter
Oct 30 2018 22:35
@sterlingjenson This is how it looks in Php.ini :

@sterlingjenson [MySQLi]

; Maximum number of persistent links. -1 means no limit.
; http://php.net/mysqli.max-persistent
mysqli.max_persistent=-1

; Maximum number of links. -1 means no limit.
; http://php.net/mysqli.max-links
mysqli.max_links=-1

; If mysqlnd is used: Number of cache slots for the internal result set cache
; http://php.net/mysqli.cache_size
mysqli.cache_size=2000

; Default port number for mysqli_connect(). If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
; http://php.net/mysqli.default-port
mysqli.default_port=3306

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
; http://php.net/mysqli.default-socket
mysqli.default_socket=

; Default host for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-host
mysqli.default_host=

; Default user for mysql_connect() (doesn't apply in safe mode).
; http://php.net/mysqli.default-user
mysqli.default_user=

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a bad idea to store passwords in this file.
; Any user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
; http://php.net/mysqli.default-pw
mysqli.default_pw=

; Allow or prevent reconnect
mysqli.reconnect=Off

[mysqlnd]
; Enable / Disable collection of general statstics by mysqlnd which can be
; used to tune and monitor MySQL operations.
; http://php.net/mysqlnd.collect_statistics
mysqlnd.collect_statistics=On

; Enable / Disable collection of memory usage statstics by mysqlnd which can be
; used to tune and monitor MySQL operations.
; http://php.net/mysqlnd.collect_memory_statistics
mysqlnd.collect_memory_statistics=On

; Size of a pre-allocated buffer used when sending commands to MySQL in bytes.
; http://php.net/mysqlnd.net_cmd_buffer_size
;mysqlnd.net_cmd_buffer_size = 2048

; Size of a pre-allocated buffer used for reading data sent by the server in
; bytes.
; http://php.net/mysqlnd.net_read_buffer_size
;mysqlnd.net_read_buffer_size = 32768

I have tried to set default host, user and pw
sterlingjenson
@sterlingjenson
Oct 30 2018 22:45
I would look at the extensions part of the file
Above is a link which deals with this topic for PHP 7.0 and has a couple of possible solutions
Ola Hjelm
@olahjelm_twitter
Oct 30 2018 22:55
well, mysqli is enabled according to Php.info:
MysqlI Support enabled
Client API library version mysqlnd 5.0.12-dev - 20150407
running CA 1.7.6
Ubuntu 16.0.4.3 LTS
PHP Version 7.0.15
mysqli plugin installled
mysqlnd 5.0.12-dev - 20150407
Ola Hjelm
@olahjelm_twitter
Oct 30 2018 23:06
@sterlingjenson Thanks anyway for helping
murchmurch
@murchmurch
Oct 30 2018 23:29
Hi! has anyone any experience in using the Source level access controls? I have enabled it in the app.conf file. I have created two new Object_souce items and the newly imported object that have these one of these two object sources work as expected with the source control but the two original Obect_source items (external and internal) do not work at all. Am i missing something?
murchmurch
@murchmurch
Oct 30 2018 23:36
This seems to also be the case for the system default source_id for places(Coverages) , presons (DC entity lists) etc. even if i set full read/write to these in access roles /source tab Is this a known bug, or have i missed something in the config @collectiveaccess ?