Messages

1

MySQL / Re: Error importing large sql dump file

« on: March 28, 2015, 01:10:29 PM »

You need to define max_allowed_packet in /etc/my.cnf file not in php.ini file.

that's the first thing I did, but made no changes. (restarted the services, rebooted etc.)
I did risolve only when I edited php.ini. I don't know why, but that's what happened.

ps.
in the /etc/my.cnf file there wasn't max_allowed_packet entry, I tried to add it to it, but made no change)

Thanks for support.

2

CentOS Configuration / Re: How to setup user quotas ?

« on: March 28, 2015, 01:01:56 PM »

As you dont have a separate partition for /home so you need to add quota for root. Replace noatime,errors=remount-ro with noatime,errors=remount-ro,usrjquota=quota.user,jqfmt=vfsv0

After than run the commands below:
mount -o remount /
quotacheck -avugm
quotaon -avug

Now verify if quota is enabled:
repquota -a

Thanks a lot for your suggestions. Unfortunately it didn't work, this command "quotacheck -avugm" gave me this output: Cannot stat() mounted device /dev/root: No such file or directory.

I gave up and deleted the whole thing. It's too complicated for me, there are a number of things which didn't work for me..
set up quotas, mod_security configuration, mod_rewrite...Bind not starting..

It's a pity as I really like the panel for what it should be, but I spent about a week trying to figure it out. 
Probably the best way for me would be to have it managed, but then for the cost I'll stick with cPanel, it works like a charm and support nginx with a plugin (and for me nginx it's a priority).

Thanks everyone. I'll check out future development of this panel, in particular I will look at a significant improvement with documentation with regard to configuration, and nginx support.

3

CentOS Configuration / Re: How to setup user quotas ?

« on: March 27, 2015, 11:32:11 PM »

try by checking all users quota

Code: [Select]

repquota -a -s

I don't get any output from that command, no errors, no messages, it just goes to next line, as [root@myuser]#

what output should i get? cwp let me set up quotas and select/modify  packages when creating an account.
I did "setup disk quotas" in admin panel and get message 
"Quota Configuration file /usr/local/cwp/.conf/quota_part.conf Already Exist!"

however the warning message remain when i do login in admin.

if i try to open quota_part.conf (with nano) there's nothing inside, just "/"

I had a second (and 3rd) look at this 3d, and tried to follow avery clues to fgure out what to do.

1) i tried to yum install quotas and got this output:
Package 1:quota-3.17-21.el6_5.x86_64 already installed and latest version
Nothing to do
2 ) i tried to edit /etc/fstab
and got this output:
# /etc/fstab
# Created by anaconda on Sun Mar  9 13:40:48 2014
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(, mount( and/or blkid( for more info
#
/dev/xvda       /               ext4    noatime,errors=remount-ro       0 1
/dev/xvdb       none            swap    sw                              0 0
tmpfs                   /dev/shm                tmpfs   nodev,nosuid,noexec,mode=1777        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
/proc                    /proc                   proc    defaults        0 0

I'm not sure how i should replace default as indicated by the administrator.
Apparently in the new version it should be all set from the admin panel, and i tried, to no avail so far.

Any useful advice will be very welcome.

4

MySQL / Re: Error importing large sql dump file

« on: March 27, 2015, 11:15:36 PM »

in cwp you have php.ini editor for this most commonly required changes.

Yes i did look in it, unfortunately my trouble was that I couldn't find anything like max_allowed_packet. I ended up by trial and error, changing some params as specified aboce, and at the end it did work.

Somehow I wish this stuff was a little bit more documented, but I uderstand CWP is free and one must be prepared to spend time to find the way around and resolve issues. I love this panel, and I truly hope I can succeed to get it running properly. I'm not there yet though.

5

Varnish / Re: How to install varnish cache on centos [CWP]

« on: March 27, 2015, 09:19:42 PM »

ok, varnish is running properly now (at least so it seems..)

what i did is:
in CentOS Web Panel Settings --> Edit setting, I did set my IP
in Varnish Settings i did set port 82 for Apache, My server IP for Apache IP, and port 80 for Varnish, leaving the rest as default.
That way it worked with Varnish and my IP (not 127.0.0.1)

I don't know if this configuration will, creating other problems along, but for the moment Varnish is working, with my server IP.

Hope it can help someone.

6

MySQL / Re: Error importing large sql dump file

« on: March 27, 2015, 09:10:08 PM »

did u try this? change max allowed packet according to ur need.

mysql --max_allowed_packet=100M -u root -p database < dump.sql

I did succeed and could finally import database.

Unfortunately i didn't document properly what I did, but, the solution was in php.ini. I did change a couple of things, I remember: post_max_size = 50M, upload_max_filesize = 50M, and I did it from command line, firstly I double checked in info.php  where was the relevant php.ini file.
I tried to edit mysql conf file to no avail.
Editing  php.ini  from command line did the trick.

Thanks i really appreciate any help, and ready to share any useful output. (unfortunately, i don't find easy to get it right with CWP)

 

7

CentOS Configuration / Re: How to setup user quotas ?

« on: March 27, 2015, 03:16:41 PM »

try by checking all users quota

Code: [Select]

repquota -a -s

I don't get any output from that command, no errors, no messages, it just goes to next line, as [root@myuser]#

what output should i get? cwp let me set up quotas and select/modify  packages when creating an account.
I did "setup disk quotas" in admin panel and get message 
"Quota Configuration file /usr/local/cwp/.conf/quota_part.conf Already Exist!"

however the warning message remain when i do login in admin.

if i try to open quota_part.conf (with nano) there's nothing inside, just "/"

8

MySQL / Re: Error importing large sql dump file

« on: March 25, 2015, 04:39:20 PM »

for bigger files its always the best to use the command line as zakrpa specified

I'm trying to import a database (due to transferring the site to another server).
 My database is actually very small, but I still get the error #1153 - Got a packet bigger than 'max_allowed_packet' bytes

mysql default config seems to be Max: 2,048KiB

How can i increase the max_allowed_packet? I cannot find this in /etc/my.cnf, and in php.ini neither.

I tried to import the database from terminal still it doesn't work, i get the same error #Got a packet bigger than 'max_allowed_packet' bytes

any help will be greatly appreciated.

9

Varnish / Re: How to install varnish cache on centos [CWP]

« on: March 23, 2015, 06:19:24 PM »

you have in the first post that you can use the shared server IP.

Hello sir, I'm facing the same problem

When running Varnish (port 80, with apache set at at port 82) with 127.0.0.1 as shared ip, it works.

however, when i set my default shared ip (the server public ip) any domain will show the server default page.

For a number of reasons I need my server ip as the default shared ip.

how can this be solved?

thank you.

10

CentOS Configuration / Re: How to setup user quotas ?

« on: March 23, 2015, 01:20:28 PM »

new version will have quota setup script to do this automatically for you.

I tried the quota setup script, and it seems to work, however, when i logout and login again still get the message that i need to set up quotas..

how do I know quotas are set correctly? in the packages i can set quotas and quotas are showing uo in list packages, however, the warning message about setting up quotas on the dashboard will reappear anytime i login in admin CWP.

any advice will be greatly appreciated.