Menu
What's new
By:
Filters

Linux VPS phpmyadmin, istalacja acc

Status
Not open for further replies.
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Witam

Ot?? po m?cz?cych 3 dniach zrobi?em ju? prawie wszystko. Teraz mam taki ma?y problem.

Nie mog? si? zalogowa? do phpmyadmin ani stworzy? acc ...

Gdy pr?buj? wpisa? dane jakie poda?em w configu, powiedzmy ?e wygl?da to tak :

Code: 
-- Database
    -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
    -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
    sqlType = "sqlite"
    sqlHost = "localhost"
    sqlPort = 3306
    sqlUser = "root"
    sqlPass = "scierwo"
    sqlDatabase = "theforgottenserver"
    sqlFile = "forgottenserver.s3db"
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType = "plain"

i w phpmy admin wpisuj?

name root
password scierwo

i pisze ?e z?e has?o

Code: 
B??d
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

tak samo w acc

Hostname - "localhost"
login "root"
password "scierwo"
daabase "theforgottenserver"

i wyskakuje

Code: 
# Could not connect to database.
# Could not find your database.

Co robi? ?le? Mo?e jak?? komend? trzeba uruchomi? amache2 na vps-ie ?
Help ;)
 
Grzechu

Grzechu

Senior User
Joined
Nov 29, 2008
Messages
1,263
Reaction score
93
Odp: Linux VPS phpmyadmin, istalacja acc

?eby uruchomi? apache u?yj komendy:
PHP: 
/etc/init.d/apache2 start
A czy wcze?niej da?e? komend??
PHP: 
apt-get install mysql-server
 
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Odp: Linux VPS phpmyadmin, istalacja acc

No z mysql to podstawa ;)

Co do apache, po wpisaniu komendy

Code: 
debian:~# /etc/init.d/apache2 start
Starting web server: apache2apache2: apr_sockaddr_info_get() failed for debian
apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
httpd (pid 19296) already running
.
debian:~#

Ale s?ysza?em ?e ten b??d jest nie gro?ny, i nie przeszkadza on w niczym.

Pisz? ?e jest
Code: 
already running
ale dalej wpisuj? root i pw i nie wczytuj? -.-

Wiesz ocb? Sk?d mi si? te nieznajome has?o wzi??o ; / Mo?e na ftp da si? jako? wyczyta? ?
 
Grzechu

Grzechu

Senior User
Joined
Nov 29, 2008
Messages
1,263
Reaction score
93
Odp: Linux VPS phpmyadmin, istalacja acc

Przy instalacji musia?e? poda? has?o jakie? :)
Jak wykonujesz komend?
PHP: 
apt-get install mysql-server
To podczas instalacji b?dziesz m?g? poda? has?o do mysql.
A jak nie to spr?buj tak
PHP: 
dpkg-reconfigure mysql-server

P.S
Spr?buj da? te? komend?
PHP: 
/etc/init.d/mysql restart
 
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Odp: Linux VPS phpmyadmin, istalacja acc

Jak instalowa?em phpmyadmin to zapyta?o mnie o has?o, i wpisa?em takie same jak mam w configu silnika. I gdy wpisuj? te has?o teraz w pma to nie wczytuje -.-

Gdy wpisuj?
Code: 
apt-get install mysql-server

to wyskakuje

Code: 
debian:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
  mysql-server: Depends: mysql-server-5.0
E: Broken packages
debian:~#


@edit

gdy wpisuj?

Code: 
dpkg-reconfigure mysql-server



to uzyskuj?
Code: 
 debian:~# dpkg-reconfigure mysql-server
/usr/sbin/dpkg-reconfigure: mysql-server is not installed
debian:~#

a gdy wpisz? :

Code: 
/etc/init.d/mysql restart

to
Code: 
debian:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
debian:~#

; /




@Edit

Dobra wiem ?e posiadam wersje 5.1 a nie 5.0 mo?e w tym problem ?

Wpisa?em

Code: 
dpkg-reconfigure mysql-server-5.1

i wysz?o jakie nowe pw...

wpisa?em nowe, powt?rzy?em i comend w putty

