I am using till's Perfect server setup on suse 11.1 and i get the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Till can u update the links to some of the rpm from open suse resipotory. some say errors file not found
Please post the output of: netstat -tap SuSE is constantly changing the names, I've updated them already a few times. I will lookup the names again and update them.....
netstat -tap output login as: root Using keyboard-interactive authentication. Password: Last login: Thu Jul 23 12:08:00 2009 Have a lot of fun... mail:~ # netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:vid *:* LISTEN 3561/famd tcp 0 0 localhost:10024 *:* LISTEN 3590/amavisd (maste tcp 0 0 *:sunrpc *:* LISTEN 2731/rpcbind tcp 0 0 mail:domain *:* LISTEN 3506/named tcp 0 0 mail:domain *:* LISTEN 3506/named tcp 0 0 mail.uwasnet.org:domain *:* LISTEN 3506/named tcp 0 0 localhost:domain *:* LISTEN 3506/named tcp 0 0 *:ftp *:* LISTEN 3453/pure-ftpd (SER tcp 0 0 *:ssh *:* LISTEN 3476/sshd tcp 0 0 localhost:ipp *:* LISTEN 3559/cupsd tcp 0 0 *:smtp *:* LISTEN 3834/master tcp 0 0 localhost:953 *:* LISTEN 3506/named tcp 0 0 mail:ssh 192.168.1.6:solera-lpn ESTABLISHED 4457/0 tcp 0 0 *:imaps *:* LISTEN 2829/couriertcpd tcp 0 0 *op3s *:* LISTEN 2867/couriertcpd tcp 0 0 *op3 *:* LISTEN 2848/couriertcpd tcp 0 0 *:imap *:* LISTEN 2809/couriertcpd tcp 0 0 *:sunrpc *:* LISTEN 2731/rpcbind tcp 0 0 *:www-http *:* LISTEN 3768/httpd2-prefork tcp 0 0 *:domain *:* LISTEN 3506/named tcp 0 0 *:ftp *:* LISTEN 3453/pure-ftpd (SER tcp 0 0 *:ssh *:* LISTEN 3476/sshd tcp 0 0 localhost:ipp *:* LISTEN 3559/cupsd tcp 0 0 *:smtp *:* LISTEN 3834/master tcp 0 0 localhost:953 *:* LISTEN 3506/named mail:~ # Till can i give you the login information for the server and you help me have a perfect server running ispconfig. I have a deadline of next week monday to have the organisation website, portal and mail running. please help me.
see the new output login as: root Using keyboard-interactive authentication. Password: Last login: Thu Jul 23 12:23:53 2009 from 192.168.1.6 Have a lot of fun... mail:~ # yast2 mail:~ # /etc/init.d/mysql restart Restarting service MySQL Shutting down service MySQL done Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds done mail:~ # netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:10024 *:* LISTEN 3597/amavisd (maste tcp 0 0 localhost:wpgs *:* LISTEN 3572/famd tcp 0 0 *:sunrpc *:* LISTEN 2721/rpcbind tcp 0 0 mail:domain *:* LISTEN 3502/named tcp 0 0 mail:domain *:* LISTEN 3502/named tcp 0 0 mail.uwasnet.org:domain *:* LISTEN 3502/named tcp 0 0 localhost:domain *:* LISTEN 3502/named tcp 0 0 *:ftp *:* LISTEN 3295/pure-ftpd (SER tcp 0 0 *:ssh *:* LISTEN 3286/sshd tcp 0 0 localhost:ipp *:* LISTEN 3571/cupsd tcp 0 0 *:smtp *:* LISTEN 3833/master tcp 0 0 localhost:953 *:* LISTEN 3502/named tcp 0 0 mail:ssh 192.168.1.6:nmsserver ESTABLISHED 4455/0 tcp 0 0 mail:smtp web46402.mail.sp1:40258 ESTABLISHED 4421/smtpd tcp 0 0 *:imaps *:* LISTEN 2819/couriertcpd tcp 0 0 *op3s *:* LISTEN 2856/couriertcpd tcp 0 0 *op3 *:* LISTEN 2837/couriertcpd tcp 0 0 *:imap *:* LISTEN 2800/couriertcpd tcp 0 0 *:sunrpc *:* LISTEN 2721/rpcbind tcp 0 0 *:www-http *:* LISTEN 3767/httpd2-prefork tcp 0 0 *:domain *:* LISTEN 3502/named tcp 0 0 *:ftp *:* LISTEN 3295/pure-ftpd (SER tcp 0 0 *:ssh *:* LISTEN 3286/sshd tcp 0 0 *:smtp *:* LISTEN 3833/master tcp 0 0 localhost:953 *:* LISTEN 3502/named mail:~ #
try these nad post outputs: /usr/sbin/mysqld mysqld_safe & /usr/bin/mysqld_safe /usr/bin/mysqld_safe --user=mysql & after that check if there are mysql processes that are hung ps -ef | grep mysql and kill them if there are, try again /etc/init.d/mysql start and post tail -50 /var/log/messages
worked i have just reinstalled the mysql....now i have another problem....in the process of changing my password after login into ispconfig 3.0.1 a co-worker typed in a password and he cant remember it or email used. is there a way apart from the password lost that we can recover the admin password...when logged into the suse 11.1 box
How do i use phpmyadmin How do i use the phpmyadmin to do that? Then secondly is there a user manual for using ispconfig 3.0.1? I am new to all this stuff.....need to recover the admin password and have a website up in like 2hrs time....pls help me...coz it seems phpmyadmin doesnt work.....cant i just log into the mysql database and change....pls show me how and the table to change
you log in with phpmyadmin and then on the left side you select ispconfig db witch is by default dbispconfig after that you press SQL tab in the main window and then it says: Run SQL query/queries on database dbispconfig: and this is where you type next: update sys_user set passwort = md5('newpassword') WHERE username = 'usernameyouchange'; in this case it's the admin so you set admin there let me know what you done
sorry sorry for been such a disturbance. i have logged into the suse 11.1 server and run the command mysql -p. What next? Can you just right down for me the steps on how to do the above and also the commands to execute?
your totaly mixing things: mysql -p logs you in console mode and myphpadmin is the gui that you use from browser window... as for command line it would look like this after you log in: UPDATE dbispconfig.sys_user SET passwort = MD5('passhere') WHERE sys_user.username='admin'; QUIT
Good My server has two network cards......it is an email server and a network server for the organisation.....when i deactivate the firewall in yast2 my internet goes down and i cant access it on the LAN....what do i do? Is there a quick user guide on using ispconfig? The username problem has been solved....now i can login.
there is no documentation atm for ispconfig 3, it's work in progress Don't understand why your internet goes down if firewall is disabled. Need more info for that to be able to help you.
So how do i go abt it So how do i go abt it to have my website up like in one hr.....there is this stuff of ftp.....the site is built using joomla and i need to upload it in like 30mins. Which info do u need.....i am ready to offer it to you.....on the go
well if your not sure atm don't disable firewall... in isp config go make a site and after that make a username for that site/domain and basicly your set to go. Note that after you make ftp user click again on ftp user menu and there you will see it's username becouse it might have prefix so it won't be username you chose but maybe 01username or w/e after that u can log in withuser name to upload your stuff in web directory
Problem installing squirrelmail Problem installing squirrelmail mail:~ # rpm -i http://download.opensuse.org/reposi...1.1/noarch/squirrelmail-1.4.19-4.1.noarch.rpm error: /var/tmp/rpm-xfer.ih7K3b: headerRead failed: hdr blob(54247): BAD, read returned 10816 error: /var/tmp/rpm-xfer.ih7K3b cannot be installed mail:~ # And the following when installing phpmyadmin mail:~ # rpm -i http://download.opensuse.org/reposi...nSUSE_11.1/noarch/phpMyAdmin-3.2.0-1.1.noarch error: skipping http://download.opensuse.org/reposi...nSUSE_11.1/noarch/phpMyAdmin-3.2.0-1.1.noarch - transfer failed - Unknown or unexpected error warning: u 0x80872a8 ctrl 0x8088098 nrefs != 0 (download.opensuse.org http) What is wrong?
you having problem downlaoding since your installing from the server direct, try to download/wget files first and then install them like wget urloffile rpm -ivh file.rpm
Downloading and installing rpm i am downloading squirrelmail-1.4.19-4.1.noarch.rpm and phpMyAdmin-3.2.0-1.1.noarch.rpm to my /tmp folder. How do i install them after that?