+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: [SOLVED] I have big problem. I don´t create new mail account (/thread-6185.html)
[SOLVED] I have big problem. I don´t create new mail account - crecos - 03-25-2009 08:22 AM
Hii,
if I try create new email account. Spring up error in ispCP window "Incorrect integer value: ''for column 'mail_auto_respond' at row 1".
With install ispCP wasn´t problem.
ispCP+web+mail server is on first machine and mysql server is on second machine
Have you got any experience?
RE: I have big problem. I don´t create new mail account - joximu - 03-25-2009 09:11 AM
Infos about version of ispCP, did you upgrade?
/J
RE: I have big problem. I don´t create new mail account - crecos - 03-25-2009 06:59 PM
(03-25-2009 09:11 AM)joximu Wrote: Infos about version of ispCP, did you upgrade?
/J
I´m using
ispCP 1.0.0 OMEGA
build: 20090225
Before version RC7 working correctly
RE: I have big problem. I don´t create new mail account - joximu - 03-25-2009 11:51 PM
could you provide the structure of the table ispcp.mail_users - maybe this helps.
/J
RE: I have big problem. I don´t create new mail account - crecos - 03-26-2009 01:15 AM
(03-25-2009 11:51 PM)joximu Wrote: could you provide the structure of the table ispcp.mail_users - maybe this helps.
/J
This mysql table mail_users is free. Not exist soever record. I think is problem in script making new user (mysql record in table) but don´t know what mean Incorrect integer value: '' for column 'mail_auto_respond' at row 1.
What is parament mail_auto_respond ????
RE: I have big problem. I don´t create new mail account - joximu - 03-26-2009 08:38 AM
I mean the structure!
Code:
CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL auto_increment,
`mail_acc` varchar(200) collate utf8_unicode_ci default NULL,
`mail_pass` varchar(150) collate utf8_unicode_ci default NULL,
`mail_forward` text collate utf8_unicode_ci,
`domain_id` int(10) unsigned default NULL,
`mail_type` varchar(30) collate utf8_unicode_ci default NULL,
`sub_id` int(10) unsigned default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
`mail_auto_respond` tinyint(1) NOT NULL default '0',
`mail_auto_respond_text` text collate utf8_unicode_ci,
`quota` int(10) default '10485760',
`mail_addr` varchar(200) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;please compare with your structure!
/J
RE: I have big problem. I don´t create new mail account - crecos - 03-27-2009 01:13 AM
(03-26-2009 08:38 AM)joximu Wrote: I mean the structure!
Code:
CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL auto_increment,
`mail_acc` varchar(200) collate utf8_unicode_ci default NULL,
`mail_pass` varchar(150) collate utf8_unicode_ci default NULL,
`mail_forward` text collate utf8_unicode_ci,
`domain_id` int(10) unsigned default NULL,
`mail_type` varchar(30) collate utf8_unicode_ci default NULL,
`sub_id` int(10) unsigned default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
`mail_auto_respond` tinyint(1) NOT NULL default '0',
`mail_auto_respond_text` text collate utf8_unicode_ci,
`quota` int(10) default '10485760',
`mail_addr` varchar(200) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
please compare with your structure!
/J
Sorry,
I´m drop table mail_users and use your sql query (create again table mail_users) but problem is constantly the same.
RE: I have big problem. I don´t create new mail account - crecos - 04-12-2009 06:12 AM
(03-27-2009 01:13 AM)crecos Wrote:(03-26-2009 08:38 AM)joximu Wrote: I mean the structure!
Code:
CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL auto_increment,
`mail_acc` varchar(200) collate utf8_unicode_ci default NULL,
`mail_pass` varchar(150) collate utf8_unicode_ci default NULL,
`mail_forward` text collate utf8_unicode_ci,
`domain_id` int(10) unsigned default NULL,
`mail_type` varchar(30) collate utf8_unicode_ci default NULL,
`sub_id` int(10) unsigned default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
`mail_auto_respond` tinyint(1) NOT NULL default '0',
`mail_auto_respond_text` text collate utf8_unicode_ci,
`quota` int(10) default '10485760',
`mail_addr` varchar(200) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
please compare with your structure!
/J
Sorry,
I´m drop table mail_users and use your sql query (create again table mail_users) but problem is constantly the same.
Okey, I testing ubuntu 8.04 - 8.10.... mysql 5.0 and 5.1 but problem spring up only if mysql server is on external server... if ispCP and mysql server on one machine.... problem don´t exist.
some idea?
RE: I have big problem. I don´t create new mail account - crecos - 04-20-2009 05:01 AM
Heeey, I find fix.
1. You must install ispCP on machine 1 and for mysql use machine 1.
2. Install mysql-server on machine 2. ( set mysql connect from machine 1 / with phpmyadmin is easy)
3. Open phpmyadmin on machine 1 and export database ispcp.
4. Open phpmyadmin on machine 2 and create database ispcp and import database ispcp.
5. create users pma, vftp for connecting from machine 1 and set autority for database ispcp.
6. in /etc/ispcp/ispcp.conf change DATABASE_HOST and delete password on line DATABASE_PASSWORD.
7. next start script /var/www/ispcp/engine ispcp-db-password and set password for root user on machine 2
8. remote mysql-server from machine 1.
sorry my english