Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Hi Rich, Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the whole channel issue? cheers, Mikel Rich Fortnum wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] any good web hosting with php and mysql support? (OT)
Starting @ $20.00/month http://www.ocsny.com -- Original Message -- From: Gurhan Ozen [EMAIL PROTECTED] Date: Mon, 14 Jan 2002 13:17:59 -0500 Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump - basic question
Rory, Take a look at the shell scripts for mysqlbackup here http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain things quite nicely. Cheers, m! ROry O'Connor wrote: this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell script) i can't because mysqldump utility stops to ask for a password. how can I either embed the password or set up mysqldump to not ask for one if, for instance, root is running the shell script? thanks, rory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with SELECT and JOIN pls
I'm no expert in this in fact I just recently started playing with joins, but here's one that I actually used for a recent shopprt cart piece. I appologise if it wraps but the output is long...content conatins the basic content info but product contains the list of prices. Yes I could have just as easily put the price in the content tbl, but I wanted the admin to pull the predefined prices from one source and make a selectable option rather than a type in value. I also figured from a maintenance standpoint when the price goes up it's one change etc... Ok so in any even I joined the two tbls on c.product_id and p.id. If I read you question correctly you should be able to perform smething similar on eventlog.id and crossref.id... mysql select c.*, p.cost from content as c, product as p where c.product_id = p.id ; ++-+-+---+--++-+--+ | id | filename| thumbnail | sdescr| ldescr | product_id | publish | cost | ++-+-+---+--++-+--+ | 3 | sample.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 1 | y | 5.95 | | 1 | sample2.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | | 2 | sample.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | ++-+-+---+--++-+--+ 3 rows in set (0.00 sec) I hope this helps... cheers, Mikel Jaime Teng wrote: Hi, I have two tables: mysql describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10) unsigned | | PRI | NULL| auto_increment | | timestamp | int(10) unsigned | | MUL | 0 || | description | char(100)| | MUL | || +-+--+--+-+-++ mysql describe crossref; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | word| char(20) | | MUL | || | id | int(10) unsigned | | MUL | || +-+--+--+-+-++ Table 'eventlog' is a table of sentence and a unique 'id'. Table crossref is simply a table of single words and an index 'id'. an entry contains a word and an id where said word can be found on the table 'eventlog'. It is common that a: SELECT * from crossref where word = 'HELLO'; would have multiple results. My question here is I would like to do a search wherein I would like to know which sentence contains the words 'HELLO' and 'DAY' and 'WORLD'. take note that the sentence SHOULD contain ALL the three words not just one or two. I think this is a 'JOIN' question but I am not familiar how to use JOIN. can you show me the syntax? thanks for your help. Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER TABLE error
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: Can anyone tell me why I am receiving the following error? I am connecting to a remote server via ssh, and accessed the mysql prompt by typing: mysql The following is the screen contents after trying to use the ALTER TABLE command; 'dbname' has been sub'd for actual database name. screen contents start Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1451062 to server version: 3.23.43 Type 'help' for help. mysql connect dbname Connection id:1451083 Current database: dbname mysql ALTER TABLE Advertisers PACK_KEYS=0; ERROR 2000: Access denied for user: '@localhost' to database 'dbname' screen contents end Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Image's
tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be something like Table=YPEOPLE field=pictures with the path like this c:\images\110101\yourpic.jpeg Also is there a way to do this. I have an aging DOS FoxPro database (see above) that is still in constant use. I imported the tables into MySQL, 200+ Tables and some 200,000 rows, and I would like to update just the New info. Reason. They flat will not give up the monster in accounting. Period. So to make Win users happy I have a small GUI for searchs and stuff,,all read only. Off in seach of a Starbucks. M;) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: conceptual question.
Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question
Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... Wells, Kenneth L wrote: How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal Error, Quitting.. Snort: no process killed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box
well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver make sure the mysql client is installed and try logging into the db from the clilike this: myslq -h some.host.com -u whoami -pMYPASSWD DBNAME if you get in then you've follow the instructions in the mysql handbook properlyRemember to use mysqladmin to reload the new grants before you try the remote connection...or you'll be left with some rather frustrating troubleshooting and quite probably the jitters from that extra few doses of coffee... cheers, m! [EMAIL PROTECTED] wrote: Can someone pls advise me on how to make a website running in an apache webserver on a Linux box connect to a remote mySQL database on a separate Sun box? Thank you. - (on foxtrot) Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the WPP Group shall be understood as neither given nor endorsed by it. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD server help
Kyle, Need a bit more info, what version of mysql? Have you granted the other host(s) permission to use mysql? are you using mysqladmin to stop and start the daemon? cheers, m! Kyle B wrote: Hi all, I am going to try and describe my problem as best as possible. here it goes. Am running FreeBSD v3.0 I can connect to mysql when i telnet to localhost I cannot connect to mysql from another loacation When i try and shut down mysqld it tells me: Segmentation fault (core dumped) It is running on port 2201. I cannot telnet to that port mysql.sock is there whenever i try to run anything to do with mysqld it gives me the error: Segmentation fault (core dumped) Any ideas how to get mysql up and running correctly? Thanks a lot for your time. Kyle B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unix Shell Auth from MySQL
checkout pam_mysql under the ports collection in fBSD...;) cheers, Mikel Chris Aitken wrote: Hi, Something ive been thinking about for a while but havent been able to come up with a definitive answer is this... Is there a system out there which can take over from the normal (unix based... FreeBSD/Linux type) telnetd method of authenticating a login off /etc/master.passwd and instead using a MySQL database for auth. It sounds like a bit of a pipe dream but I figured i'd ask here because I havent been able to find anything on this. Thanks Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ # ln -s /dev/null /bin/laden If you don't like my typing, all flames to /bin/laden - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Expect Script accessing MySQL
I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD=/usr/local/bin./mysql USER=me' HOST=some.host.com PASSWD=whatever QUERY=SELECT userId FROM thisTable WHERE id=1 RESULT='${MYSQLCMD} -h ${HOST}-u ${USERID} -p${PASSWD} -e ${QUERY} -s thisDB' echo ${RESULT} Let me know if you can get expect to work in sh's place... Cheers, m! Chris Aitken wrote: At 11:36 PM 23/09/2001, Neil Zanella wrote: It is possible and not very hard at all. But why would you need expect? Why not just use a shell script? Because the task I need the script to do is best done using Expect (its interfacing with a serial port doing things with some data pulled out of a database). A psuedo flow of what it does is - * Fire off the expect script * The expect script grabs fields of data from mysql * The expect script uses that data and interfaces with a device hanging off a serial port. * The script ends with the result based on whether the interaction with the serial device succeeds or not. Thats why Im wanting to use expect... and thats why I am trying to find a way to get mysql data into an expect script. Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ACT2 Conversion
Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From: James McLaughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 4:03 Subject: ACT2 Conversion Has anyone had any luck or seen any HOWTO docs for converting a ACT2 DB to MySQL? We are moving away from prop windows software and into web based DB administration. Any help would be terrific. THanks Kat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performances?
Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Once again... quotas...
At the company I work for we decided to try and implement reverse quotas. rather than limit said user to x we keep track of their usage and compare it to x. If they should happen to exceed that values then they are billed for the overage. It's very muhc like how UU bills us on our bandwidth for the burstable circuits. Cheers, Mikel Tristan 'Minty' Colgate wrote: Hi There, I have recently been asked to implement per database quotas for mysql for a large scale shared webhosting environmnet, from the lists it seems pretty obvious that mysql cant achieve this at the moment (without using filesystem quotas), file system quotaing is pretty awkward with our environment. Ive been asked to investigate the possibility of implementing this and my boss has agreed that we can release the code back to the community if we decide to do it. I found one posting that mentioned that someone at MySQL had some ideas on how you would like this implemented, if this is still the case could they post them to me, if it can fit in our timeframe Id be more than happy to do it. It really would be a nice feature. -- Tristan 'Minty' Colgate [EMAIL PROTECTED] | ICQ #645908 --- "You can get all you daily vitamins from 43 pints of guinness and a glass of milk" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
Most of my clients get around this problem by incorperating the web side of the business under a different name. There have typically been two reasons for this; 1. it circumvents the tax issue. 2. if the web business encounters legal troubles et cettera...they can go belly up w/o affecting the core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: Mikel King wrote: guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. Actually it gets complicated for two reasons. On the web site I run http://www.tias.com/ we have vendors in all 50 states. Second, if you have a business presence in the state the customer is located in, then you need to calculate the tax for *their* locality. So in the normal case where you are calculating the taxes for just 1 vendors. Who has only one location, then things can be simplified by dealing with only the rules of the state (and the localities within the state). cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Before posting, please check: http://www.mysql.com/manual.php
Re: taxes
Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Shell Shocking
Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: On Tue, 13 Feb 2001, Donald Korth wrote: The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . If your db is anywhere near critical, I would change to an ISP with a competent DBA, if I were you. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Shell Shocking
Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: Hello The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . Regards Donald - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Port 3306
fwcmd=/sbin/ipfw... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GUI for Linux mySQL
Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: Is there a GUI for mySQL that will run on either linux server it self or on a remote machine I found Mascon but that doesn't seem to be able to connect to the remote server Please reply to [EMAIL PROTECTED] Tahnk you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem for localhost connection.....
did you edit /etc/resolv.conf? dyu wrote: Dear all, i m running mysql on freebsd webserver and using our own DNS server. Everything run fine with database and web serving. However, i m trying to change the DNS ip addresses to our isp's DNS server instead of ours on this webserver. Then i got the following error: st 'localhost.isp.net' is not allowed to connect to this MySQL server at /usr/local/stronghold/cgi-bin/xxx.cgi line 30 [Mon Jan 29 12:11:06 2001] [error] Died at /usr/local/stronghold/cgi-bin/xxx.cgi line xx. = Does anyone have any idea to solve this problem? i really appreciated. Thanks Derrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT - Cron
Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing a Table name
Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Corrupted tables
I've had some db corruption on a few occasions, and luckily I was running the following in a nightly cron...it has since first install saved my butt on many an occasion. http://www.ocsny.com/main/index.ocs?url=mysqlbackup It doesn't do anything magickal just uses mysqldump and a basic routine to auto discover the databases in your db and print them into straight sql...I have another cron job that runns shortly after that tars the data to tape and then they can be erased from disk... cheers, mikel "Kissandrakis S. George" wrote: Hello I have mysql 3.23.31 on x86 linux Some big tables .ISM get corrupted without any crash or shutdown of mysqld Any suggestions? -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Tel/Fax: (+30 892) 24450/23206 Phaistos Networks S.A. - A DOL Digital Company - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting MySQL
Yes stop the old and start the new...on a side note...should have bought DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on this sort of stuff. In any event safe_mysqld seems to be default on most sytems...Yes please get you security straight...if the app is colocated on the same server you can get away with localhost, however; if not then you must make an entry for each domain... Cheers, Mikel Carlos Corzo wrote: Hello, I bought MySQL by O'reilly. This thing is just as tough to read as the manual but I am trying and utilizing both. When we installed MySQL on our server, it seems to already be running. I was able to create a database and everything so I assume that it is running. The book says to run mysql in safe mode because it would restart the mysql server automatically if it goes down. Does everyone out there use safe_mysqld when running their servers? Do I need to stop the current server and restart it as safe_mysqld? That is the part I am most confused by, what to do now that I had already started it regularly. If anyone can help, that would be great. Also, if you just create a table as root and do not do anything with security and permissions, would a perl program written on any domain name on that server be allowed to access the database, or do I need to give special permission to that domain name. I am curious if I just give a host, "www.test.com", full access. I just get confused between the host and the user. Is the user just the name being used to log in to host? If so, when someone just executes the perl script from a call from the browser, do I have to specify any specific permissions there. They will not be running the script as the user I specify. I have read about the wildcard "%" option but that seems a little unsafe. Any help would be appreciated. I did my research before asking! Thanks. Isn't there a sample program out there that is simple, and quick that you could create a database and test your interface to make sure that you can start hacking away at some MySQL queries? This book has some and they are huge with no CD. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
In order to conserver bw I'll only through my $0.01 in...;) I do believe that if you search the list you will see that many of us who are not on the devteam do answer questions. Although I do whole heartedly believe in RTFM; I agree with you about the power of the people, and feel it is important for all of us to help by giving back to our community...;D Cheers, Mikel Neff Patrick K wrote: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I have had. Apparently I was wrong. You see I am a newbie too and what turned me on to mysql ,linux and the open source movement was the fact that it seems to focus on the power of people and there combined knowledge. I am not stupid and I can read in fact I have look over this manual about 100 times now the last four evenings. I apologize for wasting anyone's time but before I can become a valid contributor to a group dealing with a specific software I first have to be able to get the thing running. I in fact finally got mysql up and running last night but not one word in your manual helped me do it. So in fact all the reading in the world would have left me sitting in the same position. I am sorry to rant and rave but maybe if some seasoned user on this mailing list (not the developers) would help us newbies then we could all work together to. That is my two cents sorry to waste your time with it. -Original Message- From: Tnu Samuel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: Please read the manual Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have never paid a penny. For that money you get guaranteed answers. MySQL is free, support in this list is partially free but do not abuse it, then it can stay free in future. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php