Code: 
debian:~# dpkg-reconfigure mysql-server-5.1
Stopping MySQL database server: mysqld.
Stopping MySQL database server: mysqld.
101002  7:55:38 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibX0NVZ4' (Errcode: 13)
101002  7:55:38  InnoDB: Error: unable to create temporary file; errno: 13
101002  7:55:38 [ERROR] Plugin 'InnoDB' init function returned error.
101002  7:55:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
debian:~#
ehh ;/ ?
 
Last edited:
Grzechu

Grzechu

Senior User
Joined
Nov 29, 2008
Messages
1,263
Reaction score
93
Odp: Linux VPS phpmyadmin, istalacja acc

Z tego co widz? to nie masz nawet zainstalowanego tego mysql-server :)
Daj pierwsze
PHP: 
apt-get update
apt-get upgrade
I dopiero p??niej spr?buj da? ponownie
PHP: 
apt-get install mysql-server
Jak nie zadzia?a to inaczej si? to zainstaluje :p

P.S
Jakie dawa?e? komendy aby zainstalowa? serwer? Oraz czy jak instalujesz acc to ??czy Ci normalnie z baz? danych?
 
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Odp: Linux VPS phpmyadmin, istalacja acc

No w?a?nie nie ??czy mi si? ...

To najpierw usun?? wersje 5.1 ? czy odrazu wklepa?
Code: 
apt-get install mysql-server

?

@edit

Wpisuj?

Code: 
apt-get install mysql-server

i w consoli sie nie istaluje tylko

Code: 
debian:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
  mysql-server: Depends: mysql-server-5.0
E: Broken packages
debian:~#
 
Last edited:
Grzechu

Grzechu

Senior User
Joined
Nov 29, 2008
Messages
1,263
Reaction score
93
Odp: Linux VPS phpmyadmin, istalacja acc

Musia?bym mie? dost?p do roota bo nie wiem co Ty tam namiesza?e? :)
Je?li mi podasz dane do putty to postaram si? pom?c.
Jak si? zgadzasz to wy?lij mi swoje gg lub msn na pw.
 
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Odp: Linux VPS phpmyadmin, istalacja acc

No nie wiem -.- Teraz przez twoje komendy w og?le nie mog? nic zrobi? -.-

Code: 
apt-get install mysql-server

to wyskakuje
Code: 
debian:~# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version.
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  mysql-server: Depends: mysql-server-5.0
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

a gdy
Code: 
apt-get -f install


to

Code: 
debian:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
  mysql-server-5.0
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server-5.0
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0B/26.7MB of archives.
After this operation, 83.8MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
(Reading database ... 32574 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-24+lenny4_i386.deb) ...
Aborting downgrade from (at least) 5.1 to 5.0.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-24+lenny4_i386.deb (--unpack):
 subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.0.51a-24+lenny4_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
debian:~#


grgr ; /
 
Grzechu

Grzechu

Senior User
Joined
Nov 29, 2008
Messages
1,263
Reaction score
93
Odp: Linux VPS phpmyadmin, istalacja acc

daj
PHP: 
apt-get install dpkg
Oraz poka? mi sources.list
 
Satellite

Satellite

Active User
Joined
Aug 30, 2010
Messages
128
Reaction score
7
Odp: Linux VPS phpmyadmin, istalacja acc

Code: 
apt-get install dpkg

wychodzi

Code: 
debian:~# apt-get install dpkg
Reading package lists... Done
Building dependency tree
Reading state information... Done
dpkg is already the newest version.
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  mysql-server: Depends: mysql-server-5.0
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
debian:~#

sources.list

Code: 
deb ftp://mir1.ovh.net/debian/ lenny main contrib non-free
deb-src ftp://mir1.ovh.net/debian/ lenny main contrib non-free

deb http://security.debian.org/ lenny/updates main contrib non-free
deb-src http://security.debian.org/ lenny/updates main contrib non-free

#~~~~~~Squeeze~~~~~~#
#deb http://mir1.ovh.net/debian/ squeeze main non-free contrib
#deb-src http://mir1.ovh.net/debian/ squeeze main non-free contrib

#deb http://security.debian.org/ squeeze/updates main contrib non-free
#deb-src http://security.debian.org/ squeeze/updates main contrib non-free

# Backports
deb http://www.backports.org/debian lenny-backports main contrib non-free
 
Status
Not open for further replies.
Top