| View previous topic :: View next topic |
| Author |
Message |
Blaksmith
n00b
Joined: 26 Apr 2003
Posts: 8
|
 Posted: Tue Jul 13, 2004 11:39 pm Post subject: vpopmail logs into mysql, but won't work |
 |
|
Ok, I have searched all the forums and haven't found anything like this error. Everyone else's error that looks similar is a logon issue, but it's not a logon issue. here is my output:
| Code: |
./vadddomain mydomain password
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
could not create limits table CREATE TABLE limits ( domain CHAR(64) PRIMARY KEY, maxpopaccounts INT(10) NOT NULL DEFAULT -1, maxaliases INT(10) NOT NULL DEFAULT -1, maxforwards INT(10) NOT NULL DEFAULT -1, maxautoresponders INT(10) NOT NULL DEFAULT -1, maxmailinglists INT(10) NOT NULL DEFAULT -1, diskquota INT(12) NOT NULL DEFAULT 0, maxmsgcount INT(12) NOT NULL DEFAULT 0, defaultquota INT(12) NOT NULL DEFAULT 0, defaultmaxmsgcount INT(12) NOT NULL DEFAULT 0, disable_pop TINYINT(1) NOT NULL DEFAULT 0, disable_imap TINYINT(1) NOT NULL DEFAULT 0, disable_dialup TINYINT(1) NOT NULL DEFAULT 0, disable_passwordchanging TINYINT(1) NOT NULL DEFAULT 0, disable_webmail TINYINT(1) NOT NULL DEFAULT 0, disable_relay TINYINT(1) NOT NULL DEFAULT 0, disable_smtp TINYINT(1) NOT NULL DEFAULT 0, perm_account TINYINT(2) NOT NULL DEFAULT 0, perm_alias TINYINT(2) NOT NULL DEFAULT 0, perm_forward TINYINT(2) NOT NULL DEFAULT 0, perm_autoresponder TINYINT(2) NOT NULL DEFAULT 0, perm_maillist TINYINT(4) NOT NULL DEFAULT 0, perm_quota TINYINT(2) NOT NULL DEFAULT 0, perm_defaultquota TINYINT(2) NOT NULL DEFAULT 0 )
vmysql: sql error[p]: MySQL server has gone away
Error: (vadduser) can't read domain limits
|
can someone please help me with this issue? it is just baffling me on why it's not working.
The account that it is using does have all access set at this current time, so I'm almost positive that it's not a permissions problem either.
Thanks,
Blaksmith |
|
| Back to top |
|
 |
Blaksmith
n00b
Joined: 26 Apr 2003
Posts: 8
|
| Posted: Wed Jul 14, 2004 12:52 am Post subject: not fixed yet |
|
|
I did some more digging, and looked at the logs for mysql, and here is what I found.
| Code: |
040713 9:09:37 Aborted connection 84 to db: 'vpopmail' user: 'vpopmail' host: `localhost' (Got an error reading communication packets)
|
Any help will be greatful. Thanks in advance
Blaksmith |
|
| Back to top |
|
|
Blaksmith
n00b
Joined: 26 Apr 2003
Posts: 8
|
| Posted: Thu Jul 15, 2004 3:00 am Post subject: Fixed |
|
|
The issue is now fixed with a downgrade of vpopmail. now I can't get qmailadmin to work at all. It won't accept my passwords, and stuff like that.
I'll just keep pluggin along fixing it..
Blaksmith |
|
| Back to top |
|
|
Cheesegoduk
n00b
Joined: 18 Jul 2003
Posts: 18
Location: Peterborough, England
|
| Posted: Thu Jul 29, 2004 10:59 pm Post subject: |
|
|
| Yes I to get the same error, I downgraded my vpopmail back to 5.2.2 but it appears that qmailadmin requires at least 5.3.X (according to the ebuild) |
|
| Back to top |
|
|
cult hero
Apprentice
Joined: 13 Oct 2002
Posts: 186
Location: Las Vegas
|
| Posted: Fri Jul 30, 2004 1:17 am Post subject: |
|
|
I can't remember when Gentoo made the change but I know they changed the way their vpopmail.conf file was setup and for whatever reason when I upgraded vpopmail the new conf file didn't appear. Here's what my file looks like:
| Code: | # MYSQL CONNECTION SETTINGS FOR VPOPMAIL
#
# Line 1 defines the connection to use for database reads,
# Line 2 defines the connection to use for database updates/writes.
#
# If you omit line 2, then the same settings will be
# used for both read and write.
#
# settings for each line:
# host|port|user|password|database
#
#
# Note:
# The value of host may be either a hostname or an IP address.
# If host is 'localhost', then sockets (Unix) or named pipes (Windows)
# will be used instead of TCP/IP to connect to the server.
# Read-only DB
localhost|0|vpopmail|*****|vpopmail
# Write DB
localhost|0|vpopmail|*****|vpopmail |
If it doesn't look like that, it might explain your problems. I had to delete my old vpopmail.conf file and emerge again to get the new one. I have no idea why it didn't download the new one and allow me to just merge it in via etc-update. But whatever... if your conf file isn't like th above, I'll bet money that's the problem. I did the upgrade so I could use the newest Qmailadmin as well... so I think this might be your problem.
_________________
Repeat after me! This world is made of love and peace! |
|
| Back to top |
|
|
Cheesegoduk
n00b
Joined: 18 Jul 2003
Posts: 18
Location: Peterborough, England
|
| Posted: Fri Jul 30, 2004 6:29 am Post subject: |
|
|
| Thanks, I'll give it a try and let you know how I get on. |
|
| Back to top |
|
|
tradenet
n00b
Joined: 31 Jan 2004
Posts: 49
|
| Posted: Tue Nov 16, 2004 8:04 pm Post subject: Pleeeeeeeeaaaaaaaseeeeee! |
|
|
I Xmas wish. Please if you do an ebuild on a package take the time tom mention things or change the file to the new format an syntax.
I f*cked around on this for about two hours including digging around here on the forums.
If Gentoo is going to be a distro that the Linux community is going to look to (maybe if not already) we need more care taken with the ebuilds.
OR SOMETHING.
Sorry fo the rant....but it's just happening more and more....for me at least I don't know if anyone else has had/have similar experience(s).
| cult hero wrote: | I can't remember when Gentoo made the change but I know they changed the way their vpopmail.conf file was setup and for whatever reason when I upgraded vpopmail the new conf file didn't appear. Here's what my file looks like:
| Code: | # MYSQL CONNECTION SETTINGS FOR VPOPMAIL
#
# Line 1 defines the connection to use for database reads,
# Line 2 defines the connection to use for database updates/writes.
#
# If you omit line 2, then the same settings will be
# used for both read and write.
#
# settings for each line:
# host|port|user|password|database
#
#
# Note:
# The value of host may be either a hostname or an IP address.
# If host is 'localhost', then sockets (Unix) or named pipes (Windows)
# will be used instead of TCP/IP to connect to the server.
# Read-only DB
localhost|0|vpopmail|*****|vpopmail
# Write DB
localhost|0|vpopmail|*****|vpopmail |
If it doesn't look like that, it might explain your problems. I had to delete my old vpopmail.conf file and emerge again to get the new one. I have no idea why it didn't download the new one and allow me to just merge it in via etc-update. But whatever... if your conf file isn't like th above, I'll bet money that's the problem. I did the upgrade so I could use the newest Qmailadmin as well... so I think this might be your problem. |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
