u3 rev application with mysql/apache

Wed Aug 2 15:33:11 EDT 2006

Viktoras
thanks for the help I am not having any luck getting it to work so I guess I
need to ask a few more questions. I have been using xampp for the mysql
install now that I understand that I do not need the apache is there
something else I should use? where should I place all the apps, all in one
dir or separate, here is how it is setup right now on the flash drive
rev application is in the root
mysql is in the xampp\mysql\

I also notice that if I move my flash drive to a different computer and the
drive letter changes like from l to m and I click on the mysql_start I get a
error message is there a way to correct this so that it will change to the
proper drive letter?

also this line  "-password=kristupukas shutdown"  in your code should I be
changing it to  "-password=mypassword shutdown"

is this correct from below?
on startup
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end startup

Robert Mann
President
GP Racing LLC

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Viktoras
Didziulis
Sent: Wednesday, August 02, 2006 10:28 AM
To: How to use Revolution
Subject: RE: u3 rev application with mysql/apache

Hi Robert,

try this with 3 buttons:

#start the server
on mouseUp
set the hideConsoleWindows to true
open process "MySQL Server 5.0\bin\mysqld" for neither
end mouseUp

#stop the server
on mouseUp
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end mouseUp

#show server status
on mouseUp
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas status"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
answer it
end mouseUp

This should do the job.

Instead of using buttons you may want to load server (scripts of the stack):

on startup
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end startup

and close it with:
on closeStack
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end closeStack

Viktoras

-------Original Message-------

From: Robert Mann
Date: 08/02/06 14:50:19
To: How to use Revolution
Subject: RE: u3 rev application with mysql/apache

Not sure how to code the call to start the mysql is there a sample out there

somewhere?

Thanks

Robert Mann
President
GP Racing LLC

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Viktoras
Didziulis
Sent: Wednesday, August 02, 2006 2:39 AM
To: How to use Revolution
Subject: RE: u3 rev application with mysql/apache

Hi,

You have to call Mysql from the main application while it is loading or on
demand. Autorun wont start it automatically from a thumbdrive.

Viktoras

-------Original Message-------

From: Robert Mann
Date: 08/02/06 00:46:09
To: How to use Revolution
Subject: RE: u3 rev application with mysql/apache

tying to get your suggestion to work I have it so that it opens my app which

is the first 5 lines but I am not able to get the mysql started here is my
autorun.inf

[autorun]

action=SNmain.exe
open=/SNmain/Windows/SNmain.exe
shellexecute=/SNmain/Windows/SNmain.exe
shell\Auto=&SNmain.exe
shell\Auto\command=/SNmain/Windows/SNmain.exe

action=xampp_start.exe
open=/xampp/xampp_start.exe
shellexecute=/xampp/xampp_start.exe
shell\Auto=&xampp_start.exe
shell\Auto\command=/xampp/xampp_start.exe

Icon=sn.ico
shell=Auto
label=Suspension Network

Robert Mann
President
GP Racing LLC

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Viktoras
Didziulis
Sent: Monday, July 31, 2006 3:16 PM
To: How to use Revolution
Subject: Re: u3 rev application with mysql/apache

Hi Robert,

you do not need U3 drive for this. Some cool things can be done with
ordinary flashdrives. For MS Windows you use Autorun.inf like this:[autorun]

action=NAME_OF_YOUR_APP
open=your_app.exe
shellexecute=your_app.exe
shell\Auto=&NAME_OF_YOUR_APP
shell\Auto\command=your_app.exe
Icon=your_icon.ico
shell=Auto
label=NAME_OF_YOUR_APP

What you get is:
1) after insertion of the flashdrive your_icon will appear instead of the
default flashdrive icon;
2) if autoplay on users machine is enabled it will show NAME_OF_YOUR_APP
with your_icon as the first choice in autoplay menu and will allow to launch

your app from there;
3) it will launch the application on doubleclicking the flash_drive's icon
(your_icon)
4) it will provide the first option in the context menu as NAME_OF_YOUR_APP
(upon right mouse-click on flash-drive's icon)
5) it WILL NOT launch your application automatically on startup, which is
good from a security point of view...

For MacOS this tool can be of some use:
http://www.naratt.com/MultipleLauncher.html

I think it is more than enough for a non-U3 drive. I am also bundling my
Contents Management Soft with Apache this way :-).

All the best
Viktoras

-------Original Message-------

From: Robert Mann
Date: 07/31/06 22:19:27
To: rev list
Subject: u3 rev application with mysql/apache

I am building a rev standalone that works in conjunction with a mysql
database, so If I bundle a install I need to also check first to see if
apache is installed if not then install it with a mysql database, so was
thinking that maybe this new u3 drive I can preinstall everything on it so
then all I need to send the use is a flash drive, any thoughts as to is this

will be possible to run apache/mysql/rev application all within a u3 flash
drive?

Robert Mann
President
GP Racing LLC

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution