Attempting to set up MyRUNUO

[Pyro-Tech]

Attempting to set up MyRUNUO

im trying to set up my runuo for my server, and i have followed the directions in the pdf thus far....but when i try to run the mysql database, i get an error saying it can't locate my LIBMYSQL.dll i tried reinstalling like it says may fix it, but doesn't seem to work

anyone able to help?

 

[Jason]

Then you don't have the file... You will have to download it if you want it to work.

 

[Pyro-Tech]

im not some dumb ass.....i installed as is, and this is all that is with the install, and i doubt that they would release something incomplete

and i did a search of my files, and the file is there

oh well....i tried what i can think of, might as well see if i can download anything

 

[stormwolff]

Are you trying to run it formt he winmyqladmin.exe link? Thats not really mysql if you are. You have to go into the command prompt and run the mysql startup command. It should be net start mysql. That will get the server running, then you will need to change the passwords for root and whatever else to get myrunuo running.

I suggest getting mysql navigator

http://www.phpmyadmin.net/home_page/

Easy tool to change your password if mysql is running

and
phpymyadmin

http://www.phpmyadmin.net/home_page/


easy tool tool to configure databases and access

 

[Pyro-Tech]

yeah i was trying the .exe.....what is the command to start it? i did the thing that the little tutorial says about mysql -u root mysql.....but it tells me that it can't connect to mysql database.....so i figure that means that it isn't running as i haven't ran anything yet

 

[Pyro-Tech]

nm....i saw the command....and tried it and it gives me this line....i try the help command it gives me and it doesn't do me much good either

D:\Files for MyRUNUO\mysql database\bin>net start mysql
The service name is invalid.

More help is available by typing NET HELPMSG 2185.


D:\Files for MyRUNUO\mysql database\bin>net helpmsg 2185

The service name is invalid.


EXPLANATION

You tried to start a service that is not configured on this system.

ACTION

Check the spelling of the service name or check the configuration information fo
r the service using the Services option from Server Manager.



D:\Files for MyRUNUO\mysql database\bin>

so.....what does this mean?

 

[stormwolff]

For some reason its not seeing it installed.

Try installing it on the same drive as windows in its own directory. If thats d: then try d:\mysql.

 

[Jason]

Why don't you just start the service...

Never had a problem, there is a nice tool they have which is a GUI basicly.

www.mysql.com

I just remember doing any of the other suggestions, spent many months working on a private project with MySQL and Apache, and PHP so I know.

 

[Pyro-Tech]

SormWolf.....im going to try this now, but i don't think that is it....windows sees it in my add/remove programs thing on the control panel.....so i dunno

Jason.....just trying to run the service is what im trying to do now....and the damn thing won't run

hehe....i never messed with this kind of stuff before.....damn what a headache lol

EDIT: ok i tried it and it starts giving me the same crap

 

[LtLDevil]

Watch those spaces....

Uninstall it and install it to a path which has no spaces in it.
You can't have any spaces in the source location..
Install it like this: -- C:\MySQL is a good location, its also the default i believe..
cd to mysql directory, then run: net start mysql
this should install it as a service.
once running, follow Zulu's instructions very carefully and very slowly, making sure to type in everything specified, including punctuation.
If you have any issues post back, and we'll try to help you through em.

SormWolf.....im going to try this now, but i don't think that is it....windows sees it in my add/remove programs thing on the control panel.....so i dunno

Jason.....just trying to run the service is what im trying to do now....and the damn thing won't run

hehe....i never messed with this kind of stuff before.....damn what a headache lol

EDIT: ok i tried it and it starts giving me the same crap

 

[Pyro-Tech]

Still getting the same thing

C:\mysql>net start mysql
The service name is invalid.

More help is available by typing NET HELPMSG 2185.


C:\mysql>net helpmsg 2185

The service name is invalid.


EXPLANATION

You tried to start a service that is not configured on this system.

ACTION

Check the spelling of the service name or check the configuration information fo
r the service using the Services option from Server Manager.



C:\mysql>

 

[LtLDevil]

Do this to test your distro...

Please try this and tell me what you get back:

Make sure you are in the directory where the server is located, then enter this command:
C:\mysql\bin> mysqld --console
For servers that include InnoDB support, you should see the following messages as the server

starts:
InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist:
InnoDB: a new database to be created!
InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 31457280
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: creating foreign key constraint system tables
InnoDB: foreign key constraint system tables created
011024 10:58:25 InnoDB: Started

