Debian 7

MySQL management disappear

Hi all,

I've got also a DEbian 7 server but after an upgrade the MySQL management disappear from the control panel.
MySQL is running fine and I've also upgraded to 5.5 without an issue. Same for PHP 5.3 (it was 5.2).

Any ideas?

Thanks
 
Hi all,

I have already upgraded approx 20 servers to debian 7- 64 bits (keeping the debian 6 version of DirectAdmin), and the only issue was that I had to recompile exim.
Some are running php 5.4, some 5.3 and the rest is still running 5.2.

They all run fine !

Dan
 
webmaster-hub said:
Hi all,

I have already upgraded approx 20 servers to debian 7- 64 bits (keeping the debian 6 version of DirectAdmin), and the only issue was that I had to recompile exim.
Some are running php 5.4, some 5.3 and the rest is still running 5.2.

They all run fine !

Dan
Click to expand...

Sounds great! What commands did you use to upgrade from debian 6 to 7?
 
Hi,

Simply "apt-get update" followed by "apt-get dist-upgrade" after editing /etc/apt/sources.list and replacing "squeeze" by "wheezy"
 
Just wanted to add to this discussion.
Tried installing a new DA box on fresh Debian 7.1 64-bit today and ran into some problems.

First attempt:
- Custombuild 2.0
- nginx
- PHP 5.5 (php-fpm)
- MySQL 5.6

DirectAdmin did not finish installing.

Second attempt:
- Custombuild 2.0
- nginx
- PHP 5.4 (php-fpm)
- MySQL 5.5

Install went OK and I was able to login to DA, however MySQL, exim, pureftp and dovecot was not running. I tried "./build all d" and then starting the services using both DA and SSH but it did not work.


I have emailed DA guys now asking them to swap my license OS to Debian 6 for now.
 
Hello,

Thanks for the feedback...
Note that changing the OS set in the license file only affects the update.tar.gz being downloaded.
It does not affect the service pack or custombuild.
If there are compile issues with custombuild, it's preferred to sort out what the are and resolve them.
Since dovecot didn't get compiled, it's likely that there was a compile issue earlier down the line.. so running
Code: 
cd /usr/local/directadmin/custombuild;
./build all d
would likely tell us where it's stopping, and why.

Also, for CB2.0, it's recommended to grab the pre-release binaries as there are important template changes to make things work better.

John
 
Thanks John

Perhaps I was a bit fast on the trigger there. If I wanted to give Debian 7 another go, could I do that with my current license? I mean, without changing back to Debian 7 as license OS? I don't know what the contents of "update.tar.gz" is, hence my stupid questions.
 
You are more than welcome to try again, any OS you'd like.
We can change the OS in the license if you need (again, only affects the update.tar.gz)

John
 
I want to make Debian 7 work.
So if it only affects "update.tar.gz" I don't need to change it? I can just fire away?
 
Correct.

However, the Debian 6 binaries are linked against libmysqlclient.so.16.
The Debian 7 binaries are static.

So, the only catch is, if you install a newer version of MySQL that doesn't have libmysqlclient.so.16, then you just need to manually download it and finish the install (./directadmin i; ./directadmin p)

The other bits (apache, php, dovecot, etc.. ), everything in custombuild is independant of which OS is in the license file.

John
 
OK, so I did a restore and went for DA on Debian 7 again. Install did not work and I got errors:

Code: 
./directadmin: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory
./directadmin: error while loading shared libraries: libssl.so.0.9.8: cannot open shared object file: No such file or directory

According to: http://help.directadmin.com/item.php?id=267 this is due to incorrect OS.

So I guess it's not possible to install DA on Debian 7 using a license that says "Debian 6". Maby I didn't understand you correct John.
 
Hmm.. My apologies, I may have forgotten those other linked libraries.
If you have a moment, send us an email with your license ID number to support@ and I'll swap the OS to Deb 7 right away, and will include how to grab the binaries without needing to re-install.

John
 
I already sent an email to sales, but I will forward it to you now.

Thank you!
 
Thanks to John I am up and running again. I had to build dovecot, ftp, zend and ioncube with custombuild again once install finished.
Now everything except MySQL is working. I can start MySQL from both SSH and DA but then it closes right back down.

I tried "./build mysql" and also added this:

Code: 
mysql.default_socket=/var/lib/mysql/mysql.sock
mysqli.default_socket=/var/lib/mysql/mysql.sock
pdo_mysql.default_socket=/var/lib/mysql/mysql.sock

To my php.ini.

Code: 
# ls -la /var/lib/mysql/mysql.sock
ls: cannot access /var/lib/mysql/mysql.sock: No such file or directory
 
During "./build all d" I get this:

