Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
PHP mysql extension for mysql
View previous topic :: View next topic  
Author Message
cybofax
Junior Member


Joined: 26 Jan 2015
Posts: 4
Location: UK

PostPosted: Mon Feb 02, 2015 4:33 pm    Post subject: PHP mysql extension for mysql Reply with quote

Hi all,

The PHP mysql extension won't load when uncommented in php.ini

Quote:
"...PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/msql.so' - /usr/lib/php/extensions/msql.so: cannot open shared object file: No such file or directory in Unknown on line 0..."


This can't be installed using slapt-get (e.g. php5-mysql)

Quote:
"...Reading Package Lists...Done
No such package: php5-mysql..."


Is there a way to get this installed? Or would it break something?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Mon Feb 02, 2015 9:32 pm    Post subject: Reply with quote

mysql extension is already uncomment and loaded by default...
extension=mysql.so

You can see it at phpinfo.php also...

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
cybofax
Junior Member


Joined: 26 Jan 2015
Posts: 4
Location: UK

PostPosted: Mon Feb 02, 2015 10:46 pm    Post subject: Reply with quote

Hi gerasimos_h,

Thanks for the quick reply. OK - it looks like I commented out msql.so which gives the error. Very sharp-eyed of you!

The only error I get now is

Quote:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/xsl.so' - /usr/lib/php/extensions/xsl.so: undefined symbol: dom_node_class_entry in Unknown on line 0


Now this may or may not have a bearing on my "original" issue which is getting the webshop part of webERP working. I will do some more troubleshooting! I was told by the webERP guy that the extension was required and I leapt on this as being a possible cause of the php script not working.

Please mark this as "solved" and I'll do some further testing.

Thanks again!
Smile
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Feb 03, 2015 8:29 am    Post subject: Reply with quote

Which SMS version do you have...?

Also if you upgrade php from slapt-get, we switch to php-5.4 so you need to switch /etc/httpd/php.ini and restart apache
Code:
cp /etc/httpd/php.ini{.new,}
apachectl stop
apachectl start


gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
cybofax
Junior Member


Joined: 26 Jan 2015
Posts: 4
Location: UK

PostPosted: Tue Feb 03, 2015 2:16 pm    Post subject: Reply with quote

Version from uname is
Linux sms 3.4.67 #2 Sat Oct 26 23:18:05 EEST 2013

phpinfo()
PHP Version => 5.4.37

I do have a php.ini at /etc/httpd
I did a cp and restarted apache as suggested.
Quote:

]root@sms:~# ls /etc/httpd -lash
total 576K
4.0K drwxr-xr-x 4 root root 4.0K Feb 3 11:52 ./
12K drwxr-xr-x 99 root root 12K Feb 2 13:05 ../
4.0K drwxr-xr-x 2 root root 4.0K Sep 14 18:44 extra/
20K -rw-r--r-- 1 root root 18K Jan 5 10:21 httpd.conf
20K -rw-r--r-- 1 root root 18K Sep 4 2010 httpd.conf.new
16K -rw-r--r-- 1 root root 13K Feb 16 2008 magic
32K -rw-r--r-- 1 root root 29K Feb 16 2008 mime.types
4.0K -rw-r--r-- 1 root root 783 Mar 21 2014 mod_perl.conf
4.0K -rw-r--r-- 1 root root 783 Nov 14 2012 mod_perl.conf.example
4.0K -rw-r--r-- 1 root root 903 Mar 16 2013 mod_php.conf
4.0K -rw-r--r-- 1 root root 903 Sep 8 2007 mod_php.conf.example
4.0K -rw-r--r-- 1 root root 903 May 25 2008 mod_php.conf.new
4.0K drwxr-xr-x 3 root root 4.0K Feb 16 2008 original/
68K -rw-r--r-- 1 root root 67K Feb 3 11:43 php.ini
68K -rw-r--r-- 1 root root 65K Jan 23 20:29 php.ini-development
44K -rw-r--r-- 1 root root 44K May 7 2008 php.ini-dist
68K -rw-r--r-- 1 root root 65K Jan 23 20:29 php.ini-production
48K -rw-r--r-- 1 root root 47K May 7 2008 php.ini-recommended
68K -rw-r--r-- 1 root root 67K Jun 15 2012 php.ini.new
68K -rw-r--r-- 1 root root 67K Feb 3 11:52 phph.ini
4.0K -rw-r--r-- 1 root root 1.2K Feb 5 2013 server.cert
4.0K -rw-r--r-- 1 root root 1.2K Feb 5 2013 server.crt
4.0K -rw------- 1 root root 1.7K Feb 5 2013 server.key
root@sms:~#


webERP appears to run fine - I just have a problem with getting the webshop to run. It seems to have an issue with the database credentials - I'm not sure why as the credentials are correct in weberps config.php and the webshop's config is pointing to it.
Quote:
The configuration in the file config.php for the database user name and password do not provide the information required to connect to the database server
Click here to try logging in again
The weberp guy mentioned the PHP mysql extension - but as you pointed out - those are there anyway. He also mentions that the dbType should be mysqli and not mysql - but that is also correct in weberp's config.php.

Would it be possible to (re) install weberp on SMS? I hear version 12 was released recently.
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Feb 03, 2015 8:51 pm    Post subject: Reply with quote

I don't know webshop, do you have a separate config.php on webshop or a setup to install extra tables in database...?

Can I take a look to see what is this all about?

You can upgrade or reinstall weberp, although I don't see how this will solve your problem...

just untar latest weberp on your webserver and try it...


gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
cybofax
Junior Member


Joined: 26 Jan 2015
Posts: 4
Location: UK

PostPosted: Tue Feb 03, 2015 9:05 pm    Post subject: Reply with quote

Hi gerasimos_h,

the webshop is an add-on that the developer of webERP wrote to enable (say) paypal purchases but it uses all the information from webERP. He is as mystified as you seem to be and he has requested credentials to have a look.
There is an "extra" config.php for the webshop scripts but apart from the database name - it relies on webERP's config.php to access the database.
I'll keep you posted - however if you want to have a look anyway - let me know.
By the way - thanks for your support!
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Tue Feb 03, 2015 9:31 pm    Post subject: Reply with quote

I'm not mystified, it's that I don't know how webshop installs, and since I provide webERP, I would like to know if there is a problem with purchased addons...

You can pm me the login information whenever you are ready or if the webERP developer finds what's wrong let me know...

Also please take a look at securing and optimizing you server, for changing default passwords., including weberp's database credentials...

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional