[solved] problem with login to DA, and with writing to mysql database
Hello
I`m happy user of DA for 3 months
But today, i m swithing my communicator on, and I`m getting lots of messages from my users that work on mysql, they saying that they can`t write to mysql, or create simple table or whatever. With reading everything is ok.
So i trying to login to DA to see on logs what went bad. But: i can`t login to DA!
I`m giving a login and password and i`m getting: "Invalid login. Please verify your Username and Password"
And i can login as an admin, or normal user...
I search on forum, and i found that this can be problem of full hdd, but:
server:/usr/local/directadmin# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 109G 45G 58G 44% /
tmpfs 475M 0 475M 0% /dev/shm
/dev/hdb1 111G 25G 81G 24% /backup
server:/usr/local/directadmin#
So disk isn`t full, also, by a ssh level i can write to files and create new ones.
I don`t have any ideas what it can be.
If you have any suggestions, I ll be very gratefull
ps. sorry for my english
btw: this message i m getting when i try to create sth in mysql:
"CREATE TABLE `test` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`tbla` VARCHAR( 5 ) NOT NULL
) TYPE = MYISAM
MySQL zwrócił komunikat: Dokumentacja
#1 - Can't create/write to file '/usr/local/mysql/data/editool_actag/test.MYI' (Errcode: 13)
"
edit: to solve problem i tried on my debian to restart DA, after /etc/init.d/directadmin restart , everything went down, directadmin didn`t get up,
also:
server:/usr/local/directadmin# /usr/local/directadmin/directadmin d
server:/usr/local/directadmin# ps aux | grep directadmin
root 2326 0.0 0.1 2700 1000 ? Ss Aug12 0:00 /usr/local/directadmin/da-popb4smtp
root 5726 0.0 0.0 1840 608 pts/0 S+ 12:03 0:00 grep directadmin
server:/usr/local/directadmin#
Problem solved.
I had just bad permission with mysql files, and with /usr folder. That`s why all goes crazy.
Hello
I`m happy user of DA for 3 months
But today, i m swithing my communicator on, and I`m getting lots of messages from my users that work on mysql, they saying that they can`t write to mysql, or create simple table or whatever. With reading everything is ok.
So i trying to login to DA to see on logs what went bad. But: i can`t login to DA!
I`m giving a login and password and i`m getting: "Invalid login. Please verify your Username and Password"
And i can login as an admin, or normal user...
I search on forum, and i found that this can be problem of full hdd, but:
server:/usr/local/directadmin# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 109G 45G 58G 44% /
tmpfs 475M 0 475M 0% /dev/shm
/dev/hdb1 111G 25G 81G 24% /backup
server:/usr/local/directadmin#
So disk isn`t full, also, by a ssh level i can write to files and create new ones.
I don`t have any ideas what it can be.
If you have any suggestions, I ll be very gratefull
ps. sorry for my english
btw: this message i m getting when i try to create sth in mysql:
"CREATE TABLE `test` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`tbla` VARCHAR( 5 ) NOT NULL
) TYPE = MYISAM
MySQL zwrócił komunikat: Dokumentacja
#1 - Can't create/write to file '/usr/local/mysql/data/editool_actag/test.MYI' (Errcode: 13)
"
edit: to solve problem i tried on my debian to restart DA, after /etc/init.d/directadmin restart , everything went down, directadmin didn`t get up,
also:
server:/usr/local/directadmin# /usr/local/directadmin/directadmin d
server:/usr/local/directadmin# ps aux | grep directadmin
root 2326 0.0 0.1 2700 1000 ? Ss Aug12 0:00 /usr/local/directadmin/da-popb4smtp
root 5726 0.0 0.0 1840 608 pts/0 S+ 12:03 0:00 grep directadmin
server:/usr/local/directadmin#
Problem solved.
I had just bad permission with mysql files, and with /usr folder. That`s why all goes crazy.
Last edited: