Re: [qmailtoaster] Replicated Server Issue
On 2/16/11 1:58 PM, Scott Hughes wrote: -Original Message- From: Jake Vickers [mailto:j...@qmailtoaster.com] Sent: Tuesday, January 25, 2011 9:00 AM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p Jake, I tried the above solution to no avail. I then blew the new server away and loaded a new server (VM), then went through the exact same steps again, only this time I did not DROP / CREATE the new database (since my new one was empty). Still not seeing any domains or users in QControl. Any other ideas? Thanks, Scott I think I may have figured this one out. I have not replicated (copied) over the files in /home/vpopmail/domains or any of the other files that Unison is used for. This may be why the domains and users are not showing up yet on the new server. I will run the unison commands to copy the files from the old server to the new server and then see what shows up. My guess is that without the actually domain and user files, the database isn't going to show anything. Unison is running now on the /home/vpopmail/domains structure now. We'll see... Scott - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
On 02/19/2011 12:29 PM, Scott Hughes wrote: On 2/16/11 1:58 PM, Scott Hughes wrote: -Original Message- From: Jake Vickers [mailto:j...@qmailtoaster.com] Sent: Tuesday, January 25, 2011 9:00 AM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p Jake, I tried the above solution to no avail. I then blew the new server away and loaded a new server (VM), then went through the exact same steps again, only this time I did not DROP / CREATE the new database (since my new one was empty). Still not seeing any domains or users in QControl. Any other ideas? Thanks, Scott I think I may have figured this one out. I have not replicated (copied) over the files in /home/vpopmail/domains or any of the other files that Unison is used for. This may be why the domains and users are not showing up yet on the new server. I will run the unison commands to copy the files from the old server to the new server and then see what shows up. My guess is that without the actually domain and user files, the database isn't going to show anything. Unison is running now on the /home/vpopmail/domains structure now. We'll see... Sorry I did not see the first reply. Yes, you'll need to do the setup like in the videos for everything to work correctly. Ping me off-list if you have any other issues. - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
On 02/19/2011 12:29 PM, Scott Hughes wrote: On 2/16/11 1:58 PM, Scott Hughes wrote: -Original Message- From: Jake Vickers [mailto:j...@qmailtoaster.com] Sent: Tuesday, January 25, 2011 9:00 AM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p Jake, I tried the above solution to no avail. I then blew the new server away and loaded a new server (VM), then went through the exact same steps again, only this time I did not DROP / CREATE the new database (since my new one was empty). Still not seeing any domains or users in QControl. Any other ideas? Thanks, Scott I think I may have figured this one out. I have not replicated (copied) over the files in /home/vpopmail/domains or any of the other files that Unison is used for. This may be why the domains and users are not showing up yet on the new server. I will run the unison commands to copy the files from the old server to the new server and then see what shows up. My guess is that without the actually domain and user files, the database isn't going to show anything. Unison is running now on the /home/vpopmail/domains structure now. We'll see... Sorry I did not see the first reply. Yes, you'll need to do the setup like in the videos for everything to work correctly. Ping me off-list if you have any other issues. - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
RE: [qmailtoaster] Replicated Server Issue
-Original Message- From: Jake Vickers [mailto:j...@qmailtoaster.com] Sent: Tuesday, January 25, 2011 9:00 AM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p Jake, I tried the above solution to no avail. I then blew the new server away and loaded a new server (VM), then went through the exact same steps again, only this time I did not DROP / CREATE the new database (since my new one was empty). Still not seeing any domains or users in QControl. Any other ideas? Thanks, Scott - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
This GRANT statement did not help the issue. I'm going to blow away my new server and start over again. This time I'm not going to drop the database (since it has nothing in it anyways) and see if that doesn't fix the issue. Thanks, Scott On Tue, Jan 25, 2011 at 10:08 AM, Scott Hughes sonicscott9...@gmail.comwrote: No, I did not. I must have missed that in the video as I do not recall that step. I will try it and report back. Thanks, Scott On Jan 25, 2011, at 9:00 AM, Jake Vickers j...@qmailtoaster.com wrote: On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhostIDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p - Qmailtoaster is sponsored by Vickers Consulting Group ( www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
No, I did not. I must have missed that in the video as I do not recall that step. I will try it and report back. Thanks, Scott On Jan 25, 2011, at 9:00 AM, Jake Vickers j...@qmailtoaster.com wrote: On 01/24/2011 05:52 PM, Scott Hughes wrote: I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott When you created the new database, did you run anything like: echo GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt' | mysql -u root -p - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
I am trying to add a server to my existing server in a replicated fashion. I am running into a problem copying the database over to the new server. When I follow the steps (listed below) in the Replicated Server video, nothing gets put into the NEW database. Here are the steps I follow: On the OLD (#1) server: Dump vpopmail database into vpopdump.sql SCP file over to NEW server On the NEW (#2) server: Stop Slave Drop vpopmail database Create vpopmail database Import database I SCP'ed (dump file) over from existing server (#1) Start Slave When I check the new server with either QControl or QmailAdmin, there are NO domains or users. I'm stumped on this one. I've followed the above process three times and still no love! Also, the I double-checked that the dump file DOES contain data. Thanks, Scott Does the newly created DB have the vpopmail user as having full rights to the DB? - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott On Jan 24, 2011, at 4:24 PM, Jacob Vickers j...@qmailtoaster.com wrote: I am trying to add a server to my existing server in a replicated fashion. I am running into a problem copying the database over to the new server. When I follow the steps (listed below) in the Replicated Server video, nothing gets put into the NEW database. Here are the steps I follow: On the OLD (#1) server: Dump vpopmail database into vpopdump.sql SCP file over to NEW server On the NEW (#2) server: Stop Slave Drop vpopmail database Create vpopmail database Import database I SCP'ed (dump file) over from existing server (#1) Start Slave When I check the new server with either QControl or QmailAdmin, there are NO domains or users. I'm stumped on this one. I've followed the above process three times and still no love! Also, the I double-checked that the dump file DOES contain data. Thanks, Scott Does the newly created DB have the vpopmail user as having full rights to the DB? - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
RE: [qmailtoaster] Replicated Server Issue
Have you moved the qmail control files and such? (/var/qmail/control) If I remember correctly, the db is not the only place qmailadmin or qcontrol gets the account data (it's the main data, but not the only data). Install Webmin for an easy view of your mysql db's (or PHPmyAdmin). That way you can see if the data is actually exists and if it is readily changing due to replication. Patrick M. Ring P. Ring Technologies Louisiana Web Host, LLC. 985-868-4200 -Original Message- From: Scott Hughes [mailto:sonicscott9...@gmail.com] Sent: Monday, January 24, 2011 4:53 PM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott On Jan 24, 2011, at 4:24 PM, Jacob Vickers j...@qmailtoaster.com wrote: I am trying to add a server to my existing server in a replicated fashion. I am running into a problem copying the database over to the new server. When I follow the steps (listed below) in the Replicated Server video, nothing gets put into the NEW database. Here are the steps I follow: On the OLD (#1) server: Dump vpopmail database into vpopdump.sql SCP file over to NEW server On the NEW (#2) server: Stop Slave Drop vpopmail database Create vpopmail database Import database I SCP'ed (dump file) over from existing server (#1) Start Slave When I check the new server with either QControl or QmailAdmin, there are NO domains or users. I'm stumped on this one. I've followed the above process three times and still no love! Also, the I double-checked that the dump file DOES contain data. Thanks, Scott Does the newly created DB have the vpopmail user as having full rights to the DB? -- --- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] Replicated Server Issue
No, I have not moved any files. Scott On Jan 24, 2011, at 5:06 PM, Patrick Ring pr...@pringtech.net wrote: Have you moved the qmail control files and such? (/var/qmail/control) If I remember correctly, the db is not the only place qmailadmin or qcontrol gets the account data (it's the main data, but not the only data). Install Webmin for an easy view of your mysql db's (or PHPmyAdmin). That way you can see if the data is actually exists and if it is readily changing due to replication. Patrick M. Ring P. Ring Technologies Louisiana Web Host, LLC. 985-868-4200 -Original Message- From: Scott Hughes [mailto:sonicscott9...@gmail.com] Sent: Monday, January 24, 2011 4:53 PM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott On Jan 24, 2011, at 4:24 PM, Jacob Vickers j...@qmailtoaster.com wrote: I am trying to add a server to my existing server in a replicated fashion. I am running into a problem copying the database over to the new server. When I follow the steps (listed below) in the Replicated Server video, nothing gets put into the NEW database. Here are the steps I follow: On the OLD (#1) server: Dump vpopmail database into vpopdump.sql SCP file over to NEW server On the NEW (#2) server: Stop Slave Drop vpopmail database Create vpopmail database Import database I SCP'ed (dump file) over from existing server (#1) Start Slave When I check the new server with either QControl or QmailAdmin, there are NO domains or users. I'm stumped on this one. I've followed the above process three times and still no love! Also, the I double-checked that the dump file DOES contain data. Thanks, Scott Does the newly created DB have the vpopmail user as having full rights to the DB? -- --- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
RE: [qmailtoaster] Replicated Server Issue
At that point, just check to see the database has data in it (using something like Webmin or PHPmyAdmin). Then see if when you change something on your master server (account info via qcontrol or qmailadmin), it follows suit in the new slave. After you've established the database connectivity/replication, you can move the appropriate config files and mail files and, later, start your sync routines. Patrick M. Ring P. Ring Technologies Louisiana Web Host, LLC. 985-868-4200 -Original Message- From: Scott Hughes [mailto:sonicscott9...@gmail.com] Sent: Monday, January 24, 2011 5:16 PM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue No, I have not moved any files. Scott On Jan 24, 2011, at 5:06 PM, Patrick Ring pr...@pringtech.net wrote: Have you moved the qmail control files and such? (/var/qmail/control) If I remember correctly, the db is not the only place qmailadmin or qcontrol gets the account data (it's the main data, but not the only data). Install Webmin for an easy view of your mysql db's (or PHPmyAdmin). That way you can see if the data is actually exists and if it is readily changing due to replication. Patrick M. Ring P. Ring Technologies Louisiana Web Host, LLC. 985-868-4200 -Original Message- From: Scott Hughes [mailto:sonicscott9...@gmail.com] Sent: Monday, January 24, 2011 4:53 PM To: qmailtoaster-list@qmailtoaster.com Subject: Re: [qmailtoaster] Replicated Server Issue I honestly have no idea how to check that, Jake... or for that matter how to fix it if that is the issue. Scott On Jan 24, 2011, at 4:24 PM, Jacob Vickers j...@qmailtoaster.com wrote: I am trying to add a server to my existing server in a replicated fashion. I am running into a problem copying the database over to the new server. When I follow the steps (listed below) in the Replicated Server video, nothing gets put into the NEW database. Here are the steps I follow: On the OLD (#1) server: Dump vpopmail database into vpopdump.sql SCP file over to NEW server On the NEW (#2) server: Stop Slave Drop vpopmail database Create vpopmail database Import database I SCP'ed (dump file) over from existing server (#1) Start Slave When I check the new server with either QControl or QmailAdmin, there are NO domains or users. I'm stumped on this one. I've followed the above process three times and still no love! Also, the I double-checked that the dump file DOES contain data. Thanks, Scott Does the newly created DB have the vpopmail user as having full rights to the DB? - - --- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! -- -- - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com -- -- - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! -- -- - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com -- --- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! - Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today
