Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 4th January 2007, 16:40
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts

Originally Posted by Kyse
OK falko, check it..

I got it all working, now im trying to edit the database using mysql.

it gives me the same error for editing domains as users but I have users to copy/paste, so here it is:

mysql> INSERT INTO 'users' ('email', 'password', 'quota') VALUES ('kyse@kyse.us', ENCRYPT('blah'), 10485760);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''users' ('email', 'password', 'quota') VALUES ('kyse@kyse.us', ENCRYPT('blah' at line 1

Any ideas? :P
The correct syntax is

INSERT INTO users (email, password, quota) VALUES ('kyse@kyse.us', ENCRYPT('blah'), 10485760);
I can send and receive email to and from the one account I craeted in the databases now. kyse@kyse.us. However if I try to send an email to internal user accounts on the mail server, such as root@kyse.us or external email addresses such as kyse@cox.net, I get undeliverable return messages back to outlook.
What's in your mail log when this happens?
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade question for "Virtual Users And Domains With Postfix, Courier And MySQL" emresumengen HOWTO-Related Questions 3 1st December 2006 16:33

All times are GMT +2. The time now is 04:24.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.