Code: 
Restarting php-fpm54.
Gracefully shutting down php-fpm54:  done
Starting php-fpm54:  done
Restarting nginx.
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
Shutting down nginx: 
Starting nginx: 
Cannot find /usr/include/db.h.  Please install db.h
apt-get install libdb4.8-dev libperl-dev libsasl2-dev
s01:/usr/local/directadmin/custombuild# apt-get install libdb4.8-dev libperl-dev libsasl2-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package libdb4.8-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'libdb4.8-dev' has no installation candidate

"libdb4-8-dev" does not exist for Debian 7.
 
@password:
1) Regarding the /var/lib/mysql/sock, that path is not correct. For Debian, it should be /tmp/mysql.sock.
Note that the configure.php* files are set to /var/lib/mysql/mysql.sock by default, and changed with a perl regex, as needed.
If the /tmp/mysql.sock was missing when php was compiled, that might explain the wrong paths.

2) For libdb4.8-dev, it might be libdb5.1-dev... Check your system with:
Code: 
dpkg --get-selections | grep libdb
to see what you've got, and append the -dev bit to add the package.


For anyone who need to downgrade to MySQL 5.5 from 5.6, see this guide:
http://help.directadmin.com/item.php?id=513
but do it before adding any databases, else you'll have to backup/restore.

John
 
Debian 7 fresh installation. No go!

Fresh installation of Debian 7 x64
Only extra package installed: ssh
License is Debian 7

My options during ./setup.sh:
custombuild 2.0
Code: 
Would you like the default settings of apache 2.4 with mod_ruid2 and php 5.4 cli? (y/n): n
You have chosen to customize the custombuild options.  Please wait while options configurator is downloaded... 
Which webserver would yo like to use? (apache/nginx): apache
Which FTP server would yo like to use? (proftpd/pureftpd): pureftpd
What PHP release should be installed as a default one? (5.3/5.4/5.5): 5.5
What mode should the default instance of PHP use? (mod_php/suphp/php-fpm/fastcgi): mod_php
Would you like to have a second instance of PHP installed? (yes/no): no
Would you like to have mod_ruid2? (yes/no): yes
Would you like to have ionCube? (yes/no): no
Would you like to have Zend Optimizer? (yes/no): no
Would you like to have an ability to update MySQL using CustomBuild? (yes/no): no
Would you like to prevent htaccess files from using Options FollowSymLinks? More secure, but may break scripts. (yes/no): yes
Would you like to have an ability to update/instal Exim using CustomBuild? (yes/no): yes
Would you like to have an ability to install Dovecot? (yes/no): yes
Would you like to have an ability to install/update phpMyAdmin using CustomBuild? (yes/no): yes
Would you like to have an ability to install/update SquirrelMail webmail using CustomBuild? (yes/no): no
Would you like to have an ability to install/update RoundCube webmail using CustomBuild? (yes/no): yes
Would you like to search for the fastest download mirror? (y/n): n

Downloads & build process starts...

After a while it outputs:

Code: 
*************************************
*                                   *
*   All parts have been installed   *
*                                   *
*************************************

Type: /etc/init.d/httpd restart
./directadmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
./directadmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory

System Security Tips:
  http://help.directadmin.com/item.php?id=247


*********************************
*
* Cannot find /usr/local/directadmin/conf/directadmin.conf
* Please see this guide:
* http://help.directadmin.com/item.php?id=267
*
*********************************

I tried to insert libmysqlclient.so.16:

Code: 
root@web1:~#cd /usr/local/mysql/lib
root@web1:~# wget http://files.directadmin.com/services/debian_6.0_64/libmysqlclient.so.16
root@web1:~# chmod 755 libmysqlclient.so.16
root@web1:~# ldconfig
root@web1:~# /etc/init.d/directadmin start
Starting DirectAdmin: [ OK ]

1. Downloading libmysqlclient.so.16 seems to do the trick for MySQL
2. http was not started. Tried to start it manually:

Code: 
root@web1:~# /etc/init.d/httpd start
Starting httpd: httpd: Syntax error on line 183 of /etc/httpd/conf/httpd.conf: Syntax error on line 23 of /etc/httpd/conf/extra/httpd-vhosts.conf: Could not open configuration file /etc/httpd/conf/ips.conf: No such file or directory

3. DirectAdmin said it was started with OK, however nothing is listening on :2222, and /var/log/directadmin is empty. I debuged with:
Code: 
root@web1:~# strace /usr/local/directadmin/directadmin
fstat(1, {st_mode=S_IFCHR|0600, st_rdev=makedev(136, 0), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f95a4316000
write(1, "Unable to read config file. Unab"..., 110Unable to read config file. Unable to open /usr/local/directadmin/conf/directadmin.conf for reading.<br>

So directadmin.conf doesn't seem to have been generated during installation either.

Ideas?

/Martin
 
./directadmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
./directadmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
Click to expand...
we provide static binaries for Debian 7.
Your binaries are not static, hence that error, meaning the OS set in your license is likely a wrong OS.

Related:
http://help.directadmin.com/item.php?id=318

Send us the license ID and full OS output, and we can change the OS for you.

John
 
You must log in or register to reply here.
Back
Top