Hi
The last month I rebuilt 3 qmail servers and all working I shut one down as I 
only need two of them and do not recall all the issues Gary is having.
Gary I did offer my help I was not going to ask for any compensation btw as I 
had some time. Going out of town now so it will be hard at this time email 
only. But not sure why all this issues.

Remo

--
Sent from iPhone

> On giovedì, feb 22, 2024 at 17:43, Eric Broch <[email protected] 
> (mailto:[email protected])> wrote:
>
> I did another fresh install of Rocky9/QMT and I can't seem to duplicate the 
> problem you're having.
>
>
>
>
>
> On 2/22/2024 12:48 PM, Eric Broch wrote:
> >
> > Mine as well. It'd be nice to see some errors in the httpd log.
> >
> >
> >
> >
> >
> > On 2/22/2024 11:15 AM, Gary Bowling wrote:
> > >
> > >
> > >
> > >
> > >
> > > Thanks. So Eric, my version is 8.0.3 as I stated previously.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > php -v
> > > PHP 8.0.30 (cli) (built: Aug 3 2023 17:13:08) ( NTS gcc x86_64 )
> > > Copyright (c) The PHP Group
> > > Zend Engine v4.0.30, Copyright (c) Zend Technologies
> > > with Zend OPcache v8.0.30, Copyright (c), by Zend Technologies
> > >
> > >
> > >
> > >
> > >
> > >
> > > Thanks, gb
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 2/22/2024 1:11 PM, Remo Mattei wrote:
> > > > Gary,
> > > > Yes default is php 8.0.3 I just upgraded afterwards to 8.3 you are fine 
> > > > on the default installation php. Sorry for the confusion.
> > > >
> > > > Remo
> > > >
> > > > > On Feb 22, 2024, at 10:05, Gary Bowling <[email protected]> 
> > > > > (mailto:[email protected]) wrote:
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Not sure what you're saying Remo. My version is 8.0.3, and from your 
> > > > > command it looks like yours is as well. I didn't upgrade to anything, 
> > > > > just installed Rocky 9. Maybe you meant 8.0.3 instead of 8.3.
> > > > >
> > > > >
> > > > >
> > > > > gb
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > On 2/22/2024 12:52 PM, Remo Mattei wrote:
> > > > > > I just upgraded to 8.3 myself seems you can do that no problem but 
> > > > > > keep 8 there Gary.
> > > > > >
> > > > > > Remo
> > > > > >
> > > > > > > On Feb 22, 2024, at 09:50, Gary Bowling <[email protected]> 
> > > > > > > (mailto:[email protected]) wrote:
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > php -v
> > > > > > > PHP 8.0.30 (cli) (built: Aug 3 2023 17:13:08) ( NTS gcc x86_64 )
> > > > > > > Copyright (c) The PHP Group
> > > > > > > Zend Engine v4.0.30, Copyright (c) Zend Technologies
> > > > > > > with Zend OPcache v8.0.30, Copyright (c), by Zend Technologies
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On 2/22/2024 12:31 PM, Eric Broch wrote:
> > > > > > > >
> > > > > > > > Odd! Everything works fine on my Rocky9/qmt host.
> > > > > > > >
> > > > > > > >
> > > > > > > > What version of php are you running?
> > > > > > > >
> > > > > > > >
> > > > > > > > # php -v
> > > > > > > >
> > > > > > > > On 2/22/2024 10:21 AM, Gary Bowling wrote:
> > > > > > > > >
> > > > > > > > > Thanks Eric.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Yep, just to not send a huge logfile. After having everything 
> > > > > > > > > stopped for two hrs, I started everything and went to the 
> > > > > > > > > server/admin-toaster and got the screen from below. It looks 
> > > > > > > > > like a 401 response, which indicates a lack of authentication 
> > > > > > > > > credentials. And I'm not sure why. Probably something to do 
> > > > > > > > > with me copying over the admin.pass or admin.htpasswd from my 
> > > > > > > > > old server. That was part of the migration page.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Here's the httpd/error.log from that.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > [Thu Feb 22 17:12:23.702465 2024] [suexec:notice] [pid 
> > > > > > > > > 121153:tid 121153] AH01232: suEXEC mechanism enabled 
> > > > > > > > > (wrapper: /usr/sbin/suexec)
> > > > > > > > > [Thu Feb 22 17:12:23.714703 2024] [so:warn] [pid 121153:tid 
> > > > > > > > > 121153] AH01574: module proxy_ajp_module is already loaded, 
> > > > > > > > > skipping
> > > > > > > > > [Thu Feb 22 17:12:23.719266 2024] [lbmethod_heartbeat:notice] 
> > > > > > > > > [pid 121153:tid 121153] AH02282: No slotmem from 
> > > > > > > > > mod_heartmonitor
> > > > > > > > > [Thu Feb 22 17:12:23.722704 2024] [mpm_event:notice] [pid 
> > > > > > > > > 121153:tid 121153] AH00489: Apache/2.4.57 (Rocky Linux) 
> > > > > > > > > OpenSSL/3.0.7 configured -- resuming normal operations
> > > > > > > > > [Thu Feb 22 17:12:23.722720 2024] [core:notice] [pid 
> > > > > > > > > 121153:tid 121153] AH00094: Command line: '/usr/sbin/httpd -D 
> > > > > > > > > FOREGROUND'
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > And here's the httpd/access.log
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > 96.46.15.70 - - [22/Feb/2024:17:12:41 +0000] "GET 
> > > > > > > > > /admin-toaster HTTP/1.1" 401 381 "-" "Mozilla/5.0 (Windows NT 
> > > > > > > > > 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) 
> > > > > > > > > Chrome/122.
> > > > > > > > > 0.0.0 Safari/537.36"
> > > > > > > > > 96.46.15.70 - admin [22/Feb/2024:17:12:41 +0000] "GET 
> > > > > > > > > /admin-toaster HTTP/1.1" 301 244 "-" "Mozilla/5.0 (Windows NT 
> > > > > > > > > 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) 
> > > > > > > > > Chrome/
> > > > > > > > > 122.0.0.0 Safari/537.36"
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > On 2/22/2024 10:45 AM, Eric Broch wrote:
> > > > > > > > > >
> > > > > > > > > > Can you check the httpd logs?
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > On 2/22/2024 8:12 AM, Gary Bowling wrote:
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Another issue. When I log in to admin-toaster, it 
> > > > > > > > > > > properly asks for my password and accepts it, but then 
> > > > > > > > > > > all I get is this screen.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > <AFsYv2kZDDMd60l8.png>
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > Between the problems I'm having with roundcube and with 
> > > > > > > > > > > qmailadmin, something is very wrong with my install. I 
> > > > > > > > > > > don't get any errors in the logs, either in messages or 
> > > > > > > > > > > httpd logs.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > I can configure up a client on my desktop and log into 
> > > > > > > > > > > the server using IMAP and send/receive email. Granted I'm 
> > > > > > > > > > > only sending to myself as there is no mx record or proper 
> > > > > > > > > > > dns for this server as it's not live.
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > On 2/21/2024 9:52 AM, Gary Bowling wrote:
> > > > > > > > > > > >
> > > > > > > > > > > > My next challenge is to get roundcube working. My old 
> > > > > > > > > > > > server uses squirrel, but that's so old I need to move 
> > > > > > > > > > > > on. Which might be a bit of a challenge as I have some 
> > > > > > > > > > > > users who exclusively use web mail and have all their 
> > > > > > > > > > > > address books and everything in there.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > At any rate, I first just tried going to my 
> > > > > > > > > > > > server/email.. I got a big list of errors, etc.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > In poking around a bit, I discovered that there wasn't 
> > > > > > > > > > > > a /var/lib/roundcube directory, which is listed in the 
> > > > > > > > > > > > rpm.. Not sure why that was or if it's intended as 
> > > > > > > > > > > > maybe this is a customized version of roundcube. At any 
> > > > > > > > > > > > rate, I decided to do a yum reinstall on roundcube, 
> > > > > > > > > > > > which produced a /var/lib/roundcube dir.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > But I still got the same big list of errors when going 
> > > > > > > > > > > > to server/email.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > In looking at the roundcube configs in 
> > > > > > > > > > > > /etc/roundcube/.. I see the config.inc.php has the 
> > > > > > > > > > > > proper string in it with the p4ssw... password etc. So 
> > > > > > > > > > > > that looks ok.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Logging into mysql with the roundcube user works, and 
> > > > > > > > > > > > the roundcube database is there with all the table 
> > > > > > > > > > > > structure. So that looks ok.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > In looking at the roundcube config in httpd I noticed 
> > > > > > > > > > > > the "require local" rule, which I think means I can 
> > > > > > > > > > > > only access it from the local machine. Since my machine 
> > > > > > > > > > > > is a hosted machine, I can't do that. So I changed the 
> > > > > > > > > > > > to "require ip <MYIP>" ... that didn't resolve anything.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > I'm off to do some other work for the rest of the day, 
> > > > > > > > > > > > but somehow I need to figure out what's going on here. 
> > > > > > > > > > > > There is very little in the logs and I'm running out of 
> > > > > > > > > > > > things to check.
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > Here's the screen I get when I go to myserver/email, 
> > > > > > > > > > > > which seems to say "everything is broken" haha..
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > | | Author: Aleksander Machniak | 
> > > > > > > > > > > > +-------------------------------------------------------------------------+
> > > > > > > > > > > >  */ // include environment require_once 
> > > > > > > > > > > > 'program/include/iniset.php'; // init application, 
> > > > > > > > > > > > start session, init output class, etc. $RCMAIL = 
> > > > > > > > > > > > rcmail::get_instance(0, isset($GLOBALS['env']) ? 
> > > > > > > > > > > > $GLOBALS['env'] : null); // Make the whole PHP output 
> > > > > > > > > > > > non-cacheable (#1487797) 
> > > > > > > > > > > > $RCMAIL->output->nocacheing_headers(); 
> > > > > > > > > > > > $RCMAIL->output->common_headers(!empty($_SESSION['user_id']));
> > > > > > > > > > > >  // turn on output buffering ob_start(); // check if 
> > > > > > > > > > > > config files had errors if ($err_str = 
> > > > > > > > > > > > $RCMAIL->config->get_error()) { 
> > > > > > > > > > > > rcmail::raise_error(['code' => 601, 'message' => 
> > > > > > > > > > > > $err_str], false, true); } // check DB connections and 
> > > > > > > > > > > > exit on failure if ($err_str = $RCMAIL->db->is_error()) 
> > > > > > > > > > > > { rcmail::raise_error(['code' => 603, 'type' => 'db', 
> > > > > > > > > > > > 'message' => $err_str], false, true); } // error steps 
> > > > > > > > > > > > if ($RCMAIL->action == 'error' && 
> > > > > > > > > > > > !empty($_GET['_code'])) { rcmail::raise_error(['code' 
> > > > > > > > > > > > => hexdec($_GET['_code'])], false, true); } // check if 
> > > > > > > > > > > > https is required (for login) and redirect if necessary 
> > > > > > > > > > > > if (empty($_SESSION['user_id']) && ($force_https = 
> > > > > > > > > > > > $RCMAIL->config->get('force_https', false))) { // 
> > > > > > > > > > > > force_https can be true, , :, if 
> > > > > > > > > > > > (!is_bool($force_https)) { list($host, $port) = 
> > > > > > > > > > > > explode(':', $force_https); if (is_numeric($host) && 
> > > > > > > > > > > > empty($port)) { $port = $host; $host = ''; } } if 
> > > > > > > > > > > > (empty($port)) { $port = 443; } if 
> > > > > > > > > > > > (!rcube_utils::https_check($port)) { if (empty($host)) 
> > > > > > > > > > > > { $host = preg_replace('/:[0-9]+$/', '', 
> > > > > > > > > > > > $_SERVER['HTTP_HOST']); } if ($port != 443) { $host .= 
> > > > > > > > > > > > ':' . $port; } header('Location: https://' . $host . 
> > > > > > > > > > > > $_SERVER['REQUEST_URI']); exit; } } // trigger startup 
> > > > > > > > > > > > plugin hook $startup = 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('startup', ['task' => 
> > > > > > > > > > > > $RCMAIL->task, 'action' => $RCMAIL->action]); 
> > > > > > > > > > > > $RCMAIL->set_task($startup['task']); $RCMAIL->action = 
> > > > > > > > > > > > $startup['action']; $session_error = null; // try to 
> > > > > > > > > > > > log in if ($RCMAIL->task == 'login' && $RCMAIL->action 
> > > > > > > > > > > > == 'login') { $request_valid = 
> > > > > > > > > > > > !empty($_SESSION['temp']) && $RCMAIL->check_request(); 
> > > > > > > > > > > > $pass_charset = 
> > > > > > > > > > > > $RCMAIL->config->get('password_charset', 'UTF-8'); // 
> > > > > > > > > > > > purge the session in case of new login when a session 
> > > > > > > > > > > > already exists if ($request_valid) { 
> > > > > > > > > > > > $RCMAIL->kill_session(); } $auth = 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('authenticate', [ 'host' => 
> > > > > > > > > > > > $RCMAIL->autoselect_host(), 'user' => 
> > > > > > > > > > > > trim(rcube_utils::get_input_string('_user', 
> > > > > > > > > > > > rcube_utils::INPUT_POST)), 'pass' => 
> > > > > > > > > > > > rcube_utils::get_input_string('_pass', 
> > > > > > > > > > > > rcube_utils::INPUT_POST, true, $pass_charset), 'valid' 
> > > > > > > > > > > > => $request_valid, 'error' => null, 'cookiecheck' => 
> > > > > > > > > > > > true, ]); // Login if ($auth['valid'] && 
> > > > > > > > > > > > !$auth['abort'] && $RCMAIL->login($auth['user'], 
> > > > > > > > > > > > $auth['pass'], $auth['host'], $auth['cookiecheck']) ) { 
> > > > > > > > > > > > // create new session ID, don't destroy the current 
> > > > > > > > > > > > session // it was destroyed already by 
> > > > > > > > > > > > $RCMAIL->kill_session() above 
> > > > > > > > > > > > $RCMAIL->session->remove('temp'); 
> > > > > > > > > > > > $RCMAIL->session->regenerate_id(false); // send auth 
> > > > > > > > > > > > cookie if necessary 
> > > > > > > > > > > > $RCMAIL->session->set_auth_cookie(); // log successful 
> > > > > > > > > > > > login $RCMAIL->log_login(); // restore original request 
> > > > > > > > > > > > parameters $query = []; if ($url = 
> > > > > > > > > > > > rcube_utils::get_input_string('_url', 
> > > > > > > > > > > > rcube_utils::INPUT_POST)) { parse_str($url, $query); // 
> > > > > > > > > > > > prevent endless looping on login page if 
> > > > > > > > > > > > (!empty($query['_task']) && $query['_task'] == 'login') 
> > > > > > > > > > > > { unset($query['_task']); } // prevent redirect to 
> > > > > > > > > > > > compose with specified ID (#1488226) if 
> > > > > > > > > > > > (!empty($query['_action']) && $query['_action'] == 
> > > > > > > > > > > > 'compose' && !empty($query['_id'])) { $query = 
> > > > > > > > > > > > ['_action' => 'compose']; } } // allow plugins to 
> > > > > > > > > > > > control the redirect url after login success $redir = 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('login_after', $query + 
> > > > > > > > > > > > ['_task' => 'mail']); unset($redir['abort'], 
> > > > > > > > > > > > $redir['_err']); // send redirect 
> > > > > > > > > > > > $RCMAIL->output->redirect($redir, 0, true); } else { if 
> > > > > > > > > > > > (!$auth['valid']) { $error_code = 
> > > > > > > > > > > > rcmail::ERROR_INVALID_REQUEST; } else { $error_code = 
> > > > > > > > > > > > is_numeric($auth['error']) ? $auth['error'] : 
> > > > > > > > > > > > $RCMAIL->login_error(); } $error_labels = [ 
> > > > > > > > > > > > rcmail::ERROR_STORAGE => 'storageerror', 
> > > > > > > > > > > > rcmail::ERROR_COOKIES_DISABLED => 'cookiesdisabled', 
> > > > > > > > > > > > rcmail::ERROR_INVALID_REQUEST => 'invalidrequest', 
> > > > > > > > > > > > rcmail::ERROR_INVALID_HOST => 'invalidhost', 
> > > > > > > > > > > > rcmail::ERROR_RATE_LIMIT => 'accountlocked', ]; if 
> > > > > > > > > > > > (!empty($auth['error']) && !is_numeric($auth['error'])) 
> > > > > > > > > > > > { $error_message = $auth['error']; } else { 
> > > > > > > > > > > > $error_message = !empty($error_labels[$error_code]) ? 
> > > > > > > > > > > > $error_labels[$error_code] : 'loginfailed'; } 
> > > > > > > > > > > > $RCMAIL->output->show_message($error_message, 
> > > > > > > > > > > > 'warning'); // log failed login 
> > > > > > > > > > > > $RCMAIL->log_login($auth['user'], true, $error_code); 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('login_failed', [ 'code' => 
> > > > > > > > > > > > $error_code, 'host' => $auth['host'], 'user' => 
> > > > > > > > > > > > $auth['user'], ]); if (!isset($_SESSION['user_id'])) { 
> > > > > > > > > > > > $RCMAIL->kill_session(); } } } // handle oauth login 
> > > > > > > > > > > > requests else if ($RCMAIL->task == 'login' && 
> > > > > > > > > > > > $RCMAIL->action == 'oauth' && 
> > > > > > > > > > > > $RCMAIL->oauth->is_enabled()) { $oauth_handler = new 
> > > > > > > > > > > > rcmail_action_login_oauth(); $oauth_handler->run(); } 
> > > > > > > > > > > > // end session else if ($RCMAIL->task == 'logout' && 
> > > > > > > > > > > > isset($_SESSION['user_id'])) { 
> > > > > > > > > > > > $RCMAIL->request_security_check(rcube_utils::INPUT_GET 
> > > > > > > > > > > > | rcube_utils::INPUT_POST); $userdata = array( 'user' 
> > > > > > > > > > > > => $_SESSION['username'], 'host' => 
> > > > > > > > > > > > $_SESSION['storage_host'], 'lang' => 
> > > > > > > > > > > > $RCMAIL->user->language, ); 
> > > > > > > > > > > > $RCMAIL->output->show_message('loggedout'); 
> > > > > > > > > > > > $RCMAIL->logout_actions(); $RCMAIL->kill_session(); 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('logout_after', $userdata); 
> > > > > > > > > > > > } // check session and auth cookie else if 
> > > > > > > > > > > > ($RCMAIL->task != 'login' && $_SESSION['user_id']) { if 
> > > > > > > > > > > > (!$RCMAIL->session->check_auth()) { 
> > > > > > > > > > > > $RCMAIL->kill_session(); $session_error = 
> > > > > > > > > > > > 'sessionerror'; } } // not logged in -> show login page 
> > > > > > > > > > > > if (empty($RCMAIL->user->ID)) { if ( $session_error || 
> > > > > > > > > > > > (!empty($_REQUEST['_err']) && $_REQUEST['_err'] === 
> > > > > > > > > > > > 'session') || ($session_error = 
> > > > > > > > > > > > $RCMAIL->session_error()) ) { 
> > > > > > > > > > > > $RCMAIL->output->show_message($session_error ?: 
> > > > > > > > > > > > 'sessionerror', 'error', null, true, -1); } if 
> > > > > > > > > > > > ($RCMAIL->output->ajax_call || 
> > > > > > > > > > > > $RCMAIL->output->get_env('framed')) { 
> > > > > > > > > > > > $RCMAIL->output->command('session_error', 
> > > > > > > > > > > > $RCMAIL->url(['_err' => 'session'])); 
> > > > > > > > > > > > $RCMAIL->output->send('iframe'); } // check if 
> > > > > > > > > > > > installer is still active if 
> > > > > > > > > > > > ($RCMAIL->config->get('enable_installer') && 
> > > > > > > > > > > > is_readable('./installer/index.php')) { 
> > > > > > > > > > > > $RCMAIL->output->add_footer(html::div(['id' => 
> > > > > > > > > > > > 'login-addon', 'style' => "background:#ef9398; 
> > > > > > > > > > > > border:2px solid #dc5757; padding:0.5em; margin:2em 
> > > > > > > > > > > > auto; width:50em"], html::tag('h2', array('style' => 
> > > > > > > > > > > > "margin-top:0.2em"), "Installer script is still 
> > > > > > > > > > > > accessible") . html::p(null, "The install script of 
> > > > > > > > > > > > your Roundcube installation is still stored in its 
> > > > > > > > > > > > default location!") . html::p(null, "Please remove the 
> > > > > > > > > > > > whole installer folder from the Roundcube directory 
> > > > > > > > > > > > because these files may expose sensitive configuration 
> > > > > > > > > > > > data like server passwords and encryption keys to the 
> > > > > > > > > > > > public. Make sure you cannot access the installer 
> > > > > > > > > > > > script (https://mail2.gbco.us/%22./installer//%22) from 
> > > > > > > > > > > > your browser.") )); } $plugin = 
> > > > > > > > > > > > $RCMAIL->plugins->exec_hook('unauthenticated', [ 'task' 
> > > > > > > > > > > > => 'login', 'error' => $session_error, // Return 401 
> > > > > > > > > > > > only on failed logins (#7010) 'http_code' => 
> > > > > > > > > > > > empty($session_error) && !empty($error_message) ? 401 : 
> > > > > > > > > > > > 200 ]); $RCMAIL->set_task($plugin['task']); if 
> > > > > > > > > > > > ($plugin['http_code'] == 401) { header('HTTP/1.0 401 
> > > > > > > > > > > > Unauthorized'); } 
> > > > > > > > > > > > $RCMAIL->output->send($plugin['task']); } else { // 
> > > > > > > > > > > > CSRF prevention $RCMAIL->request_security_check(); // 
> > > > > > > > > > > > check access to disabled actions $disabled_actions = 
> > > > > > > > > > > > (array) $RCMAIL->config->get('disabled_actions'); if 
> > > > > > > > > > > > (in_array($RCMAIL->task . '.' . ($RCMAIL->action ?: 
> > > > > > > > > > > > 'index'), $disabled_actions)) { 
> > > > > > > > > > > > rcube::raise_error(['code' => 404, 'message' => "Action 
> > > > > > > > > > > > disabled"], true, true); } } $RCMAIL->action_handler();
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > > On 2/20/2024 9:02 PM, Gary Bowling wrote:
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Ah, thanks Eric! Unfortunately I didn't find that 
> > > > > > > > > > > > > page earlier. But but I cobbled together a few sql 
> > > > > > > > > > > > > queries, so I...
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > - exported each domain to an xml file
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > - then did a bit of scripting on each domains xml 
> > > > > > > > > > > > > file to add the pw_domain field, which is the same 
> > > > > > > > > > > > > for every record in each file.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > - then used the "load xml local infile..." sql 
> > > > > > > > > > > > > command to load each of the files into the vpopmail 
> > > > > > > > > > > > > table.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > It seems to have all worked. I can now use 
> > > > > > > > > > > > > ./vuserinfo and get correct entries. The other 
> > > > > > > > > > > > > tables, valias, lastauth, dir_control, all seem to be 
> > > > > > > > > > > > > the same.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > So I think I'm on to the next challenge. The script 
> > > > > > > > > > > > > you showed on that page would have been a little 
> > > > > > > > > > > > > easier, but no worries, it wasn't to difficult.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Which reminds me, I need to go back and set Global 
> > > > > > > > > > > > > Local_infiles=0 as I had to change that to 
> > > > > > > > > > > > > export/import local files. Although I'm not sure that 
> > > > > > > > > > > > > hurts anything.
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > Thanks, gb
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > On 2/20/2024 5:04 PM, Eric Broch wrote:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > did you migrate the database?
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Many domain's conversion - QMT (qmailtoaster.org) 
> > > > > > > > > > > > > > (https://qmailtoaster.org/manydom.html)
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > On 2/20/2024 9:37 AM, Gary Bowling wrote:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Thanks Eric.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Continuing through the "migration" page. After 
> > > > > > > > > > > > > > > going through everything moving configs and my 
> > > > > > > > > > > > > > > database, then restarting. Toaststat says 
> > > > > > > > > > > > > > > everything is ok.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > So I tried a simple run of 
> > > > > > > > > > > > > > > ~vpopmail/bin/vuserinfo [email protected] 
> > > > > > > > > > > > > > > (mailto:[email protected]) just to query an account. I 
> > > > > > > > > > > > > > > get this error
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > mysql: sql error[3]: Table 'vpopmail.vpopmail' 
> > > > > > > > > > > > > > > doesn't exist
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Logging into the db and checking, indeed I do not 
> > > > > > > > > > > > > > > have a vpopmail.vpopmail table. I have all the 
> > > > > > > > > > > > > > > domain tables, etc. So I went back to my old 
> > > > > > > > > > > > > > > server (the one this email is coming from) and it 
> > > > > > > > > > > > > > > also does not have a vpopmail.vpopmail table.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > I'm sure it has something to do with how old my 
> > > > > > > > > > > > > > > existing server is. But how do I resolve this?
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Thanks, gb
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > On 2/20/2024 10:00 AM, Eric Broch wrote:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > It's all good and there's nothing to do.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > On 2/20/2024 7:11 AM, Gary Bowling wrote:
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Another question on my migration. On the 
> > > > > > > > > > > > > > > > > qmailtoaster.com site, under the RHEL9 
> > > > > > > > > > > > > > > > > derivative install heading. There is the 
> > > > > > > > > > > > > > > > > qmail1.03-3.3.8 header and underneath it is a 
> > > > > > > > > > > > > > > > > link for "patches applied"
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > I'm confused if that means. It implies that 
> > > > > > > > > > > > > > > > > those patches are already applied and there 
> > > > > > > > > > > > > > > > > is no need to do them. But the link takes you 
> > > > > > > > > > > > > > > > > to the page for the patch like it's something 
> > > > > > > > > > > > > > > > > we should apply.
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > I'm pretty sure it's all good and there is 
> > > > > > > > > > > > > > > > > nothing to do, just wanted to make sure.
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Thanks, gb
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > ____________________
> > > > > > > > > > > > > > > > > The Moderns on Spotify 
> > > > > > > > > > > > > > > > > (https://distrokid.com/hyperfollow/themoderns/bbrs)
> > > > > > > > > > > > > > > > > ____________________
> > > > > > > > > > > > > > > > > ---------------------------------------------------------------------
> > > > > > > > > > > > > > > > >  To unsubscribe, e-mail: 
> > > > > > > > > > > > > > > > > [email protected]
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  For additional commands, e-mail: 
> > > > > > > > > > > > > > > > > [email protected] 
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > ---------------------------------------------------------------------
> > > > > > > > > > > > > > > > >  To unsubscribe, e-mail: 
> > > > > > > > > > > > > > > > > [email protected]
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  For additional commands, e-mail: 
> > > > > > > > > > > > > > > > > [email protected] 
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > ---------------------------------------------------------------------
> > > > > > > > > > > > > > > > >  To unsubscribe, e-mail: 
> > > > > > > > > > > > > > > > > [email protected]
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  For additional commands, e-mail: 
> > > > > > > > > > > > > > > > > [email protected] 
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > ---------------------------------------------------------------------
> > > > > > > > > > > > > > > > >  To unsubscribe, e-mail: 
> > > > > > > > > > > > > > > > > [email protected]
> > > > > > > > > > > > > > > > >  
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > > > > > > > > > > > > >  For additional commands, e-mail: 
> > > > > > > > > > > > > > > > > [email protected] 
> > > > > > > > > > > > > > > > > (mailto:[email protected])
> > > > > --------------------------------------------------------------------- 
> > > > > To unsubscribe, e-mail: 
> > > > > [email protected] 
> > > > > (mailto:[email protected]) For 
> > > > > additional commands, e-mail: [email protected] 
> > > > > (mailto:[email protected])
> > > --------------------------------------------------------------------- To 
> > > unsubscribe, e-mail: [email protected] 
> > > (mailto:[email protected]) For additional 
> > > commands, e-mail: [email protected] 
> > > (mailto:[email protected])

Reply via email to