When the server finishes its startup sequence, you should see something like this, which
indicates that the server is ready to service client connections:

mysqld: ready for connections
Version: '4.0.14-log' socket: '' port: 3306

Still getting the same thing

C:\mysql>net start mysql
The service name is invalid.

More help is available by typing NET HELPMSG 2185.


C:\mysql>net helpmsg 2185

The service name is invalid.


EXPLANATION

You tried to start a service that is not configured on this system.

ACTION

Check the spelling of the service name or check the configuration information fo
r the service using the Services option from Server Manager.



C:\mysql>

 

[Pyro-Tech]

C:\mysql\bin>mysqld --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
040611 14:17:09  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040611 14:17:09  InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040611 14:17:10  InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040611 14:17:15  InnoDB: Started
mysqld: ready for connections.
Version: '4.0.20a-debug'  socket: ''  port: 3306

ok this is what i am looking at now......so do i close this or keep it running?

 

[LtLDevil]

OK
we are in good shape my friend, sorry bout the time, i'm in the process of an AD upgrade...

Next:

Before installing MySQL as a Windows service, you should first stop the current server if it is running by using the following command:

C:\mysql\bin\mysqladmin -u root shutdown

This invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut down. The command connects as root, which is the default administrative account in the MySQL grant system. Please note that users in the MySQL grant system are wholly independent from any login users under Windows.

Now install the server as a service:


C:\mysql\bin\mysqld --install

Tell me where we stand after this step...

C:\mysql\bin>mysqld --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
040611 14:17:09  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040611 14:17:09  InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
040611 14:17:10  InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
040611 14:17:15  InnoDB: Started
mysqld: ready for connections.
Version: '4.0.20a-debug'  socket: ''  port: 3306

ok this is what i am looking at now......so do i close this or keep it running?

 

[Pyro-Tech]

C:\mysql\bin>mysqladmin -u root shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\mysql\bin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306.
No connection could be made because the target machine actively refused it.


C:\mysql\bin>

i did it....got the error...tried the telnet thing....got that

 

[LtLDevil]

All that shows is that the server is not currently running.. Which is good.

Now do the : C:\mysql\bin\mysqld --install

And tell me what you get...

C:\mysql\bin>mysqladmin -u root shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\mysql\bin>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306.
No connection could be made because the target machine actively refused it.


C:\mysql\bin>

i did it....got the error...tried the telnet thing....got that

 

[Pyro-Tech]

YAY!!!!

says it is successfully installed

EDIT: allright...thanks for the help....still can't get anything out of it, but now i have to go to work...ill be back on later tonight so....thanks for the help

 

[Pyro-Tech]

i like your MyRunUO for dummies...but i have a problem still

i went through the whole thing.....and in iis it seems fine...but when i do the test link, it pulls a thing to do a find and says it can't be found

and in iis if i select brows web, it says i don't have permission

i can't tell i fi messed it up somewhere or what

 

[LtLDevil]

Don't use the actual link in my post, you'll have to modify that link with the virtual folder info you specified.
for example... You created a virtual folder named MUO, and the physical location of the data is d:\runuo\web\myrunuo\.

When you open your browser, and type your link in, it goes to the path of the virtual folder like so : http://localhost/MUO/status.asp

Also you may have to set permissions on your physical directory to let aspnet have full control of everything inside the folder.
Set you IIS permissions to allow anynomouns logins too.

Let me know if takes care of you.

i like your MyRunUO for dummies...but i have a problem still

i went through the whole thing.....and in iis it seems fine...but when i do the test link, it pulls a thing to do a find and says it can't be found

and in iis if i select brows web, it says i don't have permission

i can't tell i fi messed it up somewhere or what

 

[Zulu]

update

Getting .aspx pages to work!

??QUESTION?? Which one did you install first? IIS or .NET framework?

You can check by doing the following steps:

1)- Open up the Internet Information Services
2)- Go to Default Web Site, right click then select Properties.
3)- Select Home Directory Tab then click on Configuration button. This will open another screen with a list of Application Mappings. If you don't see .aspx on the list then your IIS was not configured to display .NET aspx file type; this happens because IIS was installed after the installation of the framework. If you install IIS before the .NET framework then you will not have this problem.

You can fix this by:

1)- Reinstall .NET framework
2)- Execute this file C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\aspnet_regiis.exe -i (Do not forget the -i)

*********OR************

3) C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i (Do not forget the -i)