[SOLVED] I have big problem. I don´t create new mail account

[crecos]

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?

[joximu]

Infos about version of ispCP, did you upgrade?

/J

[crecos]

(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

[joximu]

could you provide the structure of the table ispcp.mail_users - maybe this helps.

/J

[crecos]

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

[joximu]

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

[crecos]

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

[crecos]

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

[crecos]

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