Using only a socket to access database how to db.ini - Installing and Upgrading

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Using only a socket to access database how to db.ini - Installing and Upgrading - Omeka Forum</title> <meta name="description" content="TIA for any help Because Mysql/maria is not good with 2-character searches without a startup variable on the server side I’m using a LAMP company that is not willing to change their shared Mariadb configuration I cann&hellip;"> <meta name="generator" content="Discourse 3.3.1 - https://github.com/discourse/discourse version 25514419e0a9e54991d6a81f9197b6a129b390e9"> <link rel="icon" type="image/png" href="https://forum.omeka.org/uploads/default/optimized/2X/d/db6432aab17e05d848cf3c4b402b9a65d7c73134_2_32x32.png"> <link rel="apple-touch-icon" type="image/png" href="https://forum.omeka.org/uploads/default/optimized/2X/2/28a726fe237f36bb1937e6a03c44d37c339e3aef_2_180x180.jpeg"> <meta name="theme-color" media="all" content="#404E61"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, user-scalable=yes, viewport-fit=cover"> <link rel="canonical" href="https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990" /> <link rel="search" type="application/opensearchdescription+xml" href="https://forum.omeka.org/opensearch.xml" title="Omeka Forum Search"> <link href="/stylesheets/color_definitions_super-official-omeka-branding-x_1_1_7baa737f74c14599798c9011f2a2980d3b8fc610.css?__ws=forum.omeka.org" media="all" rel="stylesheet" class="light-scheme"/> <link href="/stylesheets/desktop_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="desktop" /> <link href="/stylesheets/checklist_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="checklist" /> <link href="/stylesheets/discourse-details_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="discourse-details" /> <link href="/stylesheets/discourse-lazy-videos_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="discourse-lazy-videos" /> <link href="/stylesheets/discourse-local-dates_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="discourse-local-dates" /> <link href="/stylesheets/discourse-narrative-bot_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="discourse-narrative-bot" /> <link href="/stylesheets/discourse-presence_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="discourse-presence" /> <link href="/stylesheets/docker_manager_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="docker_manager" /> <link href="/stylesheets/footnote_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="footnote" /> <link href="/stylesheets/poll_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="poll" /> <link href="/stylesheets/spoiler-alert_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="spoiler-alert" /> <link href="/stylesheets/poll_desktop_e5fb5730e391fb8b20fb96a8213def89a8415fc8.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="poll_desktop" /> <link href="/stylesheets/desktop_theme_2_7f4a472290ee0d6795d4af9cbcd3f08d7ea86852.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="2" data-theme-name="discourse-google-font-component"/> <link href="/stylesheets/desktop_theme_1_93ae6397a8e0528210a5e15cfa0a64737a1178f6.css?__ws=forum.omeka.org" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="1" data-theme-name="super customizations turbo"/> <script defer="" src="/theme-javascripts/d5bac3c93da033d2e34f829991142ab7a65f3a53.js?__ws=forum.omeka.org" data-theme-id="2" nonce="88ICKhfm7sp6dUTPhOGPzRjOw"></script> <link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'Using only a socket to access database how to db.ini'" href="https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990.rss" /> <meta property="og:site_name" content="Omeka Forum" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta name="twitter:image" content="https://forum.omeka.org/uploads/default/original/2X/2/28a726fe237f36bb1937e6a03c44d37c339e3aef.jpeg" /> <meta property="og:image" content="https://forum.omeka.org/uploads/default/original/2X/2/28a726fe237f36bb1937e6a03c44d37c339e3aef.jpeg" /> <meta property="og:url" content="https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990" /> <meta name="twitter:url" content="https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990" /> <meta property="og:title" content="Using only a socket to access database how to db.ini" /> <meta name="twitter:title" content="Using only a socket to access database how to db.ini" /> <meta property="og:description" content="TIA for any help Because Mysql/maria is not good with 2-character searches without a startup variable on the server side I’m using a LAMP company that is not willing to change their shared Mariadb configuration I cannot bind to an IP port on a shared LAMP host. Therefore, I am working off of a user-installed version of mariadb in my home directory, and it only can be accessed via a socket file and not via an IP port. Using Classic. I have the following db.ini (socket= seems to kinda work, ..." /> <meta name="twitter:description" content="TIA for any help Because Mysql/maria is not good with 2-character searches without a startup variable on the server side I’m using a LAMP company that is not willing to change their shared Mariadb configuration I cannot bind to an IP port on a shared LAMP host. Therefore, I am working off of a user-installed version of mariadb in my home directory, and it only can be accessed via a socket file and not via an IP port. Using Classic. I have the following db.ini (socket= seems to kinda work, ..." /> <meta property="og:article:section" content="Omeka Classic" /> <meta property="og:article:section:color" content="BF1E2E" /> <meta property="og:article:section" content="Installing and Upgrading" /> <meta property="og:article:section:color" content="3AB54A" /> <meta property="article:published_time" content="2024-10-06T11:19:19+00:00" /> <meta property="og:ignore_canonical" content="true" /> </head> <body class="crawler browser-update"> <header> <a href="/"> Omeka Forum </a> </header> <div id="main-outlet" class="wrap" role="main"> <div id="topic-title"> <h1> <a href="/t/using-only-a-socket-to-access-database-how-to-db-ini/23990">Using only a socket to access database how to db.ini</a> </h1> <div class="topic-category" itemscope itemtype="http://schema.org/BreadcrumbList"> <span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"> <a href="/c/omeka-classic/installing-and-upgrading/5" class="badge-wrapper bullet" itemprop="item"> <span class='badge-category-bg' style='background-color: #BF1E2E'></span> <span class='badge-category clear-badge'> <span class='category-name' itemprop='name'>Omeka Classic</span> </span> </a> <meta itemprop="position" content="1" /> </span> <span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"> <a href="/c/omeka-classic/installing-and-upgrading/5" class="badge-wrapper bullet" itemprop="item"> <span class='badge-category-bg' style='background-color: #3AB54A'></span> <span class='badge-category clear-badge'> <span class='category-name' itemprop='name'>Installing and Upgrading</span> </span> </a> <meta itemprop="position" content="2" /> </span> </div> </div> <div itemscope itemtype='http://schema.org/DiscussionForumPosting'> <meta itemprop='headline' content='Using only a socket to access database how to db.ini'> <link itemprop='url' href='https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990'> <meta itemprop='datePublished' content='2024-10-06T11:19:19Z'> <meta itemprop='articleSection' content='Installing and Upgrading'> <meta itemprop='keywords' content=''> <div itemprop='publisher' itemscope itemtype="http://schema.org/Organization"> <meta itemprop='name' content='Omeka Forum'> <div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject"> <meta itemprop='url' content='https://forum.omeka.org/uploads/default/original/2X/6/61475bb0c52eeb38e3935e4b140292671c47fdbc.png'> </div> </div> <div id='post_1' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://forum.omeka.org/u/jay_c'><span itemprop='name'>jay_c</span></a> </span> <link itemprop="mainEntityOfPage" href="https://forum.omeka.org/t/using-only-a-socket-to-access-database-how-to-db-ini/23990"> <span class="crawler-post-infos"> <time datetime='2024-10-06T11:19:19Z' class='post-time'> October 6, 2024, 11:19am </time> <meta itemprop='dateModified' content='2024-10-06T11:19:19Z'> <span itemprop='position'>1</span> </span> </div> <div class='post' itemprop='text'> <p>TIA for any help</p> <p>Because</p> <ol> <li>Mysql/maria is not good with 2-character searches without a startup variable on the server side</li> <li>I’m using a LAMP company that is not willing to change their shared Mariadb configuration</li> <li>I cannot bind to an IP port on a shared LAMP host.</li> </ol> <p>Therefore,<br> I am working off of a user-installed version of mariadb in my home directory, and it only can be accessed via a socket file and not via an IP port.</p> <p>Using Classic. I have the following db.ini (socket= seems to kinda work, unix_socket= does not)</p> <pre><code class="lang-auto">[database] host = "localhost" username = "myuser" password = "" dbname = "local_database_omeka" socket = "/home/myuser/var/mysql.sock" ;unix_socket = "/home/myuser/var/mysql.sock" prefix = "omeka_" charset = "utf8" ;port = "" </code></pre> <p>The userid “myuser” is my linux username and exists in mariadb, with all privs on the local_database_omeka . I can access the database vi mariadb client with no password., and it is identified via unix_socket.</p> <p>I am getting the following error attempting to load a site that was previously working on a tcp port.</p> <pre><code class="lang-auto">../application/libraries/Zend/Db/Table/Rowset/Abstract.php(Line:368): Error #8192 Return type of Zend_Db_Table_Rowset_Abstract::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice Zend_Session_Exception: Zend_Session::start() - /application/libraries/Zend/Db/Table/Rowset/Abstract.php(Line:368): Error #8192 Return type of Zend_Db_Table_Rowset_Abstract::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /application/libraries/Zend/Session.php:509 Stack trace: #0 /application/libraries/Zend/Session/Namespace.php(143): Zend_Session::start() #1 /application/libraries/Zend/Auth/Storage/Session.php(86): Zend_Session_Namespace->__construct() #2 /application/libraries/Zend/Auth.php(91): Zend_Auth_Storage_Session->__construct() #3 /application/libraries/Zend/Auth.php(141): Zend_Auth->getStorage() #4 /application/libraries/Omeka/Application/Resource/Currentuser.php(42): Zend_Auth->hasIdentity() #5 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Currentuser->init() #6 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(641): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource() #7 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap() #8 /application/libraries/Omeka/Application/Resource/Helpers.php(116): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap() #9 /application/libraries/Omeka/Application/Resource/Helpers.php(27): Omeka_Application_Resource_Helpers->_initAclHelper() #10 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Helpers->init() #11 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(641): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource() #12 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap() #13 /application/libraries/Omeka/Application/Resource/Frontcontroller.php(63): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap() #14 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Frontcontroller->init() #15 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(638): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource() #16 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap() #17 /application/libraries/Zend/Application.php(373): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap() #18 /application/libraries/Omeka/Application.php(49): Zend_Application->bootstrap() #19 /index.php(23): Omeka_Application->initialize() #20 {main} </code></pre> <p>Tanks again if you can assist</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_2' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" href='https://forum.omeka.org/u/jay_c'><span itemprop='name'>jay_c</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2024-10-06T23:18:10Z' class='post-time'> October 6, 2024, 11:18pm </time> <meta itemprop='dateModified' content='2024-10-06T23:18:10Z'> <span itemprop='position'>2</span> </span> </div> <div class='post' itemprop='text'> <p>Well, it was a slightly old version of Omeka and a very new version of PHP. I got things working! woohoo.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> </div> </div> <footer class="container wrap"> <nav class='crawler-nav'> <ul> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/' itemprop="url">Home </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/categories' itemprop="url">Categories </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/guidelines' itemprop="url">Guidelines </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/tos' itemprop="url">Terms of Service </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/privacy' itemprop="url">Privacy Policy </a> </span> </li> </ul> </nav> <p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p> </footer> <div class="buorg"><div>Unfortunately, <a href="https://www.discourse.org/faq/#browser">your browser is unsupported</a>. Please <a href="https://browsehappy.com">switch to a supported browser</a> to view rich content, log in and reply.</div></div> </body> </html>

CINXE.COM

Using only a socket to access database how to db.ini - Installing and Upgrading - Omeka Forum