Attn: Brad Jahnke
Hi Brad, I don't expect that you will specifically remember me, but we have had tech help emails back and forth in the past regarding my sites at Zettai.net. I'm unable to locate a zettai email for you (not even sure if you are still affiliated with Zettai) so have found this address from Google and am hoping it will get to you. I'm currently trying to resolve a situation with Mr. Donnelly...he is not responding to any of my emails or voicemails. There is no one else I can contact, so am hoping you may be able to advocate my case, which I am prepared to fully and completely explain, either by email or phone call. Please appreciate that I am aware Mr. Donnelly will have his version of events. I ask that, if you are in a position to influence a resolve, you would entertain my side of the story prior to reaching a conclusion. Mr. Donnelly has terminated three Plone websites that I operate...all in a volunteer capacity (I receive absolutely no remuneration): two for police organizations and one for my church. I am desperately trying to resolve the situation in order to re-activate these sites. (stedwardsduncan.com, vcpunion.com and bcfedpolice.com) If you are able to offer any insight whatsoever, I would be most appreciative. I'm grasping at straws right now. I sincerely want to resolve this issue and continue being a Zettai customer but very reluctantly, don't think this will be possible. Do you have a Plone hosting alternative if you are no longer associated to Zettai.net? (and I draw this conclusion because George has remove the email link from your name on the About page) Thanks in advance...I appreciate anything you can do or suggest. Sincerely, Brian Fox, MBA -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.2/441 - Release Date: 9/7/2006
MySQL: Spam Free (Send/Receive) Emails. HOW?
I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query(CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. Thank you so much. Mel -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6221195 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED] wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query(CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Shell
Hi Steve, You have to edit a file called .tcshrc which resides in your users home directory, and add :/usr/local/mysql/bin to the PATH environment variable. The tricky part is, this file is not visible to any text editor (for example BBEdit), so I always use a command line editor, for example (start terminal): vi .tcshrc Then use the down arrow key to search through the file to see if you find a line that begins with setenv PATH. If not, add the line: setenv PATH ${PATH}:/usr/local/mysql/bin Otherwise add :/usr/local/mysql/bin to the end, for example: setenv PATH .:${PATH}:$HOME/bin:/usr/local/mysql/bin To insert in vi press i. When you are done inserting press ESC. To delete a character enter x. To quit and save, enter :x. To abort changes, enter :q!. On Sep 8, 2006, at 8:54 PM, Pastor Steve wrote: Greetings, Does anyone know how I can set up my shell so that the mysql command works without navigating to the directory? I am using Mac OS 10.2.8 and 10.4 shell mysql –u name –p ?? Thanks, -- Steve Marquez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. Thanks Mel Michael Loftis wrote: --On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED] wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query(CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
solidDB
Hi, Are there plans to change the default engine of MySQL from solidDB to InnoDB, as InnoDB is now an Oracle product? Regards, Behi -- We can only see a short distance ahead, but we can see plenty there that needs to be done. - Alan Turing Science is a differential equation. Religion is a boundary condition - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--On September 9, 2006 4:28:29 AM -0700 deafmickey [EMAIL PROTECTED] wrote: What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. *blinks* OK nevermind. You're not going to be capable of doing what you want to do. What you want to do requires control of the mail server, and an understanding of how they work. There are plenty of howto's and FAQs that cover all of this elsewhere though. MTA == Mail Transfer Agentyou might know it as an SMTP server. Thanks Mel Michael Loftis wrote: --On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED] wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query(CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)) or die(mysql_error()); mysql_query(CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)) or die(mysql_error()); ? PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW-- tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds. -- Samuel Butler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: solidDB
At 12:39 PM 9/9/2006, you wrote: Hi, Are there plans to change the default engine of MySQL from solidDB to InnoDB, as InnoDB is now an Oracle product? Regards, Behi And while we're on the subject, how good is SolidDB? Is it better than InnoDb? If we wanted a fast reliable transactions for 24/7 database, should we choose InnoDb or SolidDb? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could someone help this guy :-?
Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html -Behi -- We can only see a short distance ahead, but we can see plenty there that needs to be done. - Alan Turing Science is a differential equation. Religion is a boundary condition - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL mailing list's strange responses
Hi, Everytime I send an email to this maling list I get a strange reply from MySQL like this: Sorry. Your message could not be delivered to: ml-mysql,FirstClass Server (The name was not found at the remote site. Check that the name has been entered correctly.) Could someone explain why am I getting these delivery failure messages while my emails are delievered successfuly to the list? Regards, Behi -- We can only see a short distance ahead, but we can see plenty there that needs to be done. - Alan Turing Science is a differential equation. Religion is a boundary condition - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mailing list's strange responses
In the last episode (Sep 10), Behrang Saeedzadeh said: Everytime I send an email to this maling list I get a strange reply from MySQL like this: Sorry. Your message could not be delivered to: ml-mysql,FirstClass Server (The name was not found at the remote site. Check that the name has been entered correctly.) Could someone explain why am I getting these delivery failure messages while my emails are delievered successfuly to the list? I bet the bounce message isn't generated by mysql's servers, rather some subscriber is behind a broken emails erver that sends its bounce messages to the From: header in the email instead of the envelope-sender. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could someone help this guy :-?
Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html If a column is NOT NULL and contains no DEFAULT clause in its definition, the default is the implicit default for the column's data type. That's with strict mode disabled; in strict mode, columns with no DEFAULT clause must be given a value. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could someone help this guy :-?
Paul DuBois wrote: Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html If a column is NOT NULL and contains no DEFAULT clause in its definition, the default is the implicit default for the column's data type. That's with strict mode disabled; in strict mode, columns with no DEFAULT clause must be given a value. This behavior sounds pretty logical to me, besides the fact that it is designed like that. Why would you try to put a NULL value in a column that you explicitly have forbidden to contain NULL values? In my opinion you don't know what you are doing when you use a CREATE query in which you define a column that can't be NULL and after that add a default value of NULL. So it seems logical that MySQL defined a default value for every type. So it is not comparable with M$ Access. If he says that you can do this with PostgreSQL, then I get the feeling that it is a flaw in the software. And might cause unexpected errors in programs. I guess I am also biased as I am very fond of MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: where are the .MYI and .MYD files?
To Jimmy Guerrero, Paul DuBois and Fred Ballard, Your information was very valuable, I already solved the problem, thank you. Misingo :-) Hello, A default install should drop data and databases into C:\Program Files\MySQL\MySQL Server 5.0.\data If you run something like: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]