Re: Mysql Web interface for normal Users
Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Web interface for normal Users
Vittorio Zuccalà ha scritto: You can also use phpmyadmin for normal user. In my organization i use it for all users... Uff... I didn't remember... If it is not enought you can use Dadabik (www.dadabik.org) It is great: do not be impressed from its simple interface. It is very completed software :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Web interface for normal Users
Vittorio Zuccalà wrote: Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode it will ask the user for their user name and password and use that information to decide which databases they have access to. - Jonathon Wardman, flutt.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Apparently OpenMosix won't work with MySQL because MySQL uses Shared Memory. There is apparently a component called MAASK which might help. Roy Nasser wrote: Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Go for a simple MySQL master - slave configuration. I'm runing 1 master 3 slaves for performance issues and doesn't have any problem at all for 1 year.. Of course in this case you should change some code in your webservers to direct SELECT queries to slave machine to gain performance on the master. I will also keep in touch with MySQL Cluster development and probably go for this in the near future. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: Roy Nasser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 4:58 PM Subject: MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL. P Roy Nasser [EMAIL PROTECTED] 06/18/2004 01:58 PM To: [EMAIL PROTECTED] cc: Subject:MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. -Mike From: Peter J Milanese [EMAIL PROTECTED] To: Roy Nasser [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:25:45 -0400 I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL. P Roy Nasser [EMAIL PROTECTED] 06/18/2004 01:58 PM To: [EMAIL PROTECTED] cc: Subject:MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ MSN Premium with Virus Guard and Firewall* from McAfee® Security : 2 months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. Daemons? Client side code? Can you explain this please? mysql handles all the replication. Depending on your setup, client won't know the difference. Its really all depends on how your replication is gonna be set up. - -- SUSHIDO--The way of the Tuna. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0xuZld4MRA3gEwYRAv1EAKCot3j1j16j892FtrTEea8Brlk0NgCcCKou 9K0QzPH4uFz+TYynwdNpxbY= =a/OR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
The meaning of that was client-side being sending inserts/updates to the master server. This would be done in the program/script upon an insert query. A daemon could forward insert/update requests to a master and all others round-robin and simply pass packets. This is if you have to make it seamless. Would require some work to make one though. -Mike From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. Daemons? Client side code? Can you explain this please? mysql handles all the replication. Depending on your setup, client won't know the difference. Its really all depends on how your replication is gonna be set up. - -- SUSHIDO--The way of the Tuna. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0xuZld4MRA3gEwYRAv1EAKCot3j1j16j892FtrTEea8Brlk0NgCcCKou 9K0QzPH4uFz+TYynwdNpxbY= =a/OR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Free yourself from those irritating pop-up ads with MSn Premium. Get 2months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Server ?
The one and only Apache web serverG Hi, I'm a MySQL newbie - Is there a MySQL Web Server product ? Oracle has their OWS (Oracle Web Server) for example. Can anyone reccomend a *very* lightweight web server with enough scripting ability to talk to MySQL - preferably for RedHat? Thx! __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.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: mysql web-based admin tool?
Hi, The most widely used tool to reach MySQL over PHP is phpMyAdmin. You can obtain it from http://www.phpwizard.net/projects/phpMyAdmin/ - Original Message - From: Ed Lazor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 5:53 PM Subject: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - 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 web-based admin tool?
Hi, On Tuesday 29 January 2002 16:53, Ed Lazor wrote: I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed Maybe it's phpMyAdmin... http://phpmyadmin.sf.net/ Regards, Matt - 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 web-based admin tool?
Phpmyadmin is pretty good for what you ar elooking for. You can find it at: http://www.phpwizard.net/projects/phpMyAdmin/ Gurhan -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:54 AM To: [EMAIL PROTECTED] Subject: mysql web-based admin tool? I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - 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 web-based admin tool?
Ed, Have you checked out phpMyAdmin? It can be downloaded at: http://phpwizard.net/projects/phpMyAdmin/ I use it with all my clients and it's great! For when I want a bit more control I Telnet, but most of the time I use this to help my with my databases. I used to use some php scripts that allowed me to work on my database. I'm trying to find them again... anyone know what they might have been called or where to find them? -Ed - 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 -- John McConnell Narwhal Design 126 Covered Bridge Road North Ferrisburgh, VT 05473 802.425.7037 [EMAIL PROTECTED] http://www.narwhaldesign.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
Re: Mysql+web+????
I intend to use linux for the server, mysql for the database, php for the web-forms. but what is with the diagramms? They were not pregenerated, they must be generated as a result of the user parameters. GD might be able to do what you want.. www.boutell.com/gd uhm.. quite sure :-) mysql, query Bye, 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
Re: MySQL Web Site Changes
The new web site looks great and none of the old functionality has been lost. Except ... On the documentation listing for one-page-per-chapter and one-big-page, the keywords and commands, like 'SELECT' and 'GRANT' used to be in a different color (purple in that case) which made it very easy to scan through the document to find the command you needed (especially when the order was changed so that the commands weren't all listed in Chapter 7). Can that color-change be reimplemented? It's incredibly useful for day-to-day use of those chapters. And let's put in the word 'MySQL' to get around the spam filters. Thanks, Philip * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [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
Re: MySQL Web Site Changes
Philip Molter writes: The new web site looks great and none of the old functionality has been lost. Except ... On the documentation listing for one-page-per-chapter and one-big-page, the keywords and commands, like 'SELECT' and 'GRANT' used to be in a different color (purple in that case) which made it very easy to scan through the document to find the command you needed (especially when the order was changed so that the commands weren't all listed in Chapter 7). Can that color-change be reimplemented? It's incredibly useful for day-to-day use of those chapters. And let's put in the word 'MySQL' to get around the spam filters. Thanks, Philip * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [EMAIL PROTECTED] I have forwarded your message to our Web team. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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
RE: MySQL, Web Objects 5: job connection problems
Hi !! )-Original Message- )From: Paul Schreiber [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 1:21 PM )To: Web Objects admin; Web Objects newsiest; Web Objects dev; MySQL List )Subject: MySQL, Web Objects 5: job connection problems ) ) )Comfit: )* Mac: Mac OS X 10.0.4; java 1.3.1; MySQL 3.23.32 )* Linux: Linux 2.2.19/defiant testing; java 1.3.1; MySQL 3.23.36 ) )I *really* could use some help here. I need to get MySQL up and running; )I've been at it for 2 days and can't get my WO app to see it, whether I )try on Linux or OS X. ) )Here's the scoop ... let's try OS X first: )* .jar files belong in /Library/Java/Home/lib/ext/ )* In Remodeled: ) URL: jdbc:mysql://localhost/newsie ) Driver: org.gjt.mm.mysql.Driver )* MySQL is up and running, and I created a database newsie ) )* EOModeler gives this error )JDBC connection failed for driver :'org.gjt.mm.mysql.Driver'. Driver not )found in Java Runtime! Please verify your C35LASSPATH environment )variable. )The current CLASSPATH for your application is : )/Developer/Applications/EOModeler.app/Contents/Resources/Java/eomodeler.zi )p:/Users/paul/Library/Java:/Library/Java:/System/Library/Java:/Network/Lib )rary/Java:/System/Library/Frameworks/JavaVM.framework/Classes/classes.jar: )/System/Library/Frameworks/JavaVM.framework/Classes/ui.jar:/Library/Java/H )ome/lib/ext/mm.mysql-2.0.6.1.jar:/Developer/Applications/EOModeler.app/Con )tents/Resources/Java/eomodeler.zip ) ) )On Linux: )* .jar files belong in /usr/local/jdk1.3.1/jre/lib/ext/ ) I had the same problem couple of days back when I downloaded 2.0.6.1.jar file from the same web site. But surprisingly, this is not a jar file, it is a source zip/tar file. you can see the file size as 382 KB. When I set my CLASSPATH to this jar file(2.0.6.1.jar) I get the same error saying driver can't be loaded, because this is not a jar executable. Using winzip/tar when I extracted the files from this jar file, then you get the real sources and the real jar file with the name (mm.mysql-2.0.6.jar with size 102 KB). Later I pointed my CLASSPATH to the extracted jar file and worked out well. But I did all these on Windows 200. The problem is in the web, the file name looks like this: mm.mysql-2.0.6.1.jar, but it should be mm.mysql-2.0.6.1.src.tar. Hope this should fix your problem. Let me know the outcome of it. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.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