Show Posts

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.


Messages - pixelpadre

Pages: [1] 2 3 ... 14
1
MySQL / Re: NO_AUTO_VALUE_ON_ZERO error on import
« on: Today at 11:35:32 AM »
Hi, try to check the SQL dump or re-create it.
Or try to import the database via SSH console.

Yes, as I posted in a different thread, I had to use shell to export.  phpmyadmin export gives a bad unuseable sql file.

3
E-Mail / Re: Roundcube CWP7 500 error FIX
« on: May 15, 2019, 01:29:40 PM »
you can run this script to :
Code: [Select]
sh /scripts/mail_roundcube_update

Roundcube has had the same release for two years

4
CentOS-WebPanel GUI / Re: admin panel slow to load
« on: May 13, 2019, 09:46:49 PM »
Changed my router DNS to 8888 and 8844 and pages load instantly now.

5
Informations / Re: Ongoing Issue With Crontab
« on: May 13, 2019, 08:05:43 PM »
check /var/spool/cron for existence of cronjobs

6
Updates / Re: Can't update CWP
« on: May 13, 2019, 04:55:15 PM »
I HAD THE SAME PROBLEM.  TURNED CSF OFF AND IT UPDATED PERFECTLY.

7
CentOS-WebPanel Bugs / Re: Update script throws error
« on: May 13, 2019, 04:50:30 PM »
SOLUTION: TURN FIREWALL OFF DURING UPDATE

8
CentOS-WebPanel Bugs / Update script throws error
« on: May 13, 2019, 04:40:13 PM »
Is there any other way to update cwp?  Script has a problem

######################
Update Server Packages
######################
PHP Warning:  file_get_contents(http://centos-webpanel.com/webpanel/versions/el7                                                                                                                     .txt): failed to open stream: Connection timed out in /usr/local/cwpsrv/htdocs/r                                                                                                                     esources/admin/include/cron.php on line 0
PHP Notice:  Undefined offset:1 in /usr/local/cwpsrv/htdocs/resources/admin/incl                                                                                                                     ude/cron.php on line 0
PHP Warning:  file_get_contents(http://...@gmail.com&version=0.9.8.750&u=1&d=9&s                                                                                                                     =1): failed to open stream: Connection timed out in /usr/local/cwpsrv/htdocs/res                                                                                                                     ources/admin/include/cron.php on line 0

9
E-Mail / Re: Roundcube CWP7 500 error FIX
« on: May 13, 2019, 03:05:18 PM »
I need help with webmail.  database connection error.  Please tell me how to uninstall and reinstall

10
Informations / Re: Mariadb inport errors
« on: May 12, 2019, 08:18:42 PM »
BTW...password is root mysql password

11
Informations / 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.

Code: [Select]
[ ~]# mysqldump -u root -p scanmyid_rush > scanmyid_rush.sql

  (FILE OUTPUT WILL BE IN THE DIRECTORY WHERE YOU DID THE DUMP.

12
Informations / 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 */;

13
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

14
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?

15
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.

Pages: [1] 2 3 ... 14