Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

install Mysql on a server...

Quote Reply
install Mysql on a server...
Hi,
I need some help installing Mysql on a server to make links MYSQL work...Here is my problem:
- every time I try to upload the .rpm files, the server says I not allowed to upload in that directory... I TRIED IN /usr/local, /usr/bin and a lot like that but none work...
Any advice???
Thanx in advance,

theuls

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
Do you have root access on the server? If so, just ftp the files into /tmp, then log on as root and install the rpm's using something like:

rpm -Uvh [rpm name here]

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: install Mysql on a server... In reply to
In order to do _system_ work, you need to be "root".

If you mange your own server, (dedicated, manged, co-lo) box, you need to get the "root" password.

If you don't know what I'm talking about, you need to contact your ISP (whomever set up your machine).

Hopefully, you are _not_ using the same password for "root" access that you are for general access. The "root" password should be something hard to remember, and locked up in a safe, that requires 2 people to authenticate, and fingerprint/retinal identification. <G>

Not really, but anyone with the root password can do anything to your machine.... literally, anything. "root" is a magic user.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
Hi,
Well, I do have the root access, and I did what you said (with the telnet and ftp), but now I'm having another problem (just to let you know, I have the right version of Mysql for the server: I got it on their homepage):
I'did the command "rpm -Uvh [rpm name here]" for installing the Mysql on the server. Doing that it wrote at one point:
...
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
...
I tried that command, but it said folder unknow. Since it said it was very important, well I tried to uninstall it by doing these two command in a row I saw on a homepage telling how to uninstall:
"rpm -e MySQL" and
"rm -Rf /var/lib/mysql"
the first one work but not the second...
Since it's not my server but somebody else's, I didn't do anything more. Please Alex, Pudog or somebody else, tell me what to do, I really want this to work.
Please please please help,

theuls

BTW: thanx for your response...


---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
Enter as root; and search for mysql;
i know rpm-technique is a fine thing; but under linux there are enough secrets for me, so i do some things manually;
if you cant set the admin-pass like you have written, you mysql is probably set at another path.
Mine e.g. resides under /usr/local/mysql and not under /usr/bin/
Cause ido the install manually i know where it resides :-)

To get more in contact with your system start the mc and browse tru the filesystem, looking for places ...
Just another thing, if you are new with linux, is to install the webmin-system; with this you should set your admin-pass for mysql, too - the german mirror is found at www.webmin.de; think the us at .com.
Installing is a snap; download the file; decompress it to a temp; and start the setup-file (more to know in readme)
choose all the standards to do (maybe you want the ssl-option, then you must download both parts first ... more in readme, too)

Next thing is to download the phpMyAdmin; search it at freshmeat.com or try to find it at php3.com (sorry, dont know the URLs)
Robert

Quote Reply
Re: install Mysql on a server... In reply to
I don't use Linux, so I don't know the defaults,

but

/usr/bin/mysqladmin -u root password 'new-password'

you need to replace the /usr/bin/ portion with the path to the mysqladmin program.

On solaris, my MySQL is in /usr/local/mysql/bin

So, my path would be /usr/local/mysql/bin/mysqladmin

BTW ... if you install MySQLMan, you can change all the user passwords (including root) by editing the 'mysql' table.

You of course need the 'old' password to gain root access to the MySQLMan program as "root" to make those changes.







http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
Thanx for your replies!!
Well here is what happened: I did the unistall, and than mysqladmin showed up!!!! :) I'm so happy!!! I have installed MySQL on a server!!!!!
But now, there is a new "problem". I trued to use Mysqlman, but it said:
CGI ERROR
==========================================
Error Message : DBI.pm not found! You can find this at: http://www.perl.com/CPAN/modules/by-module/DBI/
Error loading required libraries.
...
Does that mean have o install something else???? again???
I went on the website, but I don't know which one to choose.
Please help,


---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
Ok,

The easiest way to install DBI is to use the CPAN module.

It takes a bit of getting used to, but you can't really do much damage with it. I don't know where to find docs on using CPAN, but checking the CPAN site, or perl.org would be a start.

As root (since you need to write to system directories) type:

perl -MCPAN -eshell


If you have the paths to perl set up for root, it should load, or give you instructions on what to do.

Here's the main doc page for that (I found it)
http://18.85.40.23/INSTALL.html



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
I know this problem:

