This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
226
Information / Re: Mariadb inport errors
« on: May 12, 2019, 08:18:42 PM »
BTW...password is root mysql password
227
Information / Re: Mariadb inport errors
« on: May 12, 2019, 07:51:59 PM »
Its been a reallllllllllly long day today.
Followsymlinks issue took half a day and the dabase import took half a day.
The fix for the database was this.
DO NOT USE EXPORT FUNCTION WITHIN CWP PHPMYADMIN. IT WILL GENERATE A PIECE OF SHIT.
DO A MYSQLDUMP FROM CENTOS SHELL AND YOU WILL GET A USABLE SQL FILE TO IMPORT.
(FILE OUTPUT WILL BE IN THE DIRECTORY WHERE YOU DID THE DUMP.
Followsymlinks issue took half a day and the dabase import took half a day.
The fix for the database was this.
DO NOT USE EXPORT FUNCTION WITHIN CWP PHPMYADMIN. IT WILL GENERATE A PIECE OF SHIT.
DO A MYSQLDUMP FROM CENTOS SHELL AND YOU WILL GET A USABLE SQL FILE TO IMPORT.
Code: [Select]
[ ~]# mysqldump -u root -p scanmyid_rush > scanmyid_rush.sql
(FILE OUTPUT WILL BE IN THE DIRECTORY WHERE YOU DID THE DUMP.
228
Information / Mariadb inport errors
« on: May 12, 2019, 06:58:52 PM »
Im having a hard time with one website on my new install.
First it was a problem with followsymlinks that I think I fixed by modifying the single vhost file.
But now I exported dbase from older version cwp. When I import I get syntax errors from mariadb.
I cant get past the top of the file
-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 12, 2019 at 06:49 PM
-- Server version: 10.1.22-MariaDB
-- PHP Version: 7.0.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
First it was a problem with followsymlinks that I think I fixed by modifying the single vhost file.
But now I exported dbase from older version cwp. When I import I get syntax errors from mariadb.
I cant get past the top of the file
-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 12, 2019 at 06:49 PM
-- Server version: 10.1.22-MariaDB
-- PHP Version: 7.0.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
229
MySQL / NO_AUTO_VALUE_ON_ZERO error on import
« on: May 12, 2019, 03:49:46 PM »
Im importing database from old cwp to new cwp. I get an error but import appears to be successful. Can I ignore the error?
Mysql error:
phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'phpMyAdmin SQL Dump
Mysql error:
phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'phpMyAdmin SQL Dump
230
MySQL / Roundcube error Connection failed
« on: May 12, 2019, 01:18:26 PM »
Is it possible that the reason is as simple as mysql vs mysqli?
If I cant get this figured out is there a way to uninstall and reinstall roundcube with reinstalling cwp?
If I cant get this figured out is there a way to uninstall and reinstall roundcube with reinstalling cwp?
231
E-Mail / Re: Roundcube CWP7 500 error FIX
« on: May 12, 2019, 12:31:43 PM »Hello.
Try checking file: /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php there is must be the password.
I tried but could not see mysql password.
232
Apache / .htaccess: Option FollowSymlinks not allowed here
« on: May 12, 2019, 12:59:54 AM »
So, I did a new install and transferred everything over from my old CWP to my new CWP. One site works fine on the old CWP but the new CWP I get this error.
.htaccess: Option FollowSymlinks not allowed here
I presume there is a difference in the apache configuration between the old and the new.
Any ideas.
Found it
http://wiki.centos-webpanel.com/options-followsymlinks-not-allowed
.htaccess: Option FollowSymlinks not allowed here
I presume there is a difference in the apache configuration between the old and the new.
Any ideas.
Found it
http://wiki.centos-webpanel.com/options-followsymlinks-not-allowed
233
E-Mail / Re: Roundcube CWP7 500 error FIX
« on: May 11, 2019, 12:59:02 AM »
I have new install of centos cwp. with sqldump.
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I believe it is password error. Is there a password file in clear text?
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I believe it is password error. Is there a password file in clear text?
235
SSL / Deleted CSR file
« on: May 06, 2019, 04:30:06 PM »
I think I made a mistake and deleted a single CSR file in my certs directory. What can I do. New certificates are acting strangely.
IE common names dont match.
IE common names dont match.
236
CentOS 7 Problems / Re: File System Lock
« on: May 05, 2019, 01:15:31 AM »
Is file lock only an option for users other than root?
237
CentOS-WebPanel GUI / admin panel slow to load
« on: May 05, 2019, 12:50:04 AM »
Lately my latest install is not able to completely load admin GUI. I usually have to do a page reload to get the panel to load. My other sites are showing the same latency.
One thing I did notice is that I do not have a swap memory indicated on the admin panel right margin even though I do have 256MB swap memory.
Happens in IE and chrome and FF
One thing I did notice is that I do not have a swap memory indicated on the admin panel right margin even though I do have 256MB swap memory.
Happens in IE and chrome and FF
238
CentOS-WebPanel Bugs / Re: AutoSSL Does not Install Correct Domain
« on: May 04, 2019, 01:37:06 PM »
Something strange happened, which caused chaos with my certs.
When I installed CWP I was asked for primary domain.
In the past, it made no difference which domain I used. In fact, I even used bogus.com in the past with no problem.
But now, it makes a very big difference.
During install, I used my domain from my other server, (which I am being forced to abandon because CWP has expired files and will no longer update). The NEW install, then created a hostname-ssl file.....BUT..BUT.....BUT...the NEW install created a hostname-ssl file and populated the IP address by a DNS LOOKUP.
Guess what.....the NEW INSTALL created a hostname-ssl file with my OLD SERVER IP ADDRESS because DNS resolved to the old server IP address. Bad Bad boy! This created big problems and big headaches.
If I look at primary domain name in NEW CWP it showed the old server IP address. I was able to edit the IP address, but I dont know how to edit primary domain associated with account.
When I installed CWP I was asked for primary domain.
In the past, it made no difference which domain I used. In fact, I even used bogus.com in the past with no problem.
But now, it makes a very big difference.
During install, I used my domain from my other server, (which I am being forced to abandon because CWP has expired files and will no longer update). The NEW install, then created a hostname-ssl file.....BUT..BUT.....BUT...the NEW install created a hostname-ssl file and populated the IP address by a DNS LOOKUP.
Guess what.....the NEW INSTALL created a hostname-ssl file with my OLD SERVER IP ADDRESS because DNS resolved to the old server IP address. Bad Bad boy! This created big problems and big headaches.
If I look at primary domain name in NEW CWP it showed the old server IP address. I was able to edit the IP address, but I dont know how to edit primary domain associated with account.
239
SSL / Re: Strange hostname-ssl file
« on: May 04, 2019, 12:12:34 PM »
I might need to re install everything. I will wait for certs and domain dns changes to take effect.
240
SSL / Strange hostname-ssl file
« on: May 04, 2019, 11:09:29 AM »
Something strange happened, which caused chaos with my certs.
When I installed CWP I was asked for primary domain.
In the past, it made no difference which domain I used. In fact, I even used bogus.com in the past with no problem.
But now, it makes a very big difference.
During install, I used my domain from my other server, (which I am being forced to abandon because CWP has expired files and will no longer update). The NEW install, then created a hostname-ssl file.....BUT..BUT.....BUT...the NEW install created a hostname-ssl file and populated the IP address by a DNS LOOKUP.
Guess what.....the NEW INSTALL created a hostname-ssl file with my OLD SERVER IP ADDRESS because DNS resolved to the old server IP address. Bad Bad boy! This created big problems and big headaches.
If I look at primary domain name it showed the old server IP address. I was able to edit the IP address, but I dont know how to edit primary domain associated with account.
When I installed CWP I was asked for primary domain.
In the past, it made no difference which domain I used. In fact, I even used bogus.com in the past with no problem.
But now, it makes a very big difference.
During install, I used my domain from my other server, (which I am being forced to abandon because CWP has expired files and will no longer update). The NEW install, then created a hostname-ssl file.....BUT..BUT.....BUT...the NEW install created a hostname-ssl file and populated the IP address by a DNS LOOKUP.
Guess what.....the NEW INSTALL created a hostname-ssl file with my OLD SERVER IP ADDRESS because DNS resolved to the old server IP address. Bad Bad boy! This created big problems and big headaches.
If I look at primary domain name it showed the old server IP address. I was able to edit the IP address, but I dont know how to edit primary domain associated with account.