On a normal server you have intstalled "pure perl"; cause LinksSQL needs some special functions you have to install some bibliotheques (is this the right word?);
all you must do is download them; decompress in a temp; and follow the instructions in readme (something like:
perl Makefile.PL
make
make test
make install

I have done this four times with:
DBIx-Easy- ...
DBIx-CGI ...
DBI-1_13...
and msql-Mysql-modules

You find these modules at:

http://www.perl.com/CPAN/modules/by-module/DBI/

Look for the newest version!

Thatīs it.

Robert


Quote Reply
Re: install Mysql on a server... In reply to
Thanx again for your responses!!!
I did what was asked, and here is my problem:
I try do do the unpach with tar -xof yourmodule.tar
Then the command line does as if I entered "enter"!!! And nothing happens!!!
Please help,

theuls

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
is it ok to decompress in all on my computer???

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
There shouldn't be any problems decompressing the files.

The CPAN module will delete older downloads/archives/temp files automatically the next time you run it.

It sets up a working area in your home directory, and works out of that. Then, it installs the stuff in the system directories. You can freely delete the stuff in your home directory, but CPAN manages the space pretty well on it's own, actually.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
Actually there is:
When I try to decompress here is exactly what happens:
the first command "gzip -d yourmodule.tar.gz" works fine because mymodule.tar.gz becomes mymodule.tar
But the second one "tar -xof yourmodule.tar" doesn't do anything at all...
I also tried to uncompress it on my computer and than upload it, but when I "launched" Makefile.PL, it didn't find a sript that existed.
Thanx again for your responses guys,

theuls

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
1) make sure the file is really called yourfile.tar (sometimes it's not).

2) the command I use is -xf or -xvf, I'm not sure what the 'o' does.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
hi again,
well here is what happened, I did:
tar -xvf /tmp/DBI-1.14.tar
and it showed:
DBI-1.14/
DBI-1.14/lib/
DBI-1.14/lib/DBD/
DBI-1.14/lib/DBD/ExampleP.pm
DBI-1.14/lib/DBD/Proxy.pm
DBI-1.14/lib/DBD/NullP.pm
DBI-1.14/lib/DBD/Sponge.pm
DBI-1.14/lib/DBD/Multiplex.pm
DBI-1.14/lib/DBD/ADO.pm
DBI-1.14/lib/DBI/
DBI-1.14/lib/DBI/Shell.pm
DBI-1.14/lib/DBI/FAQ.pm
DBI-1.14/lib/DBI/ProxyServer.pm
DBI-1.14/lib/DBI/DBD.pm
DBI-1.14/lib/DBI/W32ODBC.pm
DBI-1.14/lib/DBI/Format.pm
DBI-1.14/lib/Bundle/
DBI-1.14/lib/Bundle/DBI.pm
DBI-1.14/lib/Win32/
DBI-1.14/lib/Win32/DBIODBC.pm
DBI-1.14/DBI.xs
DBI-1.14/t/
DBI-1.14/t/meta.t
DBI-1.14/t/dbidrv.t
DBI-1.14/t/examp.t
DBI-1.14/t/subclass.t
DBI-1.14/t/proxy.t
DBI-1.14/t/basics.t
DBI-1.14/t/shell.t
DBI-1.14/Perl.xs
DBI-1.14/DBIXS.h
DBI-1.14/MANIFEST
DBI-1.14/Driver.xst
DBI-1.14/Changes
DBI-1.14/dbipport.h
DBI-1.14/Makefile.PL
DBI-1.14/test.pl
DBI-1.14/README
DBI-1.14/dbd_xsh.h
DBI-1.14/dbish.PL
DBI-1.14/dbi_sql.h
DBI-1.14/ToDo
DBI-1.14/DBI.pm
DBI-1.14/dbiproxy.PL

I thought that everything went right, and I was happy!!!
But no, it didn't change anything!!!!!
I tried to do it in other directories, but it didn't change anything... Why does it do this??? is the tar not well installed???? is it a question of permissions?????Please help!!!!

theuls

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
If you 'untared' in the /tmp directory, then you should see a directory /tmp/DBI-1.14

Follow the directions for it.

Really, you should use the CPAN module, since once you set it up, it will make sure to install the downloads into the right places.

You need to probably be 'root' to untar into the /tmp directory.

You also need to be 'root' to run the install program.

Check the README for instructions on how to install.


http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
One thing i hate on linux is the must to know all the different parameters with different calls.
For decompress-things i always rename a ...tar.gzp to ...tar.tar and then use the mc (midnightcommander) to decompress (just press return on the file) and copy (F5) all files to a temp.
So its an easy way and i just add the cpans for perl and DB a douzend times in just a minute without problems.

Robert

Quote Reply
Re: install Mysql on a server... In reply to
Try:

cd /tmp/DBI-1.14
perl Makefile.PL
make
make test
make install

in that order. However pugdog is right, learn to use CPAN module, it is your friend. =) Try:

perl -MCPAN -e shell

to start it up. Once you go through the intial config, you just type install DBI.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: install Mysql on a server... In reply to
I finally did it, it worked :) :)
here is what I did:
cd /tmp
and just followed the installation after!!!

theuls

BTW: How much can I asked to the guy for this installation????

---------------------------------
surfootball.com your soccer index
Quote Reply
Re: install Mysql on a server... In reply to
What do you mean? Cost of installing the program?

Well, anything you want :)

Extra effort is extra cost -- such as having to install modules that were not installed, etc.

Pricing is up to you, everyone does it a bit differently, but hourly rates are in the $35-$150 or more range. Also, rates are different for installation where you have time to do other things, rather than programming which occupies your full attention.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: install Mysql on a server... In reply to
Well it took me about 10-15 hours for the whole thing... But I'm not gonna asked for 15*150$, since a professionnal would have taken "only" 3-4 hours (I think).
Do you think 200$ is a lot for installing MySQL + DBI + MySQL.pm????

theuls


---------------------------------
surfootball.com your